Excel Unit A

Question 1

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

Answer 1

Electronic Spread Sheet

Question 2

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

Answer 2

Worksheet

Question 3

Where a worksheet is saved and contained in a xlsx

Answer 3

Workbook

Question 4

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

Answer 4

What-if Analysis

Question 5

You can use Predesigned, formatted files called

Answer 5

Templates

Question 6

The intersection of a column and a row is called a

Answer 6

Cell

Question 7

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

Answer 7

Cell address

Question 8

Displays the active cell address “A1” appears in the

Answer 8

Name Box

Question 9

Allows you to enter or edit data in the worksheet

Answer 9

Formula Bar

Question 10

Contains a grid of columns and rows

Answer 10

Worksheet Window

Question 11

A dark rectangle that outlines the cell you are working in

Answer 11

Cell Pointer

Question 12

The cell pointer outlines cell A1, so A1 is the

Answer 12

Active Cell

Question 13

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

Answer 13

Sheet Tabs

Question 14

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

Answer 14

Status bar

Question 15

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

Answer 15

Mode indicator

Question 16

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

Answer 16

Range

Question 17

An equation in a worksheet

Answer 17

Formula

Question 18

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

Answer 18

Labels

Question 19

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

Answer 19

Values

Question 20

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

Answer 20

Arguments

Question 21

A built in formula that includes the arguments

Answer 21

Function

Question 22

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

Answer 22

Edit

Question 23

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

Answer 23

Auto Recover

Question 24

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

Answer 24

Formula Prefix

Question 25

Indicate what type of calculation you want to perform on the cells, ranges, or values

Answer 25

Calculator Operators

Question 26

Perform mathematical calculations

Answer 26

Arithmetic Operators

Question 27

Join strings of text in different cells

Answer 27

Text concatenation Operators

Question 28

enable you to use ranges in calculations

Answer 28

Reference Operators

Question 29

Shows the worksheet without including certain details like headers and footers, or tools like rulers and a page number indicator

Answer 29

Normal View

Question 30

Provides a more accurate view of how a worksheet will look as printed

Answer 30

Page Layout View

Question 31

Options to reduce the size of the worksheet to better fit the printed box

Answer 31

Scale To Fit