Excel Review

What is happening in B1?

• Calculation error
• You typed ########.
• The column is not wide enough.
• The row is not tall enough.

Using the circled function, what will appear in A5?

• 88
• SUM
• 8
• 22

How would you signify the group of highlighted cells?

• 2:14
• B2:B8
• B2-B8
• 2-8

Which of the following points would allow you to adjust the width of a column?

• 1
• 2
• 4
• 5

Which of the following points will allow you to AutoFill a formula to data to adjacent cells?

• 1
• 2
• 3
• 4

Which of the following points will allow you to select a range of cells?

• 1
• 2
• 3
• 5

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

• more rows and fewer columns.
• more rows and more columns.
• more columns and fewer rows.
• less columns and less rows.

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

• Remove it completely
• Add it to the chart
• Divide it into two points.
• Pull it away from the rest of the chart.

The shape representing each data point of a chart is:

• the legend.
• the data marker.
• the data series.
• the chart area.

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

• function
• chart
• formula
• if statement