What term refers to a specific set of values saved with the workbook?
Answer: B
Correct answer: Scenario
A scenario is a named set of input values stored with the workbook, so several sets of assumptions can be saved and switched between without retyping.
Please log in or register to report this question.
Got functions? No? You need the insert function dialog box. How do you get it?
Answer: B
Correct answer: Click the insert menu and then click function
The Insert Function dialog is opened from Insert > Function, or by the fx button beside the formula bar. Typing = starts a formula but does not open the dialog.
Please log in or register to report this question.
Which of the following describes how to select all the cells in a single column?
Answer: C
Correct answer: Left click on the gray column title button
Clicking the grey column heading selects the whole column. Ctrl + A selects the entire sheet rather than one column.
Please log in or register to report this question.
when you use the fill effects in the format data series dialog box, you can not
Answer: A
Correct answer: rotate text on the chart
Fill Effects offers gradients, textures, patterns and pictures, each with foreground and background colours. Rotating text is done from the axis or data label format dialog, not from a fill.
Please log in or register to report this question.
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Answer: C
Correct answer: Speed
A paper spreadsheet can have rows, columns and headings just as an electronic one does. What it cannot do is recalculate instantly when a figure changes, which is the whole advantage of the electronic form.
Please log in or register to report this question.
Which of the following is not a basic step in creating a worksheet?
Answer: D
Correct answer: Copy the worksheet
The basic steps are to enter the text and data, modify the layout, and save the workbook. Copying a worksheet is something you may do afterwards, not part of creating one.
Please log in or register to report this question.
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
Answer: A
Correct answer: Select both cells, and then drag the fill handle over the range you want, for instance 18 more cells
Two cells establish the step, and dragging the fill handle continues it. One cell alone would be copied rather than extended, since Excel would have no interval to work from.
Please log in or register to report this question.
To insert three columns between columns D and E you would
Answer: B
Correct answer: Select column E
Inserted columns appear before the selection, so selecting column E puts the new column between D and E. To insert three, select three columns starting at E.
Please log in or register to report this question.
To center worksheet titles across a range of cell, you must
Answer: A
Correct answer: Select the cells containing the title text and choose Center Across Selection in the Format Cells dialog box
Center Across Selection centres the text over the whole range while leaving the cells separate, so the columns can still be sorted and referenced individually. Merging them would centre the text too, but at the cost of destroying the cell structure. Widening a column moves the text, it does not centre it.
Please log in or register to report this question.
When integrating Ms-Word and Excel, Word is usually the
Answer: C
Correct answer: Client
When an Excel object is placed in a Word document, Excel supplies the data and Word receives it, so Word is the client and Excel the server. The names describe which application owns the data, not which is in front.
Please log in or register to report this question.
