Excel Unit A

Question 1

Contain text and numerical information not used in calculations.

Answer 1

Labels

Question 2

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

Answer 2

Values

Question 3

Program allows you to perform numeric calculations.

Answer 3

Electronic Spreadsheet

Question 4

Spreadsheet.

Answer 4

Worksheet

Question 5

Individual worksheets are stored in, which is the excel file.

Answer 5

Workbook

Question 6

Any time you use a worksheet to ask the question “what if “?.

Answer 6

What-if analysis

Question 7

Used to create new worksheets quickly.

Answer 7

Templates

Question 8

The intersection of a column and a row.

Answer 8

Cell

Question 9

Every cell has its own unique location.

Answer 9

Cell Address

Question 10

Displays the active cell address.

Answer 10

Name Box

Question 11

Allows you to enter or edit data in the worksheet.

Answer 11

Formula Bar

Question 12

Contains a grid of columns and rows.

Answer 12

Worksheet Window

Question 13

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

Answer 13

Cell Pointer

Question 14

The cell you are working in.

Answer 14

Active Cell

Question 15

Lets you switch from sheet to sheet in a workbook.

Answer 15

Sheet Tabs

Question 16

Provides a brief description of the active command or task progress.

Answer 16

Status Bar

Question 17

Provides additional information about certain tasks.

Answer 17

Mode Indicator

Question 18

You select a range when you want to perform an action on a group of cells at once such as moving them or flattening them.

Answer 18

Range

Question 19

Is an equation in a worksheet use cell references rather than values determine what calculations will be needed.

Answer 19

Formula

Question 20

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

Answer 20

Arguments

Question 21

Is a built-in formula.

Answer 21

Function

Question 22

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

Answer 22

Edit

Question 23

Is a feature you can use to automatically save your work as often as possible.

Answer 23

Auto Recover

Question 24

Formulas in an excel worksheet start with the equal sign.

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

Which perform mathematical calculations.

Answer 26

Arithmetic Operators

Question 27

Which join strings of text in different cells.

Answer 27

Text Concatenation Operators

Question 28

Which 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 its great for creating and editing a worksheet but may not be detailed enough when you want to put the finishing touches on a document.

Answer 29

Normal View

Question 30

Provides a more accurate view of how a worksheet will look when printed.

Answer 30

Page Layout

Question 31

Options on the page layout tab to fit a large amount of data on a single page without making changes to individual margins and to turn gridlines and column/row heading on and off.

Answer 31

Scale to fit