UNIT 4, SPREADSHEETS UPDATED ACTUAL EXAM
QUESTIONS AND CORRECT ANSWERS
Question 1.
Name box or Cell Reference Box
ANSWER
identifies the active cell or range of cells selected
Question 2.
Pie Chart
ANSWER
A chart that shows the relationship of a part to a whole
Question 3.
Clip art
ANSWER
Electronic artwork available on the computer.
, Question 4.
Maximum function
ANSWER
A function that finds the highest number in a range of cells.
Question 5.
Auto Fill
ANSWER
a quick and easy way to copy the contents of one cell (data or formulas) into another cell or
range of cells
Question 6.
Scroll Bars
ANSWER
The sliding bars found along the right and bottom of the screen, allowing you to see other
parts of a long document.
Question 7.
Average Function
ANSWER
an excel function that adds a group of values, and then divides the result by the number of
values in the group.
QUESTIONS AND CORRECT ANSWERS
Question 1.
Name box or Cell Reference Box
ANSWER
identifies the active cell or range of cells selected
Question 2.
Pie Chart
ANSWER
A chart that shows the relationship of a part to a whole
Question 3.
Clip art
ANSWER
Electronic artwork available on the computer.
, Question 4.
Maximum function
ANSWER
A function that finds the highest number in a range of cells.
Question 5.
Auto Fill
ANSWER
a quick and easy way to copy the contents of one cell (data or formulas) into another cell or
range of cells
Question 6.
Scroll Bars
ANSWER
The sliding bars found along the right and bottom of the screen, allowing you to see other
parts of a long document.
Question 7.
Average Function
ANSWER
an excel function that adds a group of values, and then divides the result by the number of
values in the group.
