Site MapHelpFeedbackMixed Quiz
Mixed Quiz
(See related pages)



1

To set the watch cell,
A)choose Insert/Watch/Selected Cell
B)select Add Watch from the shortcut menu
C)click the Watch button on the Formatting toolbar
D)choose Tools/Formula Auditing/Add Watch Cell
2

In Excel, this can be displayed when making changes to a worksheet to see the effect of those changes.
A)Formula window
B)Function window
C)Watch window
D)Tools window
3

If you are trying to determine a desired profit margin in an Excel worksheet, you could use all of the following except
A)the Solver tool
B)the NOW function
C)what-if analysis
D)the Goal Seek feature
4

Solver is a tool used to determine the effect of changing values in two or more cells on another cell, called the
A)target cell
B)source cell
C)adjustable cell
D)function cell
5

Which of the following is not an available Solver report?
A)Answer
B)Limits
C)Sensitivity
D)Error
6

In the Solver Parameters dialog box, you must supply all of the following items of information except
A)the cell or cells that will be changed to achieve the result
B)the target cell where the result will appear
C)the destination cell where the result will be sent
D)the result value
7

This is a workbook file that contains pre-designed worksheets that can be used as a pattern for creating similar sheets in new workbooks.
A)Workbook template
B)Workbook design
C)Workbook outlay
D)Workbook creator
8

What is the file extension for an Excel template file?
A).xls
B).txt
C).xlt
D).csv
9

Which of the following is not an advantage of using templates?
A)saves design time
B)save data entry time
C)maintains consistency from workbook to workbook
D)increases accuracy
10

This feature prevents users from changing a worksheet's contents.
A)encryption
B)protection
C)freeze panes
D)cell locking
11

Solver is an add-in program and may need to be installed before you can use it.
A)TRUE
B)FALSE
12

The purpose of Solver is to see how changing the input values of a formula will affect the output, called the adjustable cell.
A)TRUE
B)FALSE
13

If you are unsure of which cells are used to arrive at the value in the target cell, you can click the Guess command button in the Solver Parameters dialog box.
A)TRUE
B)FALSE
14

Every Excel workbook is based on a template.
A)TRUE
B)FALSE
15

Workbook templates are saved in the My Documents folder.
A)TRUE
B)FALSE





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


The O'Leary Series Office 2003Online Learning Center

Home > Excel 2 > Intro Lab 4 > Mixed Quiz