Site MapHelpFeedbackLesson 08 Quiz
Lesson 08 Quiz
(See related pages)

1
In an Excel table, which of the following tasks allows you to arrange rows in order by the data in one of the columns?
A)Arranging
B)Filtering
C)Organizing
D)Sorting
2
Which of the following objects is a defined name for an identifiable range in an Excel table?
A)Structured reference
B)Referenced structure
C)Range structure
D)Range name
3
Which of the following properties is part of a custom view for an Excel workbook?
A)Column widths
B)Active cell, row, and column
C)Folder name
D)Active sheet
4
What is the name of the Excel command that eliminates records with the same data in an Excel table?
A)Delete Duplicates
B)Erase Duplicates
C)Purge Duplicates
D)Remove Duplicates
5
Which of the following choices describes a cell in a calculated column in an Excel table with a formula that is different from other cells in the same column?
A)A calculated column option
B)A calculated column exception
C)A calculation anomaly
D)A duplicated calculation
6
When two Excel workbooks are open at the same time, which of the following keyboard shortcut moves from one workbook to the other?
A)[Ctrl]+[F4]
B)[Ctrl]+[F6]
C)[Ctrl]+[F8]
D)[Ctrl]+[F10]
7
Which of the following arguments is not used in an Excel SUMIFS function?
A)Sum_range
B)Criteria_range1
C)Criteria1
D)Logical_test
8
Which of the following Excel format codes would display a month spelled out, such as September?
A)mm
B)mmmm
C)"m"m
D)MM"m"
9
In a Sort dialog box in an Excel table, which of the following commands enables you to sort by multiple columns?
A)Add level
B)Copy level
C)Add sort
D)Copy sort
10
If a custom Excel filter sets either Oregon or Washington as the State field, which of the following choices describes the records that would be shown?
A)Only rows in which the state is Oregon
B)Only rows in which the state is Washington
C)No rows
D)Rows in which the state is either Oregon or Washington





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


Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 08 Quiz