Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ETM 1030 > EL1 C1 > Flashcards

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?

A

5

18
Q

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

A

ribbon

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?

A

F1

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
Q

The keyboard shortcut Alt + = inserts _____ into the active cell.

A

the SUM function

26
Q

In addition to in its worksheet cell, where else is a data value displayed in Excel?

A

in the formula bar

27
Q

Where in the worksheet area will you find the Name box?

A

upper left corner

28
Q

To print a workbook, begin by clicking the _____ tab.

A

FILE

29
Q

When a cell containing data is active, anything you type will…

A

take the place of the existing data

30
Q

If numeric data in a number is too long to display in the cell, what does Excel do?

A

it displays number symbols (###) to indicate that the numeric value is too long to display

31
Q

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?

A

status bar

32
Q

Using the keyboard, you can select an entire column of cells by pressing…

A

CRTL + spacebar in the desired column

33
Q

A workbook name can contain up to _____ characters.

A

255

34
Q

The individual cells in the Excel worksheet area are identified by a letter and number combination, such as A2, known as the…

A

cell address or cell reference

35
Q

There are several ways to save an Excel workbook. Which of the following is not one of them?

A

double-clicking the FILE tab on the ribbon

36
Q

You can make a cell active by left-clicking in it, or you can use…

A

the Go To feature

37
Q

You can copy a formula to other cells quickly by using…

A

autofill(?)

38
Q

To enter data in a cell, the cell must be…

A

active

39
Q

One of the features Excel offers to help with data entry is the AutoComplete feature, which automatically…

A

inserts data in a cell that begins the same as a previous entry

40
Q

The horizontal and vertical scroll bars…

A

shift the display of cells, but do not change the active cell

41
Q

If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle.

A

ALT

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions