WorksheetsExcel Review
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
What is happening in B1?
a)
Calculation error
b)
You typed ########.
c)
The column is not wide enough.
d)
The row is not tall enough.
2.
Using the circled function, what will appear in A5?
a)
88
b)
SUM
c)
8
d)
22
3.
How would you signify the group of highlighted cells?
a)
2:14
b)
B2:B8
c)
B2-B8
d)
2-8
4.
Which of the following points would allow you to adjust the width of a column?
a)
1
b)
2
c)
4
d)
5
5.
Which of the following points will allow you to AutoFill a formula to data to adjacent cells?
a)
1
b)
2
c)
3
d)
4
6.
Which of the following points will allow you to select a range of cells?
a)
1
b)
2
c)
3
d)
5
7.
Changing your page orientation from portrait to landscape will allow you to____.
a)
more rows and fewer columns.
b)
more rows and more columns.
c)
more columns and fewer rows.
d)
less columns and less rows.
8.
What will happen if you explode a data point in a pie chart?
a)
Remove it completely
b)
Add it to the chart
c)
Divide it into two points.
d)
Pull it away from the rest of the chart.
9.
The shape representing each data point of a chart is:
a)
the legend.
b)
the data marker.
c)
the data series.
d)
the chart area.
10.
Finding the AVERAGE of a range of cells is an example of a _____.
a)
function
b)
chart
c)
formula
d)
if statement
100 %
