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
- (B) Create and edit formulas containing functions
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
- (B) Internet assistant 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
- (C) A formula that either directly or indirectly depends on itself
Which of following is Not one of Excel’s what-if function?
- (A) Goal seek
- (B) Solver
- (C) Scenario manager
- (D) Auto Outline
- (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
- (B) Linked
Which of the following is not information you can specify using the solver?
- (A) Input cells
- (B) Constraints
- (C) Target cell
- (D) Changing cells
- (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
- (C) It can contain many sheets including worksheets and chart sheets
Excel probably considers the cell entry January 1, 2000 to be a:
- (A) Label
- (B) Value
- (C) Formula
- (D) Text string
- (B) Value
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
- (A) Labels, values, and formulas
All worksheet formula:
- (A) Manipulate values
- (B) Manipulate labels
- (C) Return a formula result
- (D) Use the addition operator
- (C) Return a formula result