Cqs111

Front 1

Active Cell

Back 1

The cell that is currently selected and open for editing

Front 2

Alignment

Back 2

The manner in which a cell's contents are arranged within that cell (left,center,right)

Front 3

Arguements

Back 3

specific data a function requires to calculate a value

Front 4

Autofill

Back 4

the ability to extend a series of values based on the contents of a single cell

Front 5

Autofilter

Back 5

a microsoft excell tool that you can use to create filters

Front 6

Autoformats

Back 6

predefined formats that can be applied to a worksheet

Front 7

cell

Back 7

the box at the intersection of a row and column

Front 8

cell range

Back 8

a group of cells

Front 9

cell reference

Back 9

the letter and number combination that identifies the row and column intersection of a cell

Front 10

charts

Back 10

visual summaries of worksheet data, also called graphs

Front 11

columns

Back 11

cells that are on the same verticle line

Front 12

conditional formats

Back 12

formats that are applied only when cell contents meet certain criteria

Front 13

data list

Back 13

one or more columns of data depicting multiple instance of a single thing

Front 14

embed

Back 14

to save a file as part of another file, as opposed to linking one file to another

Front 15

error code

Back 15

a brief message that appears in a worksheet cell, describing a problem with a formula or a function

Front 16

field

Back 16

a column in a data list

Front 17

fill handle

Back 17

the square at the lower right corner of a cell you drag to indicate other cells that should hold values in the series

Front 18

fill series

Back 18

the ability to extend a series of values based on the contents of 2 cells, where the 1st cell has the starting values for the series and the 2nd shows the increment

Front 19

filter

Back 19

a rule that excel uses to determine which worksheet rows to display

Front 20

formats

Back 20

predefined sets of characteristics that can be applied to cell contents

Front 21

formula

Back 21

an expression used to calculate a value

Front 22

freeze

Back 22

to assign cells that will remain at the tip of a worksheet regardless of how far down the worksheet a user scrolls

Front 23

function

Back 23

a predefined formula whose mathematical or logical operators have been incorporated into a function name

Front 24

goal seek

Back 24

an analysis too that finds the value for a selected cell that would produce a given result from a calculation

Front 25

graphs

Back 25

visual summaries of worksheet data, also called charts

Front 26

hyperlink

Back 26

a reference to a file on the internet

Front 27

link

Back 27

formula that has a cell show the value from another cell

Front 28

locked cells

Back 28

cells that cannot be modified if their worksheet is protected

Front 29

merge and center

Back 29

an operation, initiated by clicking the button, that combines a group of cells into 1 cell. and vice versa

Front 30

named range

Back 30

a group of related cells defined by a single name

Front 31

paste options

Back 31

a button, which appears after you paste an tiem from the clipboard, that lets you control how the item appears in the workbook

Front 32

query

Back 32

a statement that locates records in a database

Front 33

range

Back 33

a group of related cells

Front 34

refresh

Back 34

to update the contents of 1 document when the contents of another document are changed

Front 35

relative reference

Back 35

a cell reference in a formula that refers to a cell that is a specific distance away from the cell that contains the formula.

Front 36

rows

Back 36

cells that are on the same horizontal line in a worksheet

Front 37

sheet tab

Back 37

the indicator for selecting a worksheet, located in the lower left corner of the workbook window

Front 38

sort

Back 38

to reorder the contents of a worksheet based on a criterion

Front 39

split bar

Back 39

a line that defines which cells have been frozen at the top of a worksheet

Front 40

subtotals

Back 40

partial totatls for related data in a worksheet

Front 41

tables

Back 41

data lists in a database

Front 42

tags

Back 42

marks used to indicate display properties or to communicate data about the contents of a document

Front 43

template

Back 43

a workbook used as a pattern for creating other workbooks

Front 44

validation rule

Back 44

a test that data must pass to be entered into a cell without generating a warning message

Front 45

what-if analysis

Back 45

analysis of the contents of a worksheet to determine the impact that specific changes have on your calculations

Front 46

workbook

Back 46

the basic excel document consisting of one or more worksheets

Front 47

worksheet

Back 47

a page in an excel workbook