Unit 3: Post Test: Working with Spreadsheets

Front

The vertical divisions in a spreadsheet is called a _______________.

Back

column

Front

Identify this type of chart: pie, line, scatter plot, column

Back

column

Front

Page orientation refers to wide and narrow.

Back

False

Front

Which symbol should you use to enter a formula in a cell?

Back

=

Front

Identify this type of chart: pie, line, scatter plot, column

Back

line

Front

Scale to fit refers to width and height.

Back

True

Front

Sally needs to copy data from the first worksheet to the fifth worksheet in her workbook. Which combination of keys will she use to navigate between the worksheets?

Back

Ctrl and Page Up or Page Down keys

Front

Which formula shows an absolute value cell address? Options: $E$4 + $E$5, E4, #G#7 + #G#8, G7 + G8

Back

$E$4 + $E$5

Front

Which formula is the same as the function =SUM(B1:B5)? Options: =B1+B5, =B1+B2+B3+B4+B5, =$B$1+$B$5, =$B1+$B2+$B3+$B4+$B5

Back

=B1+B2+B3+B4+B5

Front

Identify this type of chart: pie, line, scatter plot, column

Back

scatter plot