Cfa 2

Front 1

What method is used in conjunction with the mouse to change the height of a column in Microsoft Excel 2010?

Back 1

Click and drag the boundary

Front 2

What command on the Home ribbon allows the user to search for AND replace specific text in a worksheet are?

Back 2

Find

Front 3

Which command in the Print tab backstage view must be selected to print all sheets in a
workbook?

Back 3

Print entire workbook

Front 4

Where is the command to create a new folder in the user's storage device for Microsoft Excel 2010 files located?

Back 4

File tab, open button

Front 5

Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins
with the same characters as a previous entry?

Back 5

AutoComplete

Front 6

When a formula is copied from one cell to another, what allows the cell address to
adjust the column letter and row number to the new copy location?

Back 6

Relative cell reference

Front 7

How do you add a border to worksheet cells?

Back 7

Select cells and choose the Border command from the Home ribbon

Front 8

How do you copy formatting to different locations in the worksheet?

Back 8

Format copier

Front 9

What is the data printed on the bottom of each worksheet page?

Back 9

footer.

Front 10

What is the moving dashed line that appears around the cells when selected called?

Back 10

Marquee

Front 11

There are only two methods to start Microsoft Office Excel 2010

Back 11

False

Front 12

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

Back 12

False

Front 13

A file name can have up to 250 characters

Back 13

False

Front 14

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

Back 14

Home

Front 15

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

Back 15

Employees

Front 16

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

Back 16

To the left of all sheets

Front 17

A point is 1/75 of an inch

Back 17

True