Computer Concepts in Action

Unit 5: Spreadsheets

Pre-Quiz



1.

Why is it important to know how to use a computer before you buy one?
2.

_____ refers to how fast a computer works.
A)Performance
B)Memory
C)Storage
D)Modem
3.

_____ lets computers talk to each other.
A)Storage
B)Random access memory (RAM)
C)A Network
D)A Microprocessor
4.

A table of data that is organized into rows and columns is called a _____.
A)workbook
B)worksheet
C)range
D)cell
5.

What is a row?
A)A vertical line of cells
B)A calculation that describes the relationship between cells
C)A file that holds your worksheets
D)A horizontal line of cells
6.

What is a column?
A)A horizontal line of cells
B)A vertical row of cells
C)A table of data in Excel
D)The box that tells you which cell is selected
7.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/U05_002SC_861235_RS.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 Formula bar?
A)A
B)B
C)C
D)D
8.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/U05_004SC_861235_RS.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"> (57.0K)</a>
Which box will tell you which cell is selected?
A)A
B)B
C)C
D)D
9.

How do you return the cell pointer to A1?
A)Ctrl + Down arrow
B)Ctrl + Up arrow
C)Ctrl + Home key
D)Ctrl + End key
10.

Row headers are listed in the first _____.
A)row
B)column
C)cell
D)table
11.

How do you enlarge the width of a column?
A)Place the mouse pointer on the horizontal row line, then click and drag the double arrow to the left.
B)Place the mouse pointer on the horizontal row line, then click and drag the double arrow to the right.
C)Place the mouse pointer on the vertical column line, then click and drag the double arrow to the left.
D)Place the mouse pointer on the vertical column line, then click and drag the double arrow to the right.
12.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/U05_009SC_861235_RS.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"> (67.0K)</a>
Which button do you click to accept changes you've made to the content of a cell?
A)A
B)B
C)C
D)D
13.

The _____ button lets you copy text into a cell instead of inserting the next higher number.
A)Auto Sum
B)Auto Fill Options
C)Auto Fit
D)Update File
14.

What is a range?
A)A group of cells
B)A single cell
C)A column heading
D)A row heading
15.

How do you insert a new column?
A)Click the Insert menu, then click Function.
B)Click the Insert menu, then click Chart.
C)Click the Insert menu, then click Columns.
D)Click the Insert menu, then click Rows.
16.

How do you format data into dollars and cents?
A)Click the Currency style button
B)Click the Auto Sum button
C)Click the Percent Style button
D)Click the Increase decimal button
17.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/U05_016SC_861235_RS.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"> (62.0K)</a>
Which button would you click to merge cells?
A)A
B)B
C)C
D)D
18.

An arithmetic operator is a symbol that represents a specific action.
A)True
B)False
19.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/PQ5_05_RS.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"> (14.0K)</a>
Which of the following is the Auto Sum button?
A)A
B)B
C)C
D)D
20.

Which of the following built-in formulas would you use to total data?
A)Average
B)Minimum
C)Sum
D)Maximum
21.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078612357/271274/PQ5_06_RS.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"> (14.0K)</a>
Which button would you click to copy a formula?
A)A
B)B
C)C
D)D
22.

A _____ is a way of arranging data in a particular order.
A)sort
B)criteria
C)formula
D)filter
23.

How do you find data with just the information you need?
A)Use the Chart Wizard.
B)Use AutoSum.
C)Use a filter.
D)Use Merge and Center.
24.

Which of the following is a way to reduce the amount of information you see?
A)Descending sort
B)Hide
C)AutoFormat
D)The AutoSum function
25.

A chart is also known as a(n) _____.
A)table
B)worksheet
C)average
D)graph
26.

A pie chart compares data _____.
A)vertically
B)horizontally
C)as parts of a whole
D)over a period of time
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.