A function inside another function is called a ….. function.
Answer: A
Correct answer: Nested
A function used as an argument of another is nested, as in =IF(SUM(A1:A5)>100,"high","low"). Excel allows several levels of nesting.
Please log in or register to report this question.
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Answer: B
Correct answer: On the file menu, click print, and then click selection under print what
Setting a print area stores it with the sheet, so it would have to be cleared before printing something else. Choosing Selection in the Print dialog applies to that one printing only, which is what the question asks for.
Please log in or register to report this question.
Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
Answer: B
Correct answer: On the tools menu, click Add-Ins, and select the Euro Currency Tools
Currency conversion is not built into Excel; it comes from the Euro Currency Tools add-in, which supplies the EUROCONVERT function and the fixed conversion rates. Inserting a symbol changes only the appearance of a number.
Please log in or register to report this question.
Which function calculates your monthly mortgage payment?
Answer: A
Correct answer: PMT (payments)
PMT returns the constant payment on a loan, given the rate, the number of periods and the present value:
\[ \text{PMT}(rate, nper, pv) \]
NPER computes how many periods are needed and PV the amount that can be borrowed.
Please log in or register to report this question.
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
Answer: A
Correct answer: Point to speech on the tools menu, and then click show text to speech toolbar
Text to Speech is reached from Tools > Speech, which displays a toolbar with a speak on enter button. Speech recognition, on the same submenu, is the opposite feature.
Please log in or register to report this question.
Which of the following methods can not be used to enter data in a cell?
Answer: C
Correct answer: Pressing the Esc key
Arrow keys, Tab and the tick on the formula bar all commit what has been typed. Esc abandons it and restores the previous contents, so it is the one that does not enter data.
Please log in or register to report this question.
Which of the following will not set text in selected cells to italics?
Answer: D
Correct answer: None of the above
Ctrl + I and Format > Cells > Font both apply italics, and the Tools > Wizard > Web Form item does not exist at all, so it cannot set italics either. Since the question asks which will not italicise and two of the three do, none of the listed options is the answer.
Please log in or register to report this question.
Which of the following methods cannot be used to edit the content of cell?
Answer: A
Correct answer: Pressing the Alt key
A cell is edited by clicking the formula bar, pressing F2, or double-clicking the cell. Alt activates the menu bar and does nothing to the cell.
Please log in or register to report this question.
You can activate a cell by
Answer: D
Correct answer: All of above
A cell becomes active when it is clicked, when Tab moves to it, or when an arrow key reaches it - all three simply move the selection.
Please log in or register to report this question.
Which of the following setup options can not be set in the page setup dialog box?
Answer: A
Correct answer: Printer selection
Page Setup covers orientation, scaling, margins, headers and footers, and the rows or columns to repeat on each page. Which printer to use is chosen in the Print dialog instead.
Please log in or register to report this question.
