unit 8

Question 1

electronic spreadsheet within Microsoft office

Answer 1

excel

Question 2

program used to perform numeric calculations and analyze and present numeric data

Answer 2

electronic spreadsheet

Question 3

each individual spreadsheet you work in

Answer 3

worksheet

Question 4

file of several worksheet

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

use a spreadsheet to

Answer 7

perform calculations
represent values graphically
generate reports
organize data
analyze data
create what if scenarios

Question 8

displays the active address

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 or a row

Answer 10

cell

Question 11

unique location identified by the coordinated of the intersecting column n row

Answer 11

cell address

Question 12

dark rectangle that outlines the cell in which you are working

Answer 12

cell pointer

Question 13

the cell is outlined

Answer 13

active cell

Question 14

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

Answer 14

sheet tabs

Question 15

let you navigate to additional sheet tabs when available

Answer 15

sheet tabs 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 status bar and provides additional info

Answer 17

mode indicator

Question 18

a selection of 2 or more cells

Answer 18

range

Question 19

equations in a worksheet

Answer 19

formula

Question 20

entries that contain text & numerical info not used in calculations

Answer 20

labels

Question 21

numbers, formulas, and functions used in calculations

Answer 21

values

Question 22

built in formula

Answer 22

function

Question 23

info. necessary to calculate and answer

Answer 23

arguments

Question 24

double click it

Answer 24

edit

Question 25

indicate what type of calculations you want to perform on the sales

Answer 25

calc. operators

Question 26

perform mathematical calculations

Answer 26

arithmetic operators

Question 27

work done in virtual environemnt

Answer 27

cloud computing

Question 28

enables you to use range in calculations

Answer 28

reference operators

Question 29

shows the worksheet wo including certain detail

Answer 29

normal view

Question 30

provides more accurate view of how it will look when printed

Answer 30

`page layout view

Question 31

indicates print area

Answer 31

dotted line