3Q Computer Review 4

What is the use of freeze panes?

• to make sure that the formula is copied to another cell

• to make sure that the headers remain visible

• it will automatically calculate the results based on the data stored in worksheet

This refers to a range of cells in row 20 and columns B through G.

• B20:G20

• B20 and G20

• B20, G20

This refers to a cell in column R and row 33.

• R:33

• R33

• 33R

What kind of chart is this?

• hierarchy

• pie

• column

What kind of chart is this?

• hierarchy

• pie

• column

What kind of chart is this?

• line

• pie

• column

What kind of chart is this?

• line

• hierarchy

• column

How does a relative references work?

• Relative references will fill cells data based on data in other cells.

• Relative references will lock more than one row or column, or lock both rows and columns at the same time.

• Relative references change when a formula is copied to another cell.

This refers to all cells in row 17.

• 17

• 17:17

• 17, 17

A feature in Excel that will fill the cells with data that follows a pattern or is based on data in other cells.

• freeze panes

• cell references

• auto fill