Lesson 1-4 Test

Front 1

There are only two methods to start Microsoft Office Excel 2010

Back 1

False

Front 2

. The basic Microsoft Office Excel 2010 window includes seven rib-bon tabs that maybe selected to view various command groupings

Back 2

True

Front 3

A ribbon may be accessed by clicking once on the ribbon tab

Back 3

True

Front 4

To identify a cell, specify the row number first, followed by the column letter

Back 4

False

Front 5

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

Back 5

False

Front 6

. _____ are a collection of worksheets

Back 6

A. Workbooks

Front 7

A _____ is the intersection of a column and row

Back 7

D. Cell

Front 8

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

Back 8

C. Ribbon Tab

Front 9

Information on each ribbon is an organized in a collection called a _____

Back 9

B. Group

Front 10

. In Excel 2010, numbers are automatically _____ aligned

Back 10

A. Right

Front 11

. The Currency style button is located on the Home Ribbon

Back 11

True

Front 12

Numerical data is automatically right aligned in a cell and there is no way to change this

Back 12

False

Front 13

Formatting a worksheet could possibly change the data on the sheet

Back 13

False

Front 14

When formatting data, most of the formatting commands are located on the Insert Ribbon

Back 14

False

Front 15

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

Back 15

False

Front 16

. The increase and decrease indent commands are located on the _____ Ribbon.

Back 16

C. Home

Front 17

The _____ command will join selected cells and center the con-tents

Back 17

A. Merge and Center

Front 18

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

Back 18

B. Format Painter

Front 19

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

Back 19

A. 17

Front 20

. _____ enhances the readability of a worksheet.

Back 20

C. Formatting

Front 21

Hiding worksheet data will delete the data

Back 21

False

Front 22

By default all areas of the worksheet will print

Back 22

True

Front 23

. Once a page break is inserted, it cannot be removed

Back 23

False

Front 24

Print titles are an excellent way to include titles or column headings on all pages that are printed

Back 24

True

Front 25

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

Back 25

False

Front 26

The quickest method to hide a column or row in a worksheet it to select the column or row and choose hide from _____.

Back 26

C. Shortcut menu

Front 27

The _____ is the space between the page content and the edges of the paper

Back 27

B. margin

Front 28

. The _____ command allows information to repeat on each printed page

Back 28

C. print area

Front 29

Page breaks may be manually inserted using the breaks command on the _____ ribbon

Back 29

A. Page Layout

Front 30

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

Back 30

A. Sheet tab shortcut menu

Front 31

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

Back 31

False

Front 32

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

Back 32

True

Front 33

Once a new sheet is inserted into a workbook, it must remain in the location that it was inserted

Back 33

False

Front 34

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

Back 34

True

Front 35

Worksheet names may not exceed 31 characters

Back 35

True

Front 36

. Which of the following is NOT an appropriate worksheet tab name

Back 36

C. Employee and Staff Information Sheet

Front 37

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

Back 37

B. To the right of all sheets

Front 38

Which of the following is NOT a freeze panes option

Back 38

B. Freeze current area

Front 39

When sorting numerical data in ascending order, how will the data be sorted

Back 39

Smallest number to largest number

Front 40

. _____ temporarily hides records that do not meet a specific criterion

Back 40

D. Filtering data