Unit 3: Post Test: Working with Spreadsheets

The vertical divisions in a spreadsheet is called a _______________.

• workbook
• column
• row
• cell

Identify this type of chart.

• pie
• line
• scatter plot
• column

True or False Page orientation refers to wide and narrow.

• True
• False

After highlighting and copying information, which of the following are ways to paste information from one location to another? Mark all that apply.

• Right click, select paste
• Press Ctrl and V keys at the same time
• Press Ctrl and C keys at the same time

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

• +
• =
• *
• /

Identify this type of chart.

• pie
• line
• scatter plot
• column

True or False Scale to fit refers to width and height.

• True
• False

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?

• Alt and Page Down or Page Up keys
• Shift and Page Down or Page Up keys
• Ctrl and Page Up or Page Down keys

Which formula shows an absolute value cell address?

• $E$4 + $E$5
• E4
• #G#7 + #G#8
• G7 + G8

Which formula is the same as the function =SUM(B1:B5)?

• =B1+B5
• =B1+B2+B3+B4+B5

• =$B$1+$B$5
• =$B1+$B2+$B3+$B4+$B5