Excel Unit A

Question 1

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

Answer 1

ELECTRONIC SPREADSHEET

Question 2

Is the Electronic Spreadsheet.

Answer 2

WORKSHEET

Question 3

Has the extension to the worksheet.

Answer 3

WORKBOOK

Question 4

When you use a worksheet and ask the question.

Answer 4

WHAT IF ANALYZE

Question 5

there predesigned formatted files.

Answer 5

TEMPLATES

Question 6

the intersection of a column and a row.

Answer 6

CELL

Question 7

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

Answer 7

CELL ADDRESS

Question 8

Displays the active cells address.

Answer 8

NAME BOX

Question 9

Allows you to enter data in a worksheet.

Answer 9

FORMULA BAR

Question 10

Contains a grid of columns or row.

Answer 10

WORKSHEET WINDOW

Question 11

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

Answer 11

ACTIVE CELL

Question 12

Lets you switch from sheet to sheet.

Answer 12

SHEET TABS

Question 13

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

Answer 13

STATUS BAR

Question 14

Provides additional information about certain tasks.

Answer 14

MODE INDICATOR

Question 15

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

Answer 15

RANGE

Question 16

Is an equation in a cell.

Answer 16

FORMULA

Question 17

Contains text and numeric information not used in calculations.

Answer 17

LABELS

Question 18

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

Answer 18

VALUES

Question 19

The information necessary to calculate an answer.

Answer 19

ARGUMENTS

Question 20

Is a built-in function.

Answer 20

FUNCTIONS

Question 21

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

Answer 21

EDIT

Question 22

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

Answer 22

AUTO RECOVERY

Question 23

Formulas in an excel worksheet start with the equal sign.

Answer 23

FORMULA PREFIX

Question 24

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

Answer 24

CALCULATIONS OPERATIONS

Question 25

Which preforms mathematical calculations.

Answer 25

ARITHMETIC OPERATIONS

Question 26

Which join strings of text in different cells.

Answer 26

TEXT CONCATENATION OPERATIONS

Question 27

Which enable you to use ranges in calculations.

Answer 27

REFERENCE OPERATION

Question 28

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

Answer 28

NORMAL VIEW

Question 29

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

Answer 29

PAGE LAYOUT

Question 30

To fit large amount of data on a single page without making any changes.

Answer 30

SCALE TO FIT