Free Printable Module 7 Excel Creating a Worksheet

Worksheets

Module 7 Excel Creating a Worksheet

Total questions: 20

Worksheet time: 14mins

Name

Class

Date

A cell address consists of a column number followed by a row letter.

True

False

You must click a cell to make it active before entering data.

True

False

You can edit a cell entry by double-clicking the cell to put the cell in Edit mode.

True

False

Using the mouse is a quick and easy method of adjusting a column width or row height when you do not need an exact width or height.

True

False

Formulas start with a plus sign (+) and can contain numbers, mathematical operators, and cell references.

True

False

In Excel, the asterisk symbol is the operator for multiplication.

True

False

Functions save time and help ensure accuracy, although they are available only for simple calculations.

True

False

You use the Merge button to combine several cells into one cell and center the text in the merged cell, which is helpful for formatting a worksheet title so that it is centered above the worksheet data.

True

False

In Page Layout view, you can add headers and footers containing information that you want to include at the top or bottom of each page.

True

False

10.

When you first start Excel, the active cell in the new workbook is ____.

cell 1A

cell A1

cell A

cell 1

11.

To reference a cell range, use the cell address of the first cell in the range followed by a ____ and the cell address of the last cell in the range.

period

comma

colon

hyphen

12.

Unlike pressing [return] on the keyboard, clicking the ____ button on the formula bar accepts the entry while also keeping the cell active.

Enter

Wrap Text

Fill

Merge

13.

To perform a calculation in a worksheet, you enter a ____ in a cell.

value

label

sum

formula

14.

The small black square that you drag to copy formulas into other cells is called the ____.

cell pointer

fill handle

cell handle

fill pointer

15.

In addition to the Standard toolbar, the AutoSum button is also available on the ____ tab of the ribbon.

Layout

Formulas

Home

Review

16.

All formulas must begin with a(n) ____.

equal sign (=)

plus sign (+)

minus sign (-)

forward slash

17.

Sometimes a worksheet or workbook is referred to as a spreadsheet.

True

False

18.

In addition to the Standard toolbar, the AutoSum button is also available on the ____ tab of the ribbon.

Layout

Home

Formulas

Review

19.

The ____ bar, located just above the column headings, shows the contents of the selected cell.

formula

data

name

address

20.

A worksheet is an electronic grid in which you can perform numeric calculations.

True

False

Reset

Module 7 Excel Creating a Worksheet

Total questions: 20

Worksheet time: 14mins

Similar Resources on Wayground