Excel Flashcards

1
Q

Name Box

A

displays the cell reference of the active cell

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

Formula Bar

A

displays the value or formula entered into the active cell

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

Row Headings

A

Numbers along the left side of the workbook window that identify the different rows of the worksheet

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

Spreadsheet

A

Grouping of text and numbers in a rectangular grid or table

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

Workbook

A

Excel documents are called workbooks

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

Template

A

Preformatted workbook with many design features and some content already filled idn.

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

Keyboard Shortcut

A

Key or combination of keys that you press to access a feature or perform a command.

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

ScreenTip

A

A box with descriptive text about a command that appears when you point to a button on the ribbon

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

CTRL V

A

Paste

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

CTRL A

A

Close current workbook

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

CTRL X

A

Cut

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

CTRL Y

A

Repeat last command

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

CTRL Z

A

Undo last command

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

F1

A

Open Help window

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

F5

A

Go to a location in the workbook

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

F12

A

Save the current workbook with a new name or to a new location

17
Q

ALT

A

Display the key tips for the commands and tools on the ribbon

18
Q

CTRL A

A

Select All

19
Q

CTRL C

20
Q

CTRL G

A

Go to a new location

21
Q

CTRL N

22
Q

CTRL P

23
Q

CTRL S

24
Q

Key Tips

A

Labels that appear over each tab and command on the ribbon

25
Sheets
Workbooks are organized into seperate pages called sheets. There are two types: Worksheets and Chart Sheets.
26
Worksheet
Contains a grid of rows and columns in which you can enter text, numbers, dates, and formulas and display charts
27
Chart Sheet
Contains a chart that provides a visual representation of worksheet data.
28
Cell Reference
Indicates the column and row in which the cell is located.
29
Cell References Appearance
The column letter always appears before the row number in any cell reference.
30
Active Cell
The cell that is currently selected in the worksheet
31
HOME
To column A of the current row
32
CTRL HOME
To cell A1
33
CTRL END
To the last cell in the worksheet that contains data
34
Enter
Down one row or to the start of the next row of data
35
Shift+Enter
Up one Row