Excel Unit A

Question 1

Built in formula

Answer 1

Function

Question 2

An application you use to perform numerical calculations and analyze and present numerical data

Answer 2

Electron Spreadsheet

Question 3

An electronic spreadsheet you work in

Answer 3

Worksheet

Question 4

A file where worksheets are stored

Answer 4

Workbook

Question 5

Any time you use a worksheet to ask what if

Answer 5

What-if Analysis

Question 6

A predesigned format file

Answer 6

Templates

Question 7

Location of a cell

Answer 7

Cell Address

Question 8

Box containing the cell address of the active cell

Answer 8

Name Box

Question 9

The bar that allows you to format data in a cell

Answer 9

Formula Bar

Question 10

Window containing the columns and rows in excel

Answer 10

Worksheet Window

Question 11

Dark rectangle that surrounds the cell you are working on

Answer 11

Cell Pointer

Question 12

The cell you are working on

Answer 12

Active Cell

Question 13

Tabs that let you switch from sheet to sheet

Answer 13

Sheet Tabs

Question 14

Bar containing a brief description of the active command or process

Answer 14

Status Bar

Question 15

Area in the bottom left corner containing more information about certain tasks

Answer 15

Mode Indicator

Question 16

A selection of two or more cells

Answer 16

Range

Question 17

An equation in a worksheet

Answer 17

Formula

Question 18

Entries in a cell that contain text and numerical data not used in calculations

Answer 18

Labels

Question 19

Numbers and formulas that can be used in calculations

Answer 19

Values

Question 20

The information necessary to perform a calculation

Answer 20

Arguments

Question 21

Changing the contents

Answer 21

Edit

Question 22

A feature of excel that allows you to recover unsaved information in the case of a problem

Answer 22

Autoreciever

Question 23

A feature of excel that allows you to recover unsaved information in the case of a problem

Answer 23

Formula Prefix

Question 24

Operators that indicate what type of calculation you want to perform

Answer 24

Calculation Operators

Question 25

Operators that join strings of text in different cells

Answer 25

Text Concatenation Operators

Question 26

Operators that allow you to use ranges in calculations

Answer 26

Reference Operators

Question 27

View of the worksheet that leaves out page information such as headers and footers

Answer 27

Normal Veiw

Question 28

View that shows all the information as if it was going to be printed

Answer 28

Page Layout View

Question 29

A printing option that allows you to print large amounts of data on a single sheet of paper

Answer 29

Scale-To-Fit

Question 30

Operators that perform mathematical calculations

Answer 30

Arithmetic Operators