Cis 111

Front 1

excel stores speadsheets in files called...

Back 1

workbooks

Front 2

Name box displays

Back 2

the cell reference of the active cell

Front 3

what-if analysis

Back 3

you change one or more values in the spreadsheet and then assess the effect those changes have on the calculated values

Front 4

chart sheet contains...

Back 4

an excel chart that proves a visual representation of worksheet data

Front 5

cell reference

Back 5

each cell within a worksheet is identified by..., which indicates its column and row location

Front 6

planning analysis sheet

Back 6

before beginning to enter data, this helps me develop a plan

Front 7

text data

Back 7

is any combination of letters, numbers and symbols that form words and sentences, also referred to as text string

Front 8

auto complete

Back 8

helps making entering repetitive text easier

Front 9

point

Back 9

equivalent to pixels, 1/72 of an inch

Front 10

clearing vs deleting

Back 10

clearing removes only data, delete removes data and cells

Front 11

cell range

Back 11

a group of cells, can be either adjacent or nonadjacent

Front 12

status bar

Back 12

indicates whether one is in edit mode or ready mode

Front 13

range reference

Back 13

indicates the location and size of the cell range

Front 14

operators

Back 14

a formula is written using... that combine different values, resulting in a single value that is then displayed within the cell

Front 15

arithmetic operators

Back 15

perform addition, subtraction, multiplication, division, and exponentiation

Front 16

order of precedence

Back 16

a set of predefined rules used to determine the sequence in which operators are applied in a calculation

Front 17

function

Back 17

a named operation that returns a value, such as SUM(A1:A10)

Front 18

search string/replacement string

Back 18

the find command to locate a string of characters or replace text with new characters

Front 19

formula view

Back 19

Ctrl+ keys
changes the view so you can analyze the formulas

Front 20

scaling

Back 20

reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed

Front 21

typeface 58

Back 21

a specific design of a set of characters, including letters, numbers, punctuation marks and symbols

Front 22

formatting

Back 22

a process of changing a workbook's appearance by defining the fonts, styles, colors and decorating features

Front 23

theme

Back 23

a collection of formats for text, colors, images and graphical effects

Front 24

protection 77

Back 24

provides options for locking or hiding cells to prevent other users from modifying their content

Front 25

header

Back 25

information that appears in the top margin of each printed page, it includes summary information such as the file name and the date

Front 26

print titles

Back 26

information that appears on every printed page, by specifying rows or columns to repeat on the top or left of each page; use the Print Titles button the page layout tab to do this

Front 27

banded rows

Back 27

displays alternate rows in an excel table with different fill colors

Front 28

footer

Back 28

information that is printed in the bottom margin o each printed page

Front 29

conditional format

Back 29

applies formatting only when a cell's value meets a specified condition. This is often used to help analyze data

Front 30

excel table

Back 30

a range of data cells can be treated as a distinct object in a worksheet

Front 31

legend

Back 31

a key that shows each color used in the worksheet and what it means (specific to conditional formatting)

Front 32

hiding worksheet data 101

Back 32

cells group=format-hide & unhide

Front 33

print area

Back 33

Page Break Preview

Front 34

automatic page breaks 103

Back 34

continue printing the remaining worksheet content of successive pages

Front 35

manual page breaks

Back 35

specify exactly where the page breaks occur

Front 36

creating page headers and footers

Back 36

page 105

Front 37

defining the page margins

Back 37

107

Front 38

functions

Back 38

organized by the category in the function library group 116

Front 39

absolute reference

Back 39

remains fixed when the cell formula is copied to a new location, and has $ in front of the column letter and the row number. $D$5 is the absolute reference to cell D5

Front 40

relative reference

Back 40

interpreted in relation to the location of the cell containing the formula

Front 41

required arguments

Back 41

in bold, are needed for the function to return value

Front 42

arguments

Back 42

numbers, text, or cell references used by the function to return a value

Front 43

optional arguments 117

Back 43

not required for the function to return a value

Front 44

mixed reference

Back 44

contains an absolute row or an absolute column. This could be $N20 or N$20

Front 45

using relative references

Back 45

120

Front 46

using absolute references

Back 46

121

Front 47

using mixed references

Back 47

125

Front 48

working with functions

Back 48

127

Front 49

excel functions category

Back 49

128

Front 50

nested functions

Back 50

function that is placed inside another function 130

Front 51

logical function

Back 51

works with statements that are either true or false

Front 52

financial function

Back 52

related to monetary calculations, such as loans and payments

Front 53

date function

Back 53

inserts or calculates dates and times

Front 54

IF function

Back 54

logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false 138

Front 55

PMT function

Back 55

calculates the amount of a monthly loan payment 138

Front 56

autofill

Back 56

copies content and formats from a cell or range into an adjacent dell or range 139

Front 57

fill handle

Back 57

appears in the lower-right corner of a selected cell or range 139

Front 58

entering data and formulas with auto fill

Back 58

140

Front 59

using auto handle

Back 59

141

Front 60

auto fill

Back 60

143

Front 61

working with logical functions
IF functions

Back 61

151

Front 62

working with date functions

Back 62

155

Front 63

working with financial functions

Back 63

156

Front 64

using the PMT function

Back 64

158

Front 65

embedded chart

Back 65

object in a worksheet

Front 66

data source

Back 66

170

Front 67

series name

Back 67

the first row of the data range, identifies the data series

Front 68

data series

Back 68

the range of values that is plotted as a single unit on the chart

Front 69

category values

Back 69

group or categories that the series values belong to

Front 70

chart area

Back 70

contains the chart and all of the other chart elements

Front 71

chart title

Back 71

descriptive label or name for the chart

Front 72

plot area

Back 72

part of the chart that contains the graphical representation of the data series

Front 73

legend

Back 73

rectangular area that indicates the data markers associated with the data series

Front 74

tick marks

Back 74

identify the units at regular intervals on the chart axis

Front 75

data marker

Back 75

each value in a data series is represented by a data marker such as a column or pie slice

Front 76

creating an excel chart

Back 76

172

Front 77

moving a chart to a different worksheet

Back 77

175

Front 78

creating a column chart

Back 78

displays values in different categories as columns

Front 79

inserting a column chart

Back 79

185

Front 80

formatting the chart columns

Back 80

189

Front 81

sparkline 192

Back 81

a graph that is displayed within a cell. You can create line, column, and win/loss sparklines

Front 82

data bar

Back 82

conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell's value

Front 83

line chart

Back 83

displays data values using a connected line rather than columns or bars

Front 84

gridlines

Back 84

extend the values of the major or minor tick marks across the plot area

Front 85

combination chart

Back 85

combines two or more excel chart types into a single graph. this chart combines a column chart and line chart

Front 86

line chart

Back 86

194

Front 87

setting labels units

Back 87

198

Front 88

editing and revising chart data

Back 88

202

Front 89

creating a combination chart

Back 89

205

Front 90

creating a 3-D chart

Back 90

209

Front 91

creating a chart sheet

Back 91

219