Excel 2007 For Medical Professionals - Unit A

Front 1

symbols that indicate what type of calculation to perform on the cells, ranges, or values

Back 1

calculation operators

Front 2

the intersection of a column and a row in a worksheet, datasheet, or table

Back 2

cell

Front 3

the location of a cell, expressed by cell coordinates; for example, the cell address of the cell in column A, row 1 is A1

Back 3

cell address

Front 4

dark rectangle that outlines the active cell

Back 4

cell pointer

Front 5

in a calculation, symbols that compare values for the purpose of true/false results

Back 5

comparison operators

Front 6

to make a change to the contents of an active cell

Back 6

edit

Front 7

a computer program that performs calculations and presents numeric data

Back 7

electronic spreadsheet

Front 8

the area above the worksheet grid where you enter or edit data in the active cell

Back 8

formula bar

Front 9

an arithmetic symbol, such as the equal sign (=), used to start a formula

Back 9

formula prefix

Front 10

a set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averaging, on values or cells

Back 10

formulas

Front 11

a special, predefined formula that provides a shortcut for a commonly used or complex calculation, for example, SUM (for calculating a sum) or FV (for calculating the future value of an investment)

Back 11

functions

Front 12

sheet tab to the right of sheet 3 (or whatever the last sheet you added is)

Back 12

insert worksheet button

Front 13

descriptive text or other information that identifies rows, columns, or chart data, but is not included in calculations

Back 13

labels

Front 14

print setting that positions a document so it spans the widest margins of the page, making the page wider than it is tall

Back 14

landscape orientation

Front 15

an area in the lower-left corner of the status bar that informs you of a program's status. For example, when you are changing the contents of a cell, the word 'Edit' appears

Back 15

mode indicator

Front 16

left-most area of the formula bar that shows the call reference or name of the active cell

Back 16

name box

Front 17

default worksheet view that shows the worksheet without features such as headers and footers; ideal for creating and editing a worksheet, but may not be detailed enough when formatting a document

Back 17

normal view

Front 18

provides an accurate view of how a worksheet will look when printed, including headers and footers

Back 18

page layout view

Front 19

a print setting that positions the document on the page so the page is taller than it is wide

Back 19

portrait orientation

Front 20

a selection of two or more cells, such as B5:B14

Back 20

range

Front 21

mathematical calculations that enable you to use ranges in calculations

Back 21

reference operators

Front 22

bars on the right edge (vertical scroll bar) and bottom edge (horizontal scroll bar) of the document window that allow you to move around in a document that is too large to fit on the screen at once

Back 22

scroll bars

Front 23

arrows to the left of sheet tabs for navigating between worksheets

Back 23

sheet tab scrolling buttons

Front 24

identifies sheets in a workbook and lets you switch between sheets; sheet tabs are located below the worksheet grid

Back 24

sheet tabs

Front 25

bar at the bottom of the Excel window that provides information about various keys, commands, and processes

Back 25

status bar

Front 26

a file whose content or formatting serves as the basis for a new workbook; Excel template files have the file extension .xltx

Back 26

template

Front 27

mathematical calculations that join strings of text in different cells

Back 27

text concatenation operators

Front 28

numbers, formulas, and functions used in calculations

Back 28

values

Front 29

a decision-making tool in which data is changed and formulas are recalculated, in order to predict various possible outcomes

Back 29

what-if analysis

Front 30

a collection of related worksheets contained within a single file

Back 30

workbook

Front 31

a single sheet within a workbook file; also, the entire area within an electronic spreadsheet that contains a grid of columns and rows

Back 31

worksheet

Front 32

in a formula, symbols that perform mathematical calculations, such as plus (+), minus (-), multiplication (*), divide (/), or exponentiation (^)

Back 32

arithmetic operators

Front 33

the cell in which you are currently working

Back 33

active cell

Front 34

the information necessary to calculate an answer

Back 34

arguments

Front 35

quick reference information shown in status bar when a range of cells is selected

Back 35

average, count, sum (on status bar)