Welcome to Office Jeopardy (Excel edition) Grauer and Barber

1
Welcome to Office Jeopardy(Excel edition)

• Grauer and Barberwww.prenhall.com/grauer

2
Charts
Beyond the Basics
Keyboard Shortcuts
Excel 101
Functions
3
It helps you to create a chart by prompting for
information

• What is the Chart Wizard?

4
A chart that is located on a worksheet as opposed
to a chart sheet

• What is an embedded chart?

5
Used to show proportion or market share

• What is a pie chart?

6
A chart that plots data series on top of one
another

• What is a stacked column chart?

7
Displays multiple data series without showing the
total value for each series

• What is a side-by-side column chart?

8
The intersection of a row and column

• What is a cell?

9
Used at the beginning of every formula

• What is an equal sign?

10
The cell that is one row below and one column to
the left of cell B5

• What is cell A6?

11
A cell reference such as A1

• What is an absolute reference?

12
It contains one or more worksheets

• What is a workbook?

13
Boldface and Italics

• What are CtrlB and CtrlI?

14
CtrlX, CtrlC, and CtrlV

• What are cut, copy, and paste?

15
Moves forward or backward within a dialog box

• What are Tab and ShiftTab?

16
Pulls down the File menu

• What is AltF?

17
Goes to cell A1 of the active worksheet

• What is CtrlHome?

18
Indicated by a red triangle in the upper right
corner

• What is a comment?

19
Used to import current stock prices into a
worksheet

• What is a Web query?

20
It displays a context sensitive menu

• What is the right mouse button (right click)?

21
Used to enter the current date into a cell

• What is the Today (or Now) function?

22
A chart with two different scales

• What is a combination chart?

23
Used to determine the smallest or largest value

• What are the Min and Max functions?

24
It has three arguments (logical condition, value
if true, value if false)

• What is an If function?

25
It is used in conjunction with periodic
investments such as an IRA

• What is the FV (Future Value) function?

26
The arguments in the PMT function

• What are the interest rate, term (number of
  periods), and principal?

27
Used instead of multiple If functions to extract
values from a table

• What is the VLOOKUP (or HLOOKUP) function?