Practical Computer Literacy Chapter 10

Front 1

component of Microsoft Office best suited for working with numbers and formulas

Back 1

Microsoft Excel

Front 2

functions like a visual calculator

Back 2

electronic spreadsheet or worksheet

Front 3

consists of a grid of columns and rows

Back 3

worksheet

Front 4

labeled with letters and runs vertically

Back 4

columns

Front 5

labeled with numbers and runs horizontally

Back 5

rows

Front 6

contains one or more worksheets, each represented by a taba at the bottom of the Excel window

Back 6

workbook

Front 7

rectangle formed by the intersection of a column and row

Back 7

worksheet cell

Front 8

cell you can currently edit or modify (marked with a black outline)

Back 8

active cell

Front 9

series of cells: when specifying a range, use a colon to separate the first and last cells

Back 9

range

Front 10

any text entered into a cell (title)

Back 10

label

Front 11

number that you intend to use in a calculation

Back 11

value

Front 12

used to enter the same number into multiple cells

Back 12

drag and fill

Front 13

specifies how to add, subtract, multiply, divide or otherwise calculate the values in the worksheet cells

Back 13

formula

Front 14

column and row location of a cell

Back 14

cell reference

Front 15

indicates the selected cell

Back 15

marquee

Front 16

predefined formula such as payments and net present value

Back 16

function

Front 17

formula that references the cell in which the formula resides

Back 17

circular reference

Front 18

consists of balues or cell references used to calculate the result of the function

Back 18

argument

Front 19

used to quickly create a function to calculate the totalof a column or row of cells

Back 19

autosum