Microsoft Excel

Front

Which of the following will pull out the lowest number? SUM, MAX, AVERAGE, MIN

Back

MIN

Front

What part of a spreadsheet is vertical? Options: Formula Bar, Row, Column, Cell

Back

Column

Front

Which part of a spreadsheet is horizontal? Options: formulas bar, column, row, cell

Back

row

Front

Which of the following is a function? John Jones, $5.00, =sum(A1:A5), =A1+A5

Back

=sum(A1:A5)

Front

When following the Order of Operations, which of the following would be performed FIRST? Multiplication, Exponentials, Parenthesis, Division

Back

Parenthesis

Front

Values are aligned on which side of a cell?

Back

Right

Front

Which of the following will produce a number that is calculated by adding quantities together and then dividing the total by the number of quantities?
Options: SUM, AVERAGE, MAX, MIN

Back

AVERAGE

Front

Labels align on which side of a cell?

Back

Left

Front

Which of the following is a correct cell address? A1, 1A, A

Back

A1

Front

What part of cell is represented by letters?

Back

columns