Excel Review

Front

What is happening in B1? Options: Calculation error, You typed ########., The column is not wide enough., The row is not tall enough.

Back

The column is not wide enough.

Front

Using the circled function, what will appear in A5?

Back

88

Front

How would you signify the group of highlighted cells? Options: 2:14, B2:B8, B2-B8, 2-8

Back

B2:B8

Front

Which of the following points would allow you to adjust the width of a column? Options: 1, 2, 4, 5

Back

5

Front

Which of the following points will allow you to AutoFill a formula to data to adjacent cells? Options: 1, 2, 3, 4

Back

2

Front

Which of the following points will allow you to select a range of cells? 1, 2, 3, 5

Back

1

Front

Changing your page orientation from portrait to landscape will allow you to____.

Back

more columns and fewer rows.

Front

What will happen if you explode a data point in a pie chart?

Back

Pull it away from the rest of the chart.

Front

The shape representing each data point of a chart is:

Back

the data marker.

Front

Finding the AVERAGE of a range of cells is an example of a _____.

Back

function