MICROSOFT EXCEL

You can use the formula palette to:

• (A) Format cells containing numbers
• (B) Create and edit formulas containing functions
• (C) Enter assumptions data
• (D) Copy a range of cells

You can convert existing excel worksheet data an charts to an HTML document by using:

• (A) FTP wizard
• (B) Internet assistant wizard
• (C) Intranet wizard
• (D) Import wizard

A circular reference is:

• (A) Geometric modeling tool
• (B) A cell that points to a drawing object
• (C) A formula that either directly or indirectly depends on itself
• (D) Always erroneous

Which of following is Not one of Excel’s what-if function?

• (A) Goal seek
• (B) Solver
• (C) Scenario manager
• (D) Auto Outline

When you insert an excel file into a word document? The data are:

• (A) Hyperlinked placed in a word table
• (B) Linked
• (C) Embedded
• (D) Use the word menu bar and toolbars

Which of the following is not information you can specify using the solver?

• (A) Input cells
• (B) Constraints
• (C) Target cell
• (D) Changing cells

Each excel file is called a workbook because:

• (A) It can contain text and data
• (B) It can be modified
• (C) It can contain many sheets including worksheets and chart sheets
• (D) You have to work hard to create it

Excel probably considers the cell entry January 1, 2000 to be a:

• (A) Label
• (B) Value
• (C) Formula
• (D) Text string

You can enter which types of data into worksheet cells?

• (A) Labels, values, and formulas
• (B) Labe3ls and values but not formulas
• (C) Values and formulas but not labels
• (D) Formulas only

All worksheet formula:

• (A) Manipulate values
• (B) Manipulate labels
• (C) Return a formula result
• (D) Use the addition operator