Computer Concepts in Action

Unit 5: Spreadsheets

e-Review Quiz

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/0078612357/271281/U05_002SC_861235.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"> (61.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 key
D)Ctrl + End key
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 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
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/0078612357/271281/U05_037SC_861235.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"> (27.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
Where would you set the Data Range?
A)In the Chart Wizard
B)In the Format menu
C)In the Data menu
D)In the Edit menu
20
A _____ explains what each bar in a chart represents.
A)criteria
B)chart
C)legend
D)cell address
21
The y-axis is the horizontal line at the bottom of a chart.
A)True
B)False
22
A______chart compares parts of a whole (in percentages).
A)bar
B)column
C)lne
D)pie
23
How many worksheets does a workbook contain when a new file is created?
A)one
B)five
C)three
D)two
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 Notice before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.