Microsoft Excel Chapter 1

Question 1

A file created in Excel is referred to as a

a. workbook
b. worksheet
c. sheet
d. document

Answer 1

a. workbook

Question 2

An Excel workbook consists of individual _______.

a. papers
b. worksheets
c. files
d. documents

Answer 2

b. worksheets

Question 3

Columns are labeled with ________.

a. Letters
b. Numbers
c. Symbols

Answer 3

a. Letters

Question 4

Rows are labeled with _________.

a. Letters
b. Numbers
c. Symbols

Answer 4

b. Numbers

Question 5

What is number 1?

Answer 5

File Tab

Question 6

What is number 2?

Answer 6

Quick Access toolbar

Question 7

What is number 3?

Answer 7

tabs

Question 8

What is number 4?

Answer 8

title bar

Question 9

What is number 6?

Answer 9

Name Box

Question 10

What is number 5

Answer 10

active cell

Question 11

What is number 7?

Answer 11

Formula Bar

Question 12

What is number 8?

Answer 12

Merge and Center

Question 13

What is number 9

Answer 13

AutoSum

Question 14

What is number 10?

Answer 14

Ribbon

Question 15

What is number 11?

Answer 15

Vertical Scroll Bar

Question 16

What is number 12?

Answer 16

Horizontal Scroll Bar

Question 17

What is number 13?

Answer 17

Sheet Tabs

Question 18

What is number 14?

Answer 18

Status Bar

Question 19

What is number 15?

Answer 19

Fill Handle

Question 20

What is number 16?

Answer 20

Select All

Question 21

What is number 17?

Answer 21

Rows

Question 22

What is number 18?

Answer 22

Columns

Question 23

What is the keyboard move to Cell below Current Cell?

a. Shift + Enter
b. Home
c. Up, Down, Left or Right
d. Ctrl + End
e. Ctrl + Home
f. Enter
g. Shift + Tab
h. Tab

Answer 23

Enter

Question 24

What is the keyboard move to Cell above Current Cell?

a. Shift + Enter
b. Home
c. Up, Down, Left or Right
d. Ctrl + End
e. Ctrl + Home
f. Enter
g. Shift + Tab
h. Tab

Answer 24

Shift + Enter

Question 25

What is the keyboard move to the Next Cell? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 25

Tab

Question 26

What is the keyboard move to the Previous Cell? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 26

Shift + Tab

Question 27

What is the keyboard move to the Cell at the beginning of the row? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 27

Home

Question 28

What is the keyboard move to the Cell at the End of the row? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 28

End

Question 29

What is the keyboard move to the next cell in the direction of the arrow? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 29

Up, Down, Left, or Right Arrow

Question 30

What is the keyboard move to the last cell in a worksheet? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 30

Ctrl + End

Question 31

What is the keyboard move to the first cell in a worksheet? a. Shift + Enter b. Home c. Up, Down, Left or Right d. Ctrl + End e. Ctrl + Home f. Enter g. Shift + Tab h. Tab

Answer 31

Ctrl + Home

Question 32

Seeing (###) in a cell means that the cell width isn't wide enough to see the number. True or False

Answer 32

True

Question 33

To edit contents in a cell, you should double click the cell. True or False

Answer 33

True

Question 34

With the __________ you can quickly fill a range of cells with the same data or consecutive data.

Answer 34

Auto Fill

Question 35

All formulas begin with what? a + b - c / d =

Answer 35

d =

Question 36

In the following formula =Sum(A1:A5), the : represents what? a through b or c and d all

Answer 36

a through

Question 37

In the following formula =Sum(A1:A3), Sum means to? a Subtract b Add c Divide d Multiply

Answer 37

b Add

Question 38

When selecting With the Mouse, do this To Select a Column?

Answer 38

Position the cell pointer on the column header (a letter) and then click the left mouse button.

Question 39

When selecting With the Mouse, do this To Select a Row?

Answer 39

Position the cell pointer on the row header (a number) and then click the left mouse button.

Question 40

When selecting With the Mouse, do this To Select Adjacent Cells?

Answer 40

Drag with mouse to select specific cells

Question 41

When selecting With the Mouse, do this To Select Non Adjacent Cells?

Answer 41

Hold down the Control Key while clicking specific cells

Question 42

When selecting With the Mouse, do this To Select All Cells in a Worksheet?

Answer 42

Click the Select All button