Cfa 2 Review

Front 1

By default all areas of the worksheet will print.

Back 1

True

Front 2

The _________ command allows
information to repeat on each printed
page

Back 2

Print area

Front 3

Footers will be printed immediately below the last line of data on the worksheet.

Back 3

False

Front 4

Excel creates an associated PivotTable with each PivotChart.

Back 4

True

Front 5

An entire worksheet may be hidden
by choosing hide on the _________.

Back 5

Sheet tab shortcut menu

Front 6

Which of the following is not a
component of a data series?

Back 6

Series label

Front 7

Which symbol is displayed
throughout a cell when there is not
enough width to accommodate the
entry?

Back 7

#

Front 8

Which button on the Home Ribbon
will allow additional decimal spaces
to be displayed?

Back 8

Increase decimal

Front 9

The only way to copy a worksheet in a workbook is to use the copy command on the
shortcut menu.

Back 9

False

Front 10

Worksheet names may not exceed 31 characters.

Back 10

True

Front 11

Dates are considered text data so they are automatically left aligned in the cell.

Back 11

False

Front 12

Formatting a worksheet could possibly change the data on the sheet.

Back 12

False

Front 13

The Save option on the Quick Access Toolbar may not be used the first time that you
save a workbook.

Back 13

False

Front 14

__________ enhances the readability
of a worksheet.

Back 14

Formatting