Spreadsheet Exam 1

what symbol is displayed when a cell's width is too narrow to properly display the numeric contents of the cell?

#

what is the excel operator for "not equal to"?

<>

sheet tab

Identifies a worksheet in a workbook

label

a text value

true or false: a pie chart must have a legend

false

true or false: a relative cell reference refers to a cell by its fixed position in the worksheet

false

true or false: to identify which slice of pie corresponds to which set of data points, look at the value axis

false

what would you do to the table if you wanted to display only data that matches specific criteria?

filter

data series

is made up of related data points

range finder

it occurs when a cell contains a formula and it visually indicates which workbook cells are included in a formula calculation

category axis

known as the x-axis

value axis

known as the y-axis

category labels

labels that display along the bottom of a chart to identify the category of the data

what type of chart should you use to tell over time?

line

pasting

the action of placing cell contents that have been copied to the clipboard

x-axis

the area that identifies the categories of data

y-axis

the range of numbers for the data points

fill handle

the small black square in the lower right corner of a selected cell

arguments

the values that an excel function uses to perform operations

sparklines

tiny charts embedded in calls that show a visual trend alongside the data

page setup

to center worksheet data horizontally and vertically on a page

autofit

to widen a column to fit the cell content of the widest cell in the column

true or false: a pie chart can only be based on one data series

true

true or false: absolute cell reference are indicated by placing a dollar sign in front of the row and column indicators

true

range

two or more cells that excel treats as a single unit

what symbol is used to indicate absolute cell references?

$

which is the excel operator for multiplication?

*

which is the excel operator for division?

/

what is the excel operator for "less than"?

<

what symbol do all excel formulas begin with?

=

which function adds all of its arguments then divides the sum by the number of arguments? where can you find it?

AVERAGE; click on the formulas tab, roll over more functions, go over statistical and find average

if a column of data holds the letter grades for a class, which function could be used to determine how many students had a grade of "A"?

COUNTIF

which function counts the number of cells within a range that meet a certain criteria?

COUNTIF

which of the following is an example of a logical test?

D5>45

what function returns one value if a condition is met, and a different value if it is not?

IF

which function finds the largest value in a selected range of cells? where can you find it?

MAX; click on the formulas tab, roll over auto sum and you'll see max

which excel function would be used to find the middle value of a list of test scores?

MEDIAN

which function finds the middle value in a range? where can you find it?

MEDIAN; click on the formulas tab, roll over more functions, go over statistical and find median

which function would be used to find the lowest score on a series of student test scores?

MIN

which function retrieves the date and time from the computer's calendar and clock? where can you find it?

NOW; click on the formulas tab, roll over the date & time tab and find now

what function adds all of the numbers in a range of cells?

SUM

which excel function would be calculated the total points a student earned on a series of tests?

SUM

which is the excel operator for exponentiation?

^

relative cell reference

a cell address used in a formula that can be adjusted appropriately when the formula is copied to another cell

data point

a data marker, such as a column, dot, or pie slice on a chart. charted values that originate in a worksheet.

volatile

a function such as NOW that is updated each time a workbook is opened

axis

a line that borders the chart plot area and serves as a frame of reference for measurement

pane

a portion of a worksheet window bound by, and separated from, other portions by vertical or horizontal bars

function

a prewritten formula that looks at one or more values, performs an operation, and returns a value

bevel

a shape effect that causes the edges of a shape to appear to be curved or angled

sort

a table setting to arrange all the data in a specific order

logical test

a value or expression that can be evaluated as true or false

chart sheet

a workbook that contains only a chart

conditional formatting

allows a cell to change appearance based on criteria

what is the formula for finding percentage rate of increase?

amount of increase/base

merge & center

an excel command that creates one cell from the selected cells and centers the contents within the new cell

workbook

an excel document

arithmetic operators

an excel tool to perform basic mathematical operations

3-D

an image that appears to have length, width, and depth

comparison

an operator that uses values to evaluate

cell content

anything you type into a cell

what was the feature that fills in the remaining characters of a word if what is typed matches an existing entry in the column?

autocomplete

what is the formula for finding percent for new value?

base percent + percent of increase

cell

created when a row or column intersect

how can a range of cells be converted so that the data can be analyzed?

creating a table

cell styles

defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading

summary sheet

displays and summarizes totals from other worksheets

formula

displays in the formula bar

name box

displays the name of the selected cell, table, chart, or object

what is an example of a data marker?

each pie slice displayed on a pie chart

freeze panes

enables you to select one or more rows or columns and lock them into place

scale to fit

enables you to stretch or shrink the width, height, or both of printed output

goal seek

finds the input needed in one cell for another cell to have a desired value

worksheet

formatted as a pattern of uniformly spaced horizontal rows and vertical columns. individual pages of an excel document.

logical

functions that test for a specific condition, an example is the IF function

autofill

generates and extends a series of values into adjacent cells based on the values of other cells

series

group of items that come one after another in succession

legend

identifies the patterns or colors that are assigned to all the categories in the chart

accounting number format

inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parantheses

chart

instead of a table number, this is used to make data easier to understand

chart area

made up of the chart and all of its element

explode

one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart

what are the two background elements of an excel chart?

plot area and chart area

data bar

provides a visual cue about the value of a cell relative to other cells

absolute cell reference

refers to a cell by its fixed position in the worksheet

find and replace

searches the spreadsheet for one value and replaces it with another

how can you move from one worksheet to another?

sheet tabs

pie chart

shows the relationship of each part of the data to the whole

scaling

shrinks the width and height of the printed worksheet to fit a maximum number of pages

status bar

the current cell mode, the page number, and the view and zoom button display

displayed value

the data you see in a cell

statistical

the function which are useful when the user needs to analyze a group of measurements; ex: AVERAGE and MEDIAN

percentage rate of increase

the percent by which one number increases over another during a specified time frame

which two arguments does the COUNTIF include?

the range of cells to check and the criteria

flash fill

to split data from two or more cells or to combine data from two cells

true or false: a pie chart should be limited to no more than seven categories

true

what does the formula bar display the data known as the?

underlying value

what type of tool is an example of goal seek?

what-if analysis

active cell

when outlined in black, indicates it is ready to accept data

formula bar

you can enter a value or a formula or edit a value or formula in the active cell