Lesson 1-4 Test Corrections

Front 1

there is only two methods to open microsoft excel T/F

Back 1

False

Front 2

The quickest way to insert a new worksheet into a workbook is to use the insert worksheet tab
located to the right of the sheet tabs.T/F

Back 2

True

Front 3

Hiding worksheet data will delete the data. T/F

Back 3

True

Front 4

Formatting a worksheet could possibly change the data on the sheet T/F

Back 4

False

Front 5

When formatting data, most of the formatting commands are located on the Insert Ribbon.T/F

Back 5

False

Front 6

Freezing areas in a worksheet is only used to enhance the readability of the worksheet data T/F

Back 6

True

Front 7

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

Back 7

False

Front 8

Worksheet names may not exceed 31 characters T/F

Back 8

True

Front 9

To identify a cell, specify the row number first, followed by the column letter. T/F

Back 9

False

Front 10

In order to access the information on a ribbon, the user must select the

Back 10

Ribbon Tab

Front 11

The _____ command allows for only formatting to be copied from one cell to another.

Back 11

Format Special

Front 12

When the insert worksheet command is selected, where is the new sheet insert?

Back 12

To the right of all sheets

Front 13

By default, there are ____ date formats that may be applied to a cell.

Back 13

17

Front 14

Is NOT a freeze panes option

Back 14

Freeze panes

Front 15

The ____ command allows information to repeat on each printed page

Back 15

Print Area

Front 16

Page breaks may be manually inserted using the breaks command on the ____ ribbon.

Back 16

Page Layout

Front 17

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

Back 17

Sheet tab shortcut menu