Module 4 Questions

What keyboard shortcut can you use to insert a table?

• Ctrl+T
• Ctrl+Shift+=
• Ctrl+Shift+L
• Ctrl+Shift+-

What are the steps you need to take to turn the Filter button on or off? Select all that apply.

• Go to the Design tab, Table Styles Options group, and select/clear the Filter button. (Correct)
• Go to the Home tab, Editing group, Sort & Filter, and select Filter. (Correct)
• Go to the Data tab, Sort & Filter group, and select Filter. (Correct)
• With a table cell selected, right-click or access the context menu, select Filter, and then select either Clear Filter from, or Reapply

Which table row calculates numeric data by using functions?

• Header row
• Total row
• Banded row
• Footer row

_______________ are even rows that are formatted differently than odd rows.

• Formatted Rows
• Horizontal Rows
• Banded Rows
• Rows

The command _______________ provides a way to select additional rows and columns to include in an existing table.

• Resize Table
• Reuse Table
• Table Options

What keyboard shortcut can you use to turn on or turn off a Total Row at the end of the table?

• Ctrl+F
• Ctrl+Shift+T
• Ctrl+Shift+F
• Ctrl+T

The _______________ check box displays special formatting for the first column of the table.

• Column format
• Other columns
• First column
• Column 1st

_______________ are even columns formatted differently than odd columns.

• Even columns
• Banded columns
• Column options

A range can be named in the Name Box.

• True
• False

Which of the following options cannot be part of a range name?

• Space
• Number
• Period
• Underscore