Instructions for using this template'

1
Instructions for using this template.

• Remember this is Jeopardy, so where I have
  written Answer this is the prompt the students
  will see, and where I have Question should be
  the students response.
• To enter your questions and answers, click once
  on the text on the slide, then highlight and just
  type over whats there to replace it. If you hit
  Delete or Backspace, it sometimes makes the text
  box disappear.
• When clicking on the slide to move to the next
  appropriate slide, be sure you see the hand, not
  the arrow. (If you put your cursor over a text
  box, it will be an arrow and WILL NOT take you to
  the right location.)

2
Jeopardy
Choose a category. You will be given the
answer. You must give the correct question.
Click to begin.
3
Choose a point value.
Choose a point value.
Click here for Final Jeopardy
4
Category A
Category B
Category D
Category E
Category F
Category C
10 Point
10 Point
10 Point
10 Point
10 Point
10 Point
20 Points
20 Points
20 Points
20 Points
20 Points
20 Points
30 Points
30 Points
30 Points
30 Points
30 Points
30 Points
40 Points
40 Points
40 Points
40 Points
40 Points
40 Points
50 Points
50 Points
50 Points
50 Points
50 Points
50 Points
5
A group of spreadsheets in one file
6
What is a workbook
7
AF240
8
What is the cell address of a cell in column AF
and row 240
9
Use this to save time by not recreating a document
10
What is use a template
11
.xlt
12
What is the file extension for an Excel template
13
Equal sign, Operator, and Operand
14
What are the three parts of a formula
15
If both division and addition are used in a
formula, which calculation would be performed
first
16
What is the division
17
This is inserted above the active row
18
What is a new row
19
Use this to copy formulas to adjacent cells
20
What is the fill handle
21
Use these to group operators in a formula
22
What are parenthesis
23
This is used to designate a range of cells
24
What is the colon ( )
25
These are short cuts to commonly used formulas
26
What are functions
27
Used to verify that a cell is formulated properly
28
What is estimation
29
This is used to find the highest number in a list
of data
30
What is the MAX function
31
Use this to test scenarios and calculate results
32
What are what-if analyses
33
Creating multiple what-if analyses and
calculating the results
34
What are scenarios
35
This is how scenarios are displayed
36
What is a Summary Scenario
37
To create a duplicate worksheet do this
38
What is use the copy sheet command
39
This shows the results of different data
situations
40
What is a scenario
41
Apply this type of formatting to cells that match
test results that are true
42
What is conditional formatting
43
Organizing data according to kind
44
What is sorting
45
This type of chart shows how an amount changes
over time
46
What is a line chart
47
To compare amounts use this type of chart
48
What is a bar chart
49
This is used to connect to another spreadsheet
50
What is a hyperlink
51
To analyze data in multiple worksheets use this
52
What is a 3-D reference
53
To move a worksheet you must first do this
54
What is select the location where it will be moved
55
To change the margins of a spreadsheet do this
56
What is click File/Page Set up and margins
57
Do this to bring data from another source to the
current workbook
58
What is import data
59
Organizes rows of data without rearranging the
order of rows
60
What is filtering
61
The file extension for a web page is
62
What is .htm
63
This is often used when preparing a graph
64
What is filtering
65
Final Jeopardy
Make your wager
66
Z to A
67
What is a descending sort