Excel unit 8

Question 1

excel

Answer 1

electronic spreadsheet within Microsoft office

Question 2

Electronic spredsheet

Answer 2

Program used to perform numeric valuations and analyze and present numeric data

Question 3

worksheet

Answer 3

each individual spreadsheet you work in

Question 4

workbork

Answer 4

file of several worksheets. File extension: .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 spreadsheets to

Answer 7

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

Question 8

name box

Answer 8

display the active cell address

Question 9

formalula bar

Answer 9

allows you to enter or edit dada in worksheet

Question 10

cell

Answer 10

intersection of a column and row

Question 11

cell address

Answer 11

unique location indetifted by the coordinated of the intersecting column and row

Question 12

cell pointer

Answer 12

dark rectangles that outlines the cell in which you are working

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 sheet tabs when available

Question 16

status bar

Answer 16

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

Question 17

mode indicator

Answer 17

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

Question 18

range

Answer 18

a selection of 2 or more cells is a range

Question 19

formula

Answer 19

equations in a worksheet

Question 20

addition +

Answer 20

=a56+a7

Question 21

Subtraction -

Answer 21

=a5-10

Question 22

multination x

Answer 22

=a5xa7

Question 23

divison /

Answer 23

=a5/a7

Question 24

percent %

Answer 24

=35%

Question 25

exponent ^

Answer 25

=6^2

Question 26

labels

Answer 26

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

Question 27

Values

Answer 27

are number, formulas, and functions, used in calculations

Question 28

function

Answer 28

built in formula

Question 29

arguments

Answer 29

info. necessary to calculate and answer- cell reference

Question 30

edit

Answer 30

to edit a cell, double click it

Question 31

formula prefix

Answer 31

= (what a formula starts with)

Question 32

Calculation operators

Answer 32

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

Question 33

arithmetic operators

Answer 33

perform mathematical calculations

Question 34

cloud computing

Answer 34

work done in virtual environment

Question 35

reference operators

Answer 35

enable you to use ranges in calculations

Question 36

normal view

Answer 36

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

Question 37

page layout view

Answer 37

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

Question 38

dotted lines

Answer 38

indicates print area