Transcript Jeopardy (Excel edition) www.prenhall.com/grauer Grauer and Barber

Welcome to Office Jeopardy
(Excel edition)
Grauer and Barber
www.prenhall.com/grauer
Click once to display answer; click the answer to return to the
question board
Charts
Excel 101
Keyboard
Shortcuts
Beyond the Functions
Basics
200
200
200
200
200
400
400
400
400
400
600
600
600
600
600
800
800
800
800
800
1000
1000
1000
1000
1000
(c) Grauer and Barber - 2005
It helps you to create a chart by
prompting for information
What is the Chart Wizard?
Click once to display answer; click the answer to return to the
question board
A chart that is located on a
worksheet as opposed to a
chart sheet
What is an embedded chart?
Click once to display answer; click the answer to return to the
question board
Used to show proportion or
market share
What is a pie chart?
Click once to display answer; click the answer to return to the
question board
A chart that plots data series on
top of one another
What is a stacked column
chart?
Click once to display answer; click the answer to return to the
question board
Displays multiple data series
without showing the total value
for each series
What is a side-by-side
column chart?
Click once to display answer; click the answer to return to the
question board
The intersection of a row and
column
What is a cell?
Click once to display answer; click the answer to return to the
question board
Used at the beginning of every
formula
What is an equal sign?
Click once to display answer; click the answer to return to the
question board
The cell that is one row below
and one column to the left of
cell B5
What is cell A6?
Click once to display answer; click the answer to return to the
question board
A cell reference such as $A$1
What is an absolute
reference?
Click once to display answer; click the answer to return to the
question board
It contains one or more worksheets
What is a workbook?
Click once to display answer; click the answer to return to the
question board
Boldface and Italics
What are Ctrl+B and Ctrl+I?
Click once to display answer; click the answer to return to the
question board
Ctrl+X, Ctrl+C, and Ctrl+V
What are cut, copy, and
paste?
Click once to display answer; click the answer to return to the
question board
Moves forward or backward
within a dialog box
What are Tab and
Shift+Tab?
Click once to display answer; click the answer to return to the
question board
Pulls down the File menu
What is Alt+F?
Click once to display answer; click the answer to return to the
question board
Goes to cell A1 of the active
worksheet
What is Ctrl+Home?
Click once to display answer; click the answer to return to the
question board
Indicated by a red triangle in
the upper right corner
What is a comment?
Click once to display answer; click the answer to return to the
question board
Used to import current stock
prices into a worksheet
What is a Web query?
Click once to display answer; click the answer to return to the
question board
It displays a context
sensitive menu
What is the right mouse
button (right click)?
Click once to display answer; click the answer to return to the
question board
Used to enter the current date
into a cell
What is the Today (or Now)
function?
Click once to display answer; click the answer to return to the
question board
A chart with two different
scales
What is a combination
chart?
Click once to display answer; click the answer to return to the
question board
Used to determine the smallest
or largest value
What are the Min and Max
functions?
Click once to display answer; click the answer to return to the
question board
It has three arguments (logical
condition, value if true, value if
false)
What is an If function?
Click once to display answer; click the answer to return to the
question board
It is used in conjunction with
periodic investments such as an
IRA
What is the FV (Future
Value) function?
Click once to display answer; click the answer to return to the
question board
The arguments in the PMT function
What are the interest rate,
term (number of periods),
and principal?
Click once to display answer; click the answer to return to the
question board
Used instead of multiple If
functions to extract values
from a table
What is the VLOOKUP (or
HLOOKUP) function?
Click once to display answer; click the answer to return to the
question board