Excel Gmetrix Quiz

To begin a formula you must have _____ first.

• =

• +

• SUM

• ()

______is a feature that allows you to quickly apply the contents of new cell to another cell or range of cells selected.

• autofill

• autosum

• cell

• drag

Autofill looks like __________________.

• thick white cross/plus sign

• thin black cross/plus sign

• black square

• grey square

Which formula would you use to add cells together?

• =SUM()

• =MIN()

• =AVERAGE()

• =COUNT()

What tab would you use to use the paint bucket?

• home

• insert

• page layout

• formulas

Which formula would you use to find the highest sales number?

• =SUM()

• =MIN()

• =MAX()

• =AVERAGE()

_____is a rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

• autofill

• column

• cell

• excel box

_____is the cell in your worksheet that has been selected. It will have bolder grid-lines around it.

• column

• cell grid

• cell

• active cell

______is the vertical spaces with headings A, B, C, etc...

• column

• row

• cell

• drag

____is the horizontal spaces with headings 1, 2, 3, 4, etc.

• drag

• cells

• columns

• row