Excel Unit 8

Question 1

electronic spread sheet within Microsoft office

Answer 1

Excel

Question 2

program used to preform numeric calculations and analyze and present numeric data calculations are updated automatically

Answer 2

Electronic spread sheet

Question 3

each individual spread sheet you work in

Answer 3

Worksheet

Question 4

file of several worksheets file extension .xlsx

Answer 4

Workbook

Question 5

using a worksheet to ask a question

Answer 5

What if analysis

Question 6

predesigned formatted files

Answer 6

Templates

Question 7

preform calculations, represent graphics valuably, generate reports, organize data, analyze data, create what if scenarios

Answer 7

you can use spread sheets to

Question 8

displays the active cell adress

Answer 8

name box

Question 9

allows you to enter or edit data in worksheet

Answer 9

formula bar

Question 10

intersection of a column and row

Answer 10

cell

Question 11

unique location identified by the corridor of the intersecting column and row

Answer 11

cell address

Question 12

dark rectangle that outlines the cell in which you are working

Answer 12

cell pointers

Question 13

the cell that is outlined

Answer 13

active cell

Question 14

below the worksheet grid lets you switch from sheet to sheet in a workbook

Answer 14

sheet tabs

Question 15

let you navigate to additional sheet tabs when available

Answer 15

sheet tab scrolling buttons

Question 16

at bottom provides brief description of the active command or task in progress

Answer 16

status bar

Question 17

in bottom left corner of the status bar provides additional info about certain tasks

Answer 17

mode indicator

Question 18

a selection of two or more cells is a range

Answer 18

range

Question 19

equations in a worksheet

Answer 19

Formulas

Question 20

+ =a5+a7

Answer 20

Addition

Question 21

• =a5-10

Answer 21

subtraction

Question 22

• =a5*a7

Answer 22

multiplication

Question 23

/ =a5/a7

Answer 23

division

Question 24

% =35%

Answer 24

percent

Question 25

^ =6^2

Answer 25

exponent

Question 26

entries that contain text & numerical information not used in calculations (2009 sales)

Answer 26

labels

Question 27

are. numerical, formulas, and functions used in calculations

Answer 27

Values

Question 28

built in formula

Answer 28

functions

Question 29

info. necessary to calculate an answer-cell reference

Answer 29

arguments

Question 30

to edit a cell double click it

Answer 30

edit

Question 31

= (what a formula starts with)

Answer 31

formula prefix

Question 32

indicate what type of calculations you want to preform on the cells

Answer 32

calculation operators

Question 33

preform mathematical calculations

Answer 33

Arithmetic operators

Question 34

work done in a virtual environment

Answer 34

cloud computing

Question 35

enables you to use ranges in calculations

Answer 35

reference operators

Question 36

shows the worksheet without including certain details like the headers and footers or rulers

Answer 36

normal view

Question 37

provides a more accurate view of what it will look like printed

Answer 37

page layout view

Question 38

indicates print area

Answer 38

dotted lines