Excel Unit A Flashcards

Excel

1
Q

An application you use to perform numeric calculations and to analyze and present numeric data?

A

Electronic Spread Sheet

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

In excel, the electronic spread sheet you work in is called a?

A

Worksheet

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

Where a worksheet is saved and contained in a xlsx

A

Workbook

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

Any Time you use a worksheet to ask the question what if you are preforming a?

A

What-if Analysis

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

You can use Predesigned, formatted files called

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 is called a

A

Cell

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

A combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet

A

Cell address

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

Displays the active cell address “A1” appears in the

A

Name Box

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

Allows you to enter or edit data in the 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 and rows

A

Worksheet Window

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

A dark rectangle that outlines the cell you are working in

A

Cell Pointer

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

The cell pointer outlines cell A1, so A1 is the

A

Active Cell

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

Below the worksheet grid let you switch from sheet to sheet in a workbook

A

Sheet Tabs

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

Located at the bottom of the excel window, it provides a brief description of the active command or task in progress

A

Status bar

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

In the lower left corner of the status bar provides additional information about certain tasks

A

Mode indicator

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

A selection of two or more cells such as b5:b14: is called a

17
Q

An equation in a worksheet

18
Q

Are entries that contain text and numerical information not used in calculations

19
Q

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

20
Q

The information necessary to calculate an answer, as well as cell references and other unique information

21
Q

A built in formula that includes the arguments

22
Q

You can change the contents of an active cell at any time

23
Q

You can use excels feature to automatically save your work as often as you want

A

Auto Recover

24
Q

Excel worksheet start with the equal sign followed by cell addresses, range names, values, and calculation operators

A

Formula Prefix

25
Indicate what type of calculation you want to perform on the cells, ranges, or values
Calculator Operators
26
Perform mathematical calculations
Arithmetic Operators
27
Join strings of text in different cells
Text concatenation Operators
28
enable you to use ranges in calculations
Reference Operators
29
Shows the worksheet without including certain details like headers and footers, or tools like rulers and a page number indicator
Normal View
30
Provides a more accurate view of how a worksheet will look as printed
Page Layout View
31
Options to reduce the size of the worksheet to better fit the printed box
Scale To Fit