Unit 8

Question 1

excel

Answer 1

electronic spread sheet within Microsoft office

Question 2

electronic spreadsheet

Answer 2

program used to form numeric calculations and analyze and present numeric date

Question 3

worksheet

Answer 3

each individual spreadsheet you work in

Question 4

workbook

Answer 4

file of several worksheets ( .xlsx )

Question 5

what if analysis

Answer 5

using a worksheet to ask a question

Question 6

templates

Answer 6

predesigned, formatted files

Question 7

you can use spread sheet for:

Answer 7

Perform calculation, represent values graphically, Generate reports, organize data, analyze data, create what if scenarios,

Question 8

name box

Answer 8

display the active cell address (A1)

Question 9

formula bar

Answer 9

allows you to enter or edit data in worksheet

Question 10

cell

Answer 10

intersection of a column and a row

Question 11

cell address

Answer 11

unique location where the column and the row intersect

Question 12

cell pointer

Answer 12

tells you the cell your in

Question 13

active cell

Answer 13

the cell that is outlined

Question 14

sheet tabs

Answer 14

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

Question 15

sheet tab scrolling buttons

Answer 15

let you navigate to additional sheets

Question 16

staus bar

Answer 16

tells you what command you active command or task in progress

Question 17

mode indicates

Answer 17

provide additional info (bottom left corner)

Question 18

range

Answer 18

when you highlight 2 or more cells

Question 19

formula

Answer 19

a mathematical equation in the worksheet

Question 20

labels

Answer 20

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

Question 21

values

Answer 21

are numbers, formulas, and functions used in calculations

Question 22

function

Answer 22

built in formula

Question 23

arguments

Answer 23

information necessary to calculate and answer

Question 24

edit

Answer 24

to edit a cell, double click

Question 25

calculation operators

Answer 25

indicate what type of calculation you want to perform

Question 26

arithmetic operators

Answer 26

perform mathematical calculations

Question 27

cloud computing

Answer 27

work done in a virtual environment

Question 28

reference operators

Answer 28

enable you to use range in calculations

Question 29

normal view

Answer 29

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

Question 30

page layout view

Answer 30

provides a more accurate view of how it will look when printed

Question 31

dotted lines

Answer 31

indicates print area