What is page layout view?

view to apply headers and footers

What is a COUNT function?

counts number of cells in a range that contains numbers

What is a data series?

group of related values that are in the same column or rows

displays comparisons and values at a specific period of time

what does a fill handle tool do?

feature used to full numbers, dates,or text to desired cells

What is a Column Chart?

illustrates data changes over a period of time

What does the wrap text feature do?

wraps text to so it appears on multiple lines of the cell

symbols textures colors used to different data series

1 data series display each value as a percentage of a whole

What is the IF function?

evaluates a specific condition is true or false

small bar graph giving a representation of # or stat info

What is a circular reference?

when a formula includes the cell address of the formula

What is a data point?

single value or piece of data from a data series

What is the AVERAGE function?

adding cells together and diving by the total

line indicating trend on a chart

information in the parentheses used for the function

What is a print area?

one or more areas of cells that you designate to print

cells that contain values & labels to be graphed in a chart

What is a absolute reference?

fixed location of a cell referenced in a cell or dialog box

studbud

Info Processing Final Exam Review

36 termsStudBud Administration

review

Flashcards36 cardsFPractice quizPHost liveL

Questions 36

Answers

1
PEMDAS is the mathematical operations used with functions.
true
false
2
What is a MAX function?
smallest number in cell range
largest value in cell range
adding cells together and dividing by the total
counts the number of cells in a range that contains numbers
3
How does Excel align numbers?
right alignment
left alignment
4
What is an automatic page break?
dotted line
solid line
5
What is page layout view?
default view
view to apply headers and footers
view page breaks
6
What is a mixed cell reference?
contain on relative reference
identify location of cell
fixed location of cell reference in a formula or dialog box
7
What dopes the merge and center feature do?
wraps text to so it appears on multiple lines of the cell
puts text in middle of cell
8
What are cell styles?
all of the above
font name
size & color
alignment & spacing
9
What is a COUNT function?
counts number of cells in a range that contains numbers
largest value in a cell range
smallest value in a cell range
adding cells together and dividing the total
10
What is a row?
numbers
letters
11
What is a data series?
single value or piece of data from data series
group of related values that are in the same column or rows
12
What is a manual page break?
solid line
dotted line
13
What is a column?
letters
numbers
14
What is a Bar Chart?
displays comparisons and values at a specific period of time
illustrates data changes over a period of time
displays trends in data over time
15
what does a fill handle tool do?
visual representation of numeric data in a worksheet
feature used to full numbers, dates,or text to desired cells
16
What is a Column Chart?
illustrates data changes over a period of time
displays trends in data over time
uses one data series to display one value
17
What does the wrap text feature do?
puts text in middle of cell
wraps text to so it appears on multiple lines of the cell
18
What is a legend?
symbols textures colors used to different data series
me
Mrs. Kunz
chloe
19
What is a Pie Chart?
1 data series display each value as a percentage of a whole
illustrates data changes over a period of time
displays trends in data over time
20
What is the IF function?
evaluates a specific condition is true or false
range of cells in a row or column
total number of periods for repayment of the loan
21
What is the MIN function?
counts number of cells in a range that contains numbers
adding cells together and diving the total
largest value in cell range
smallest value in cell range
22
What are Sparklines?
background color for the element
small bar graph giving a representation of # or stat info
text box with present font style
23
What is a circular reference?
fixed location of a cell referenced in a formula
when a formula includes the cell address of the formula
spaces or special characters
24
What is a built in formula that adds the values in a selected range?
SUM function
MIN funtion
MAX function
AVERAGE function
25
What is a data point?
group of related values that are in the same column or row
single value or piece of data from a data series
26
What is page break view?
view page breaks
view to apply headers and footers
default view
27
Syntax is the required parts of a formula and the rules controlling the order of the parts.
false
true
28
What is the AVERAGE function?
largest value in the cell range
smallest value in the cell range
count number of cell in the cell range that contains numbers
adding cells together and diving by the total
29
What is a relative reference?
fixed location of a cell reference in a cell or dialog box
identify location of cell
contain on relative reference
30
What are Trendlines?
all of the above
dogs
line indicating trend on a chart
cats
31
How does Excel align text in a cell?
left alignment
right alignment
32
What are arguments?
average funtion in a cell
information in the parentheses used for the function
pre-defined formulas
33
What is a print area?
displays formulas instead of results
one or more areas of cells that you designate to print
intersection of column and row
mixed cell reference
34
What is source data?
cells that contain values & labels to be graphed in a chart
is a cell containing a value
is a text label that describes each data series
35
What is normal view?
default view
view page breaks
view to apply headers and footers
36
What is a absolute reference?
contain on relative reference
fixed location of a cell referenced in a cell or dialog box
identify location of cell

Info Processing Final Exam Review Flashcards | StudBud