question

allows you to enter a number once and copy it through worksheets so that it is entered in the same cell on all the selected worksheets.

answer

drilling an entry

question

to reference cells in other worksheets in a workbook you use the worksheet name , which serves as the _____ and the cell reference. Must include a single quotation marks when the worksheet name contains a space character.

answer

worksheet reference

question

a range that spans two or more worksheets in a workbook. The reference to this range is 3-D reference.

answer

3-D range

question

defines the appearance and format of a printed worksheet.

answer

page setup

question

is a reference to a cell or range of cells in another workbook.

answer

link

question

area in which you can enter data , surrounded by a heavy border.

answer

active cell

question

button that allows you to copy values with/without formatting or the format only .

answer

auto fill option

question

corrects common mistakes when you complete a text entry in a cell.

answer

auto correct feature

question

properties that include system file properties

answer

automatically updated properties

question

text that has a darker appearance than normal text

answer

bold

question

cancels an entry by tapping or clicking

answer

cancel box

question

conveys a visual representation of data

answer

chart

question

range of cells receiving the copy

answer

destination area

question

details about a file such as the project author , title and subject

answer

document properties

question

small black square located in the lower-right corner of the active cell

answer

fill handle

question

defines appearance and shape of letters and numbers

answer

font

question

defines the color of characters

answer

font color

question

specifies the size of characters

answer

font size

question

indicates how the characters are emphasized

answer

font style

question

how you make a worksheet easier to read and understand

answer

format

question

information that exists on a physical medium such as paper

answer

hard copy

question

key that selects the cell at the beginning of a row with the active cell

answer

HOME

question

excel inserts the character and moves all characters to the right

answer

insert mode

question

blinking vertical line that indicates where next character typed will display

answer

insertion point

question

chart used to illustrate changes in data over time

answer

line chart

question

creating a single cell by combining two or more cells

answer

merging cells

question

0,1,2,3,+,_,(),?,.$ , % E , e

answer

number

question

excel replaces the character to the right of the insertion point

answer

overtype mode

question

key that selects the cell down one worksheet window from the active cell.

answer

PAGE DOWN

question

key that selects the cell up one worksheet window from the active cell

answer

PAGE UP

question

chart used to show the contribution of each piece of data to the whole

answer

pie chart

question

1/72 of an inch

answer

point

question

series of two or more adjacent cells in a column or row

answer

range

question

each adjusted cell reference

answer

relative reference

question

includes a needs statement,source of data , and summary of calculations

answer

requirements documents

question

to make a cell active

answer

select

question

cell being copied

answer

source area

question

Unmergining a cell

answer

splitting

question

associated with all Microsoft office files and include author, title, subject.

answer

standard properties

question

adds all the numbers in a range of cells

answer

SUM function

question

chart used to compare data from three columns in a 3-dimensional manner

answer

surface chart

question

any set of characters containing letters, hyphens, or spaces

answer

text

question

allows data easily to be summarized and charted

answer

worksheet

question

arithmetic operator that adds contents of cells

answer

addition

question

button that gives options for how to fill cells following a fill operation

answer

auto fill options

question

sums numbers then divides by the number of values

answer

AVERAGE function

question

the width of the column will increase or decrease so the widest entry will fit

answer

best fit

question

formula in a cell that contains a reference back to itself.

answer

circular reference

question

colors like blue,green, and violet that tend to pull away from a reader

answer

cooler colors

question

the process of finding and correcting errors

answer

debugging

question

arithmetic operator that divides contents of a cell

answer

division

question

used to indicate the start a formula

answer

equal sign

question

arithmetic operator that raises to a power

answer

exponentiation

question

display a dollar sign in the far left of the cell

answer

fixed dollar sign

question

dollar sign that appears immediately to the left of the first digit

answer

floating dollar sign

question

text and graphics that print at the top of each page

answer

footer

question

can be assigned to a cell and will display calculated result

answer

formula

question

shows the actual formulas you have entered rather than the resulting values

answer

formulas version

question

pre-written formula built into excel

answer

function

question

text and graphics that print at the top of each page

answer

header

question

technique used to hide data that is sensitive or not relevant

answer

hiding cells

question

lists formatting options following an insertion of cells, rows, or columns

answer

insert options

question

portions of a printed page outside the main body of the printed document

answer

margins

question

displays the highest value for a range of values

answer

MAX function

question

Display the lowest value for a range of values

answer

MIN function

question

arithmetic operator that multiples

answer

multiplication

question

arithmetic operator that makes a number negative

answer

negation

question

default view in excel

answer

normal view

question

specifies how moved or pasted items should appear

answer

paste options

question

arithmetic operator that multiplies by 0.01

answer

percentage

question

dot on screen that contains color

answer

pixel

question

selecting cells for use in a formula by using your finger or the pointer

answer

point mode

question

used to find which cells are referenced in a formula

answer

range finder

question

used to check worksheet for spelling errors

answer

spell checker

question

arithemetic operator that subtracts contents of cells

answer

subtraction

question

lists error-checking options following an invalid formula

answer

trace error button

question

shows results of the formulas rather than the actual formula

answer

values version

question

colors like red and orange that tend to reach toward a reader

answer

warmer colors

question

keeps the same cell reference as it copies a formula from one cell to another

answer

absolute cell reference

question

values in cells that you can change to determine new values for formulas

answer

assumptions

question

button used to copy contents and format of a source area to the office clipboard

answer

copy button

question

auto fill option that fills destination area but does not create a series

answer

copy cells

question

shows the date a workbook was created or the time period it represents

answer

date stamp

question

button used to move the contents of a cell to the left two spaces

answer

decrease indent

question

using touch or the mouse to move or copy cell

answer

drag and drop

question

key that can be used in place of the paste button

answer

enter

question

auto fill option that fills destination area using format or source area

answer

fill formatting only

question

auto fill option that fills destination area with series of months

answer

fill months

question

default auto fill option that excel used to fill an area

answer

fill series

question

auto fill option that fills destination area with contentes without formatting

answer

fill without formatting

question

used to quickly copy a cell's format to another cell

answer

format painter

question

symbols that assign a format to numbers as they are entered

answer

format symbol

question

to determine the value of a cell on which the formula depends

answer

goal seeking

question

bar going across the middle of a split screen

answer

horizontal split bar

question

used when you want to assign a value to a cell based on a logical test

answer

IF function

question

button used to move the contents of a cell to the right two spaces

answer

increase indent

question

cell with only one dollar sign before the column or row

answer

mixed cell reference

question

IF function within an IF function

answer

nested IF

question

function that will display the current system date and time

answer

NOW function

question

formula error messages always begin with this

answer

number sign

question

button used to paste a copy of the Office clipboard contents

answer

Paste button

question

immediately display when you click the paste button

answer

paste options button

question

instructs excel to adjust cell references as it copies to destination area.

answer

relative cell reference

question

scrutinizing the impact of changing values referenced by a formula in a celll

answer

sensitivity analysis

question

shows trends and variations in a range of data within a single cell.

answer

sparkline chart

question

breaking the excel window into four panes

answer

splitting (chapter 3)

question

format that underlines only the characters in a cell , not the entire cell.

answer

underline

question

bar going up and down the middle of a split screen

answer

vertical split bar

question

number that the function returns is not constant

answer

volatile function

question

to magnify the appearance of a worksheet or chart

answer

zoom in

question

to shrink the appearance of a worksheet or chart.

answer

zoom out

question

cell references with dollar signs

answer

absolute cell reference chapter 4

question

shows beginning/ending loan balances and amount that is principal/interest

answer

amortization schedule

question

payments made at end of each of a fixed number of periods at fixed interest rate

answer

annuity

question

when excel continually will review the workbook for errors

answer

background formula checking

question

often created from column and row titles

answer

cell name

question

ensures that users do not change values critical to a worksheet

answer

cell protection

question

unused column with a significantly reduced width

answer

column border

question

print option that indicates where comments are to be displayed on a printout

answer

comments box

question

used to automate data analyses and organize the answers returned by excel

answer

data table

question

button used to invoke the formula checker

answer

error checking button

question

can be dragged to create a series

answer

fill handle chapter 4

question

checks formulas in a worksheet for rule violations

answer

formula checker

question

function that returns future value of an investment

answer

FV function

question

assigning a format to all the cells in all the worksheets in a workbook

answer

global formatting

question

print option that instructs excel to print Gridlines when selected

answer

Gridlines check box

question

shows only the parts of a workbook that user needs to see

answer

hiding

question

adds clarity to your formulas by allowing you to assign names to cells

answer

Name Manager

question

print option that determines the order in which multipage worksheets print

answer

page order area

question

used to protect a worksheet

answer

password

question

calculates loan payment based on loan amount and constant payments/interest

answer

PMT

question

rate

answer

function chapter 4

question

cells that you cannot change

answer

protected cells

question

function that returns the present value of an investment

answer

PV function

question

used to highlight cells that provide data for a formula

answer

range finder chapter 4

question

function used to round values

answer

ROUND function

question

used to display a menu that identifies errors

answer

Trace error button Chapter 4

question

cells that you can change

answer

unprotected cells

question

a series like : 1, 1, 1, 1, etc

answer

auto fill series

question

formula that depends on its own value

answer

circular reference

question

process of summarizing data included on multiple worksheets onto one worksheet

answer

consolidation

question

allow you specify how a cell entry assigned a format will appear

answer

custom format codes

question

a series like Jan , Feb, Mar, etc

answer

date series

question

allows you to enter a number once and copy it through other worksheet

answer

drilling an entry

question

used to grad thorough cells to create a series

answer

fill handle

question

format in which dollar sign appears in same position in a cell

answer

fixed

question

appears at the bottom of every printed page

answer

footer chapter 5

question

a series that multiples values by a constant factor

answer

growth series

question

appears at the top of every printed page

answer

header

question

a series like 1,2,3,4 etc

answer

linear series

question

reference to a cell or range of cells in another workbook

answer

link chapter 5

question

white space surrounding the printed worksheet or chart

answer

margin

question

allows you to merge styles from other workbooks

answer

merge style button

question

format style that excel initially assigns to all cells in a workbook

answer

Normal style

question

show the boundaries of what will print on each page

answer

page breaks

question

used to round numbers to a specified number of decimal places

answer

Round function chapter 5

question

a linked workbook

answer

source workbook

question

group of format specifications that are assigned to a style name

answer

style

question

used to reference cells in other sheets in a workbook

answer

worksheet chapter 5

question

worksheet name

answer

worksheet reference

Excel – Assignment Writing – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards