1.1 Flashcards

Elements of an Excel Worksheet

1
Q

active cell

A

location in the worksheet that displays typed data or is affected by a command

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

cell pointer

A

when this icon appears, select cells by clicking or dragging the mouse

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

Collapse the Ribbon button

A

when clicked, removes the ribbon from the screen (Redisplay the ribbon by double-clicking a tab, except the file tab

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

dialog box launcher

A

click to open a dialog box with more options for that group

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

File tab

A

displays the backstage area that contains options for working with and managing files

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

Formula bar

A

displays contents stored in the active cell

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

horizontal and vertical scroll bars

A

used to view various parts of the worksheet beyond the current screen

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

Name box

A

displays the active cell address or name assigned to the active cell

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

New sheet button

A

click to insert a new worksheet in the workbook

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

Quick Access Toolbar

A

contains buttons for commonly used commands that can be executed with a single mouse click

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

ribbon

A

contains the tabs with commands and buttons

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

sheet tab

A

identifies the current worksheet in the workbook

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

Status bar

A

displays the current mode, action messages, view buttons, and Zoom slider bar

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

tab

A

contains commands and buttons organized into groups

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

Tell Me text box

A

provides info and guidance on how to perform a function

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

Title bar

A

displays the workbook name followed by the application name

17
Q

worksheet area

A

contains the cells used to create a worksheet