Microsoft Excel Chapter 1 Flashcards
A file created in Excel is referred to as a
a. workbook
b. worksheet
c. sheet
d. document
a. workbook
An Excel workbook consists of individual _______.
a. papers
b. worksheets
c. files
d. documents
b. worksheets
Columns are labeled with ________.
a. Letters
b. Numbers
c. Symbols
a. Letters
Rows are labeled with _________.
a. Letters
b. Numbers
c. Symbols
b. Numbers
What is number 1?
File Tab
What is number 2?
Quick Access toolbar
What is number 3?
tabs
What is number 4?
title bar
What is number 6?
Name Box
What is number 5
active cell
What is number 7?
Formula Bar
What is number 8?
Merge and Center
What is number 9
AutoSum
What is number 10?
Ribbon
What is number 11?
Vertical Scroll Bar
What is number 12?
Horizontal Scroll Bar
What is number 13?
Sheet Tabs
What is number 14?
Status Bar
What is number 15?
Fill Handle
What is number 16?
Select All
What is number 17?
Rows
What is number 18?
Columns
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
Enter
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
Shift + Enter
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
Tab
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
Shift + Tab
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
Home
What is the keyboard move to the Cell at the End of the row?
a. End
b. Home
c. Up, Down, Left or Right
d. Ctrl + End
e. Ctrl + Home
f. Enter
g. Shift + Tab
h. Tab
End
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
Up, Down, Left, or Right Arrow
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
Ctrl + End
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
Ctrl + Home
Seeing (###) in a cell means that the cell width isn’t wide enough to see the number. True or False
True
To edit contents in a cell, you should double click the cell. True or False
True
With the __________ you can quickly fill a range of cells with the same data or consecutive data.
Auto Fill
All formulas begin with what?
a +
b -
c /
d =
d =
In the following formula =Sum(A1:A5), the : represents what?
a through
b or
c and
d all
a through
In the following formula =Sum(A1:A3), Sum means to?
a Subtract
b Add
c Divide
d Multiply
b Add
When selecting With the Mouse, do this
To Select a Column?
Position the cell pointer on the column header (a letter) and then click the left mouse button.
When selecting With the Mouse, do this
To Select a Row?
Position the cell pointer on the row header (a number) and then click the left mouse button.
When selecting With the Mouse, do this
To Select Adjacent Cells?
Drag with mouse to select specific cells
When selecting With the Mouse, do this
To Select Non Adjacent Cells?
Hold down the Control Key while clicking specific cells
When selecting With the Mouse, do this
To Select All Cells in a Worksheet?
Click the Select All button
