MICROSOFT EXCEL

You can open the scenario Manager dialog box by choosing scenarios from the menu:

• (A) View
• (B) Insert
• (C) Format
• (D) Tools

You can open the Sort dialog box by choosing Sort from the _________ menu

• (A) View
• (B) Format
• (C) Tools
• (D) Data

when working in the page break preview, you can:

• (A)  a view exactly where each page break occurs
• (B) add or remove page breaks
• (C) change the print area
• (D) all of above

A data map is helpful:

• (A) When you have too much data to chart
• (B) To show a geographic data distribution
• (C) To compare data points
• (D) To show changes in data over time

Rounding errors can occur:

• (A) When you use multiplication, division or exponentiation in a formula
• (B) When you use addition and subtraction in a formula
• (C) Because Excel uses hidden decimal places in computation
• (D) When you show the results of formulas with different decimal places than the calculated results

You can copy data or formulas:

• (A) With the copy, paste and cut commands on the edit menu
• (B) With commands on a shortcut menu
• (C) With buttons on the standard toolbar
• (D) All of the above

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 mortgage 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 yr 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