Computer Concepts in Action ©2009

Unit 5: Spreadsheets

e-Quizzes–Pre-Quizzes


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 line of cells
		C)	A table of data in Excel
		D)	The box that tells you which cell is selected

7.	Which of the following is the Formula bar?

		A)	A
		B)	B
		C)	C
		D)	D

8.	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
		D)	Ctrl + End

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.	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 tab, then click Text Box.
		B)	Click the Home tab, then click the Cells button.
		C)	Click the Home tab, then click the Insert button.
		D)	Click the Insert tab, then click the Insert button.

16.	How do you format data into dollars and cents?

		A)	Click the Accounting Number Format button.
		B)	Click the Sum button
		C)	On the Home tab, click the Percent Style button
		D)	On the Home tab, click the Increase decimal button

17.	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.	Which of the following is the 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.	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