Site MapHelpFeedbackMixed Quiz
Mixed Quiz
(See related pages)



1

Which of the following errors indicates that text in a formula was not recognized?
A)A. #VALUE!
B)B. #DIV/0!
C)C. #REF!
D)D. *#NAME?
2

Which of the following is an example of a relative reference?
A)A. A$1
B)B. $A$1
C)C. $A1
D)D. *A1
3

Cell references which do not change when copied and pasted are
A)A. relative.
B)B. mixed.
C)C. *absolute.
D)D. hard-coded.
4

To copy a worksheet, choose
A)A. Edit/Copy
B)B. Tools/Sheet
C)C. *Edit/Move or Copy Sheet
D)D. File/Save As
5

Which of the following is an invalid sheet name?
A)A. Sales & Revenue
B)B. *Profit/Loss
C)C. Sales 2007
D)D. Profit_And_Loss
6

To clear a group selection,
A)A. *choose Ungroup sheets from the tab shortcut menu.
B)B. choose Edit/Group/Ungroup.
C)C. hold the Ctrl key down while selecting all of the sheets.
D)D. click on the Ungroup button on the Formatting toolbar.
7

If you move to the leftmost column in the window and freeze the panes, you will get
A)A. two vertical panes.
B)B. no change.
C)C. four panes.
D)D. *two horizontal panes.
8

When a window is split into panes, the panes are separated by the
A)A. Split Window toolbar.
B)B. *pane divider.
C)C. frame.
D)D. ruler.
9

Which tool is used to find the value needed in one cell to attain a result you want in another cell?
A)A. Solver
B)B. Equation Manager
C)C. *Goal Seek
D)D. Scenarios
10

The location where one page ends and the next begins is called what?
A)A. *page break
B)B. margin
C)C. section
D)D. print area
11

If a formula contains an invalid cell reference, the error #REF! will be returned.
A)True
B)False
12

When you copy a range into a new sheet, the column widths on the new sheet are adjusted.
A)True
B)False
13

The Find command cannot be used to find cells with a certain format.
A)True
B)False
14

Each pane in a split window can be scrolled independently.
A)True
B)False
15

Landscape is the default page orientation.
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 > Lab 3 > Mixed Quiz