Computer Concepts in Action ©2009

Unit 5: Spreadsheets

e-Review Quizzes

1
What is a cell?
A)Where a row and a column intersect
B)A horizontal line in a table in Excel
C)A vertical line in a table in Excel
D)A file in Excel that contains three worksheets
2
The box that indicates which cell in a worksheet is selected is called the _____.
A)formula bar
B)cell pointer
C)task pane
D)range
3
The column letter and row number of a cell is called a _____.
A)cell address
B)header
C)cell pointer
D)formula
4
Which key do you use to move the cell pointer from one cell to another?
A)Enter
B)The space bar
C)The arrow keys
D)Page Down
5
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078805775/595819/Tech_Assess_Quiz_U05_SC01.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (208.0K)</a>

Which of the following is the Status bar?
A)A
B)B
C)C
D)D
6
How do you move the cell pointer to the last cell that contains data?
A)Ctrl + Down arrow
B)Ctrl + Up arrow
C)Ctrl + Home
D)Ctrl + End
7
In a well-organized worksheet, every column should have a label, or a _____ at the top.
A)range
B)cell address
C)header
D)footer
8
The tool that lets you automatically change the width of a column to fit the longest entry, or change the height of a row to fit the font is called _____.
A)AutoSum
B)Auto Fill Options
C)the update file
D)AutoFit
9
An arithmetic operator in Excel is a calculation that describes the relationship between cells.
A)True
B)False
10
A _____ is a built-in formula in Excel.
A)function
B)mean
C)median
D)hypotenuse
11
Which of the following formulas calculates how many cells are in a range?
A)Sum
B)Minimum
C)Maximum
D)Count Numbers
12
Which of the following terms refers to the change a formula makes when it is moved or copied to other cells with different data?
A)Relative addressing
B)AutoSum
C)Update file
D)AutoFit
13
The Count, Average, Max, and Min can be copied into different columns
A)True
B)False
14
Rows of data can be sorted by _____.
A)the cell address
B)function
C)criteria
D)the range
15
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078805775/595819/Tech_Assess_Quiz_U05_SC02.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (78.0K)</a>

Where can the column headers be found in the following window?
A)A
B)B
C)C
D)D
16
Which of the following would you use to sort data from lowest to highest, for example from A to Z or smallest number to largest?
A)Criteria
B)Sort
C)Ascending Sort
D)Descending Sort
17
When a filter is applied to a worksheet, what appears over each column of data?
A)Headers
B)Footers
C)Cell pointer
D)Drop-down arrows
18
A bar chart compares data _____.
A)vertically
B)horizontally
C)over a period of time
D)as parts of a whole.
19
Which tab would you access to hide columns?
A)The Home tab
B)The Format tab
C)The Data tab
D)The Edit tab
20
You can format the legend with a line style and color.
A)True
B)False
21
To move a chart on a worksheet, you can click on it and drag it.
A)True
B)False
22
A _____ chart compares parts of a whole (in percentages).
A)bar
B)column
C)lne
D)pie
23
The Excel file that holds worksheets is called a _____.
A)column
B)row
C)workbook
D)data sheet
24
What may need to be done to a column when #### appears after entering data into a cell?
A)The column needs to be widened because it may be too narrow for the data.
B)A header needs to be added to the column.
C)The column should be sorted.
D)A footer needs to be added to the column.
25
Which of the following displays the largest number in a range of cells?
A)Count
B)Sum
C)Average
D)Maximum
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe

Please read our Terms of Use and Privacy Policy before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.