Transcript Math Module II Review

Essential Question
Spreadsheet Jeopardy:
Jeopardy Review Game
Spreadsheet Spreadsheet
A
B
Format
Spreadsheet Spreadsheet
Operators
Layout
$1
$1
$1
$1
$1
$2
$2
$2
$2
$2
$5
$5
$5
$5
$5
$10
$10
$10
$10
$10
$20
$20
$20
$20
$20
What is a major advantage of a
spreadsheet?
Answers "what-if" questions
An advantage of a spreadsheet is
the speed of accomplishing what?
Calculating numbers
To create a chart of business
expenses, what software would
be used?
Database
Desktop Publishing
Multimedia
Spreadsheet
The recalculation feature of a
spreadsheet allows a user to do
what?
Change values and update totals
instantly
What is an advantage of setting
the print area for a spreadsheet?
Allows only the defined area to print
The point at which a column and
a row meet is called what?
Cell
The small lines that mark
a unit of measurement
are called what?
Tick marks
The symbol for multiply is:
/
*
-
+
Which function would be
used to indicate the
largest value in a range of
spreadsheet cells?
Max
What are cells that need
to remain the same when
copied?
Absolute
What specific format would
change 29.99 to $29.99?
Currency
What specific format would
change 39.82653 to 39.83?
Percent
Scientific
Decimal
Fraction
What is the BEST way to format
cells C9 through C19?
Format cells two at a time
Format cells one at a time
Highlight desired cells all at once
Highlight the entire spreadsheet
What is the BEST way to resolve
repeated pound signs in a
formula's result?
Widen the column to
accommodate it
What can be added to a
spreadsheet to improve its
appearance?
Attributes
What key do you press to
see the results of a
formula?
Enter
A4:D4 is called a:
Cell address
Column range
Cell range
Row range
Jimmy wants to retrieve
and edit a spreadsheet.
What procedure would he
use after editing the
cells?
Save the spreadsheet before
closing the program
How is alphabetical text
entered into a
spreadsheet?
How is numerical text
entered?
Label
Value
On most charts, what is the
horizontal (bottom) edge of the
plot area called?
X Axis
To create a chart of business
expenses, what software would
be used?
Spreadsheet
What are the faint gray lines that
mark the boundaries of every
cell?
Gridlines
How is a line style or outline
added to a cell?
cell border
What do dashed lines on a
spreadsheet represent?
Page break
Page margin
Page Setup
Page Number
What are the small black squares
called that surround a chart when
selected?
Handles
Final Jeopardy Answer
Final Jeopardy
Question