Excel Unit A Flashcards

(30 cards)

1
Q

An application that allows you to preform numeric calculations and to analyze and present numeric data.

A

ELECTRONIC SPREADSHEET

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

Is the Electronic Spreadsheet.

A

WORKSHEET

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

Has the extension to the worksheet.

A

WORKBOOK

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

When you use a worksheet and ask the question.

A

WHAT IF ANALYZE

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

there predesigned formatted files.

A

TEMPLATES

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

the intersection of a column and a row.

A

CELL

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

each cell has its location in which is identified by the coordinates.

A

CELL ADDRESS

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

Displays the active cells address.

A

NAME BOX

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

Allows you to enter data in a worksheet.

A

FORMULA BAR

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

Contains a grid of columns or row.

A

WORKSHEET WINDOW

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

Is a dark rectangle that outlines the cell you are working in.

A

ACTIVE CELL

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

Lets you switch from sheet to sheet.

A

SHEET TABS

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

Provides a brief description of an active command or tasks in progress.

A

STATUS BAR

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

Provides additional information about certain tasks.

A

MODE INDICATOR

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

A section of two or more cells such as B5:B14.

A

RANGE

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

Is an equation in a cell.

17
Q

Contains text and numeric information not used in calculations.

18
Q

Are numbers formulas and function that can be used in calculations.

19
Q

The information necessary to calculate an answer.

20
Q

Is a built-in function.

21
Q

You can change the contents of an active cell at anytime.

22
Q

Lets you decide how often and into which location it should auto save files.

A

AUTO RECOVERY

23
Q

Formulas in an excel worksheet start with the equal sign.

A

FORMULA PREFIX

24
Q

Indicate what type of calculation you want to preform on the cells, ranges, of values.

A

CALCULATIONS OPERATIONS

25
Which preforms mathematical calculations.
ARITHMETIC OPERATIONS
26
Which join strings of text in different cells.
TEXT CONCATENATION OPERATIONS
27
Which enable you to use ranges in calculations.
REFERENCE OPERATION
28
Shows the worksheet without including certain details like headers and footers, or tools like rulers and a page number indicator.
NORMAL VIEW
29
Provides more accurate view of how a worksheet will look like when printed.
PAGE LAYOUT
30
To fit large amount of data on a single page without making any changes.
SCALE TO FIT