You can group noncontiguous worksheets with
Answer: C
Correct answer: The ctrl key and mouse
Ctrl with the mouse picks out sheets that are not next to each other; Shift selects a contiguous run of tabs. Grouped sheets then receive the same entries and formatting together.
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.
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.
You can print only an embedded chart by
Answer: D
Correct answer: a and c
An embedded chart prints on its own either by being moved to a chart sheet first, or simply by being selected before printing - selecting it makes it the print range. Formatting has no bearing on what is printed.
Please log in or register to report this question.
You can edit existing Excel data by pressing the
Answer: B
Correct answer: F2 key
F2 puts the active cell into edit mode with the cursor at the end of its contents, so it can be changed without retyping the whole entry.
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.
In MS Excel, what does Paste Special with the Values option do?
Answer: B
Correct answer: Pastes the results of formulas rather than the formulas themselves
Paste Special → Values pastes the calculated results, discarding the formulas that produced them. The cells become static numbers or text. It is used constantly for two reasons. It breaks a dependency, so a result survives when its source data is deleted or the sheet it referred to is removed. And it fixes a value in place, so a calculation whose inputs will change is frozen at a moment in time. Copying a cell onto itself and pasting values is the standard way to convert a whole column of formulas into constants. The dialogue, Ctrl + Alt + V, offers a good deal more: Formats pastes formatting alone, Transpose swaps rows and columns, Values and Number Formats keeps the appearance as well as the result, and the arithmetic options add, subtract, multiply or divide the destination by what was copied - a quick way to scale a whole range by a factor.
Please log in or register to report this question.
Charts tips can
Answer: D
Correct answer: b and c
A chart tip appears when the pointer rests on part of a chart, and it names the series and gives the value of the point under the pointer. It says nothing about formatting.
Please log in or register to report this question.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Answer: B
Correct answer: Right click on the spreadsheet tab and select DELETE
Sheets are managed from their tabs: right-clicking a tab offers Insert, Delete, Rename, Move or Copy. Save As changes the file, not its sheets.
Please log in or register to report this question.
To save a workbook, you:
Answer: A
Correct answer: Click the save button on the standard toolbar from the menu bar choose File >> Save
Saving is done from the toolbar button, from File > Save, or with Ctrl + S. Ctrl + F5 restores the window and the Windows Start button has no Save command.
Please log in or register to report this question.
