Lesson 4 & 5 Review

Front 1

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

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.

Back 2

True

Front 3

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

Back 3

False

Front 4

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

Back 4

True

Front 5

Worksheet names may not exceed 31 characters.

Back 5

False

Front 6

Which of the following is NOT an appropriate worksheet tab name

Back 6

Employee and Staff Information Sheet

Front 7

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

Back 7

To the right of all sheets

Front 8

Which of the following is NOT a freeze panes option

Back 8

Freeze current area

Front 9

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

Back 9

Smallest number to largest number

Front 10

_____temporarily hides records that do not meet a specific criterion

Back 10

Filtering data

Front 11

The arithmetic operator, *, instructs Excel to perform a division operation

Back 11

False

Front 12

In Excel 2010, fixed references are referred to as relative references

Back 12

False

Front 13

The = (equal) symbol is used to signify the beginning of a formula

Back 13

True

Front 14

When then a small black square in the lower-right corner of the cell appears, information may be filled using the fill handle.

Back 14

True

Front 15

The If function is considered a financial function

Back 15

False

Front 16

If the year 35 is entered into a worksheet, Excel automatically changes it to the four-digit year of

Back 16

1935

Front 17

All of the following are Excel arithmetic operators except

Back 17

%

Front 18

Each time a value is entered into the worksheet, Excel automatically ____ formulas

Back 18

Includes the number in

Front 19

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

Back 19

currency style

Front 20

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

Back 20

#

Front 21

In Microsoft Excel 2010, what is the area that contains gridlines and is made up of row and columns called?

Back 21

a. Worksheet

Front 22

Which button appears when cells are filled with data in a series

Back 22

b. AutoFill