excel unit A

Question 1

is a application you use to perform numeric calculations and to analyze and present numeric data.

Answer 1

electronic spreadsheet

Question 2

the electronic spreadsheet you work in

Answer 2

worksheet

Question 3

and it is contained in a file called a

Answer 3

workbook

Question 4

any time you use a worksheet to ask the question “what if”

Answer 4

What -if analysis

Question 5

displays the active cell address .”A1” appers in the

Answer 5

Name Box

Question 6

allows you to enter or edit data in the worksheet.

Answer 6

formula bar

Question 7

predesigned formatted files

Answer 7

templates

Question 8

contains a grid of columns and rows.

Answer 8

worksheet window

Question 9

the intersection of a column and a row

Answer 9

Cell

Question 10

every cell has its own unique location

Answer 10

cell address

Question 11

the dark rectangle that outlines the cell you are working in

Answer 11

cell pointer

Question 12

the cell pointer outlines the cell A1 so A1 is the

Answer 12

active cell

Question 13

below the worksheet grid let you switch from sheet to sheet

Answer 13

sheet tabs

Question 14

lets you to navigate to additional sheet tabs when available

Answer 14

sheet tab scrolling button

Question 15

is located at the bottom of the excel window it provides a breif decription of the active command or tasks in process

Answer 15

status bar

Question 16

on the status bar now reads “Edit”

Answer 16

mode indicator

Question 17

a build in formula

Answer 17

function

Question 18

the information necessary to calculate an answer

Answer 18

arguments

Question 19

you can change or the contents of acell

Answer 19

edit

Question 20

excel worsheet starts with the equal sign

Answer 20

formula prefix

Question 21

A selection of two or more cells such as B5:B14

Answer 21

Range

Question 22

is an equation in a worksheet

Answer 22

formula

Question 23

are entries that contains text and numerical information not used in calculation such as 2012 sales or Travel Exxpenses

Answer 23

Labels

Question 24

are numbers formulas and function that can be used in calculations

Answer 24

Values

Question 25

on the status bar now reads”edit”indicating you are in edit mode.

Answer 25

mode indicator

Question 26

the information necessary to calculate an answer

Answer 26

arguments

Question 27

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

Answer 27

edit

Question 28

Excel worksheet starts with the equal sign

Answer 28

formula prefix

Question 29

indicate what type of calculation you want to perform on the cells ranges or values.

Answer 29

calculation operators

Question 30

show the worksheet without including certain details like headers footers or tools like rulers

Answer 30

normal view

Question 31

which join strings of test in different cells

Answer 31

text concatenation operators

Question 32

which perform mathematical calculatons

Answer 32

arithmetic operators