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.
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.
In MS Excel, what does =A1>B1 return?
Answer: B
Correct answer: TRUE or FALSE
A comparison returns a logical value - TRUE or FALSE - not a number. =A1>B1 reports whether A1 exceeds B1. The comparison operators are =, >, <, >=, <= and <> for not equal. That last one catches people out, since it is written with two angle brackets rather than the mathematical symbol. Logical values behave as numbers in arithmetic, TRUE counting as 1 and FALSE as 0, which is what makes expressions such as =SUMPRODUCT((A1:A10>5)*1) work as a count. These comparisons are the raw material of the IF function, which turns them into useful results: =IF(A1>B1,"Higher","Lower"). To find the larger of two values - the second option - the function is MAX, and for the difference it is simple subtraction.
Please log in or register to report this question.
