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

A

Copy

20
Q

CTRL G

A

Go to a new location

21
Q

CTRL N

A

Open new

22
Q

CTRL P

A

Print

23
Q

CTRL S

A

Save

24
Q

Key Tips

A

Labels that appear over each tab and command on the ribbon

25
Q

Sheets

A

Workbooks are organized into seperate pages called sheets. There are two types: Worksheets and Chart Sheets.

26
Q

Worksheet

A

Contains a grid of rows and columns in which you can enter text, numbers, dates, and formulas and display charts

27
Q

Chart Sheet

A

Contains a chart that provides a visual representation of worksheet data.

28
Q

Cell Reference

A

Indicates the column and row in which the cell is located.

29
Q

Cell References Appearance

A

The column letter always appears before the row number in any cell reference.

30
Q

Active Cell

A

The cell that is currently selected in the worksheet

31
Q

HOME

A

To column A of the current row

32
Q

CTRL HOME

A

To cell A1

33
Q

CTRL END

A

To the last cell in the worksheet that contains data

34
Q

Enter

A

Down one row or to the start of the next row of data

35
Q

Shift+Enter

A

Up one Row