Brainscape's Knowledge GenomeTM

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


See full index

Intro to Computer Applications > Microsoft Excel Chapter 1 > Flashcards

Microsoft Excel Chapter 1 Flashcards

1
Q

A file created in Excel is referred to as a

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

A

a. workbook

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

An Excel workbook consists of individual _______.

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

A

b. worksheets

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

Columns are labeled with ________.

a. Letters
b. Numbers
c. Symbols

A

a. Letters

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

Rows are labeled with _________.

a. Letters
b. Numbers
c. Symbols

A

b. Numbers

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

What is number 1?

A

File Tab

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

What is number 2?

A

Quick Access toolbar

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

What is number 3?

A

tabs

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

What is number 4?

A

title bar

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

What is number 6?

A

Name Box

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

What is number 5

A

active cell

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

What is number 7?

A

Formula Bar

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

What is number 8?

A

Merge and Center

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

What is number 9

A

AutoSum

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

What is number 10?

A

Ribbon

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

What is number 11?

A

Vertical Scroll Bar

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

What is number 12?

A

Horizontal Scroll Bar

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

What is number 13?

A

Sheet Tabs

18
Q

What is number 14?

A

Status Bar

19
Q

What is number 15?

A

Fill Handle

20
Q

What is number 16?

A

Select All

21
Q

What is number 17?

A

Rows

22
Q

What is number 18?

A

Columns

23
Q

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

A

Enter

24
Q

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

A

Shift + Enter

25
Q

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

A

Tab

26
Q

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

A

Shift + Tab

27
Q

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

A

Home

28
Q

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

A

End

29
Q

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

A

Up, Down, Left, or Right Arrow

30
Q

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

A

Ctrl + End

31
Q

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

A

Ctrl + Home

32
Q

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

A

True

33
Q

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

A

True

34
Q

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

A

Auto Fill

35
Q

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

A

d =

36
Q

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

A

a through

37
Q

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

A

b Add

38
Q

When selecting With the Mouse, do this

To Select a Column?

A

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

39
Q

When selecting With the Mouse, do this

To Select a Row?

A

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

40
Q

When selecting With the Mouse, do this

To Select Adjacent Cells?

A

Drag with mouse to select specific cells

41
Q

When selecting With the Mouse, do this

To Select Non Adjacent Cells?

A

Hold down the Control Key while clicking specific cells

42
Q

When selecting With the Mouse, do this

To Select All Cells in a Worksheet?

A

Click the Select All button

Intro to Computer Applications (15 decks)

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