MICROSOFT EXCEL

Documentation should include:

• (A) Destination and users of the output data
• (B) Source of input data
• (C) Information on the purpose of the workbook
• (D) All of the above

Files created with Lotus 1-2-3 have an extension:

• (A) DOC
• (B) XLS
• (C) 123
• (D) WKI

To delete an embedded objects, first:

• (A) Double click the object
• (B) Select the object by clicking it
• (C) Press the Shift + Delete keys
• (D) Select it and then press the delete key

Comments can be added to cells using:

• (A) Edit > Comments
• (B) Insert > Comments
• (C) File > Comments
• (D) View > Comments

Which of the following is not a worksheet design criterion?

• (A) Efficiency
• (B) Auditability
• (C) Description
• (D) Clarity

To copy cell contents using drag and drop press the:

• (A) End key
• (B) Shift key
• (C) Ctrl key
• (D) Esc key

Which of the following is the latest version of Excel?

• (A) Excel 2000
• (B) Excel ME
• (C) Excel 2002
• (D) Excel XP

When you copy a formula?

• (A) Excel erases the original copy of the formula
• (B) Excel edits cell references in the newly copied formula
• (C) Excel adjusts absolute cell references
• (D) Excel doesn’t adjust relative cell references

The auto fill feature:

• (A) extends a sequential series of data
• (B) automatically adds range of cell values
• (C) applies a boarder around the selected cells
• (D) none of the above

Which menu option can be sued to split windows into two?

• (A) Format > window
• (B) View > window > split
• (C) Window > split
• (D) View > split