EL1 C1 Flashcards

1
Q

when the mouse pointer displays as a white plus sign, it is referred to as the…

A

cell pointer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

when you click the AutoSum button, Excel looks first for a range of cells containing numbers _____ the active cell, and then _____ the active cell.

A

above
left of

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

display the Open backstage area by clicking the FILE tab and then clicking the Open option, or by pressing…

A

CRTL + O

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

pressing Ctrl + Home will take you to the…

A

first cell of the worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

clicking the Quick Print button will…

A

send the workbook directly to the printer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

to select all cells from the active cell to the beginning of the row, press…

A

shift + home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

which keyboard command closes Excel?

A

CRTL + F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

which keyboard shortcut displays the Go To dialog box?

A

CRTL + G

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

which of the following is not a valid name for an Excel workbook?

A

MyBudget/version2.xlsx

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

by default, numbers in a cell are aligned at the _____ and decimals and commas _____ display.

A

right
will not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

to select specific characters within a cell (rather than the whole cell), begin by…

A

double clicking in the desired cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which element of an Excel worksheet displays the active cell address or name assigned to the active cell?

A

name box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

The AutoCorrect feature in Excel automatically corrects…

A

common typing errors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What happens if you enter text into a cell and it is too long to fit in the cell?

A

The text overlaps into the cell to the right, but it is not stored in that cell.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is another name for the cell address?

A

cell reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You can select nonadjacent cells with your mouse by…

A

holding down the Ctrl key while clicking the desired cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

How many buttons display to the left of the search text box in the Excel Help window?

18
Q

The area of the worksheet that contains tabs with commands and buttons is called the…

19
Q

When applied to an amount, this button adds a dollar sign, any necessary commas, and a decimal point followed by two decimal digits…?

A

accounting number format

20
Q

Positioning your mouse pointer on the gray boundary line between columns in the column header is the first step toward…

A

changing column width

21
Q

When you have finished editing the data in a cell, you must get out of Edit mode. Which of the following will not accomplish this?

A

pressing Home

22
Q

To merge cells and center text, use the Merge & Center button located in the _____ group on the _____ tab.

A

alignment
home

23
Q

What is the keyboard shortcut to display the Excel Help window?

24
Q

An Excel workbook consists of an individual “page” represented by a tab at the bottom of the Excel window. This is called a…

A

worksheet or sheet

25
The keyboard shortcut Alt + = inserts _____ into the active cell.
the SUM function
26
In addition to in its worksheet cell, where else is a data value displayed in Excel?
in the formula bar
27
Where in the worksheet area will you find the Name box?
upper left corner
28
To print a workbook, begin by clicking the _____ tab.
FILE
29
When a cell containing data is active, anything you type will...
take the place of the existing data
30
If numeric data in a number is too long to display in the cell, what does Excel do?
it displays number symbols (###) to indicate that the numeric value is too long to display
31
What is the name of the area at the bottom of the Excel screen that shows the Zoom level, the viewing mode, and the current mode?
status bar
32
Using the keyboard, you can select an entire column of cells by pressing...
CRTL + spacebar in the desired column
33
A workbook name can contain up to _____ characters.
255
34
The individual cells in the Excel worksheet area are identified by a letter and number combination, such as A2, known as the...
cell address or cell reference
35
There are several ways to save an Excel workbook. Which of the following is not one of them?
double-clicking the FILE tab on the ribbon
36
You can make a cell active by left-clicking in it, or you can use...
the Go To feature
37
You can copy a formula to other cells quickly by using...
autofill(?)
38
To enter data in a cell, the cell must be...
active
39
One of the features Excel offers to help with data entry is the AutoComplete feature, which automatically...
inserts data in a cell that begins the same as a previous entry
40
The horizontal and vertical scroll bars...
shift the display of cells, but do not change the active cell
41
If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle.
ALT