- A function inside another function is called a ….. function.
a. Nested
b. Round
c. Sum
d. Text - How should you print a selected area of a worksheet, if you’ll
want to print a different area next time?
a. On the file menu, point to print area, and then click set print area.
b. On the file menu, click print, and then click selection under print
what
c. On the view menu, click custom views, then click add
d. All of above - Your German supplier still invoices for parts in deutsche
marks. How can you have Excel convert those sums to Euros?
a. On the Insert menu, click Symbol and from the currency symbols
subset, select the Euro sign.
b. On the tools menu, click Add-Ins, and select the Euro Currency
Tools check box
c. Apply a selected background color
d. All of above - Which function calculates your monthly mortage payment?
a. PMT (payments)
b. NPER (number of periods)
c. PV (present value)
d. All of above - 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?
a. Point to speech on the tools menu, and then click show text to
speech toolbar.
b. Click validation on the data menu
c. Point to speech on the tools menu, and then click speech
recognition
d. All of above - Which of the following methods can not be used to enter data
in a cell?
a. Pressing an arrow key
b. Pressing the tab key
c. Pressing the Esc key
d. Clicking the enter button to the formula bar
- Which of the following will not set text in selected cells to italics?
a. Pressing Ctrl + I on the keyboard
b. Using the Tools – Wizard – Web Form menu item
c. Using the Format – Cells – Font menu item
d. None of the above - Which of the following methods cannot be used to edit the content of cell?
a. Pressing the Alt key
b. Clicking the formula bar
c. Pressing F2
d. Double clicking the cell - Which of the following is not an option in the spelling dialog box?
a. Edit
b. Ignore
c. Ignore all
d. Change - You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
a. Edit
b. View
c. Format
d. Tools
_______________________________________________________________________________
Leave a Reply