PowerPoint
General Excel
Chapter 1
Chapter 2
Chapter 3
100
How do you begin writing a formula in Excel?
=
100
TRUE or FALSE. You should never reference a cell in your formulas because that cell might change and mess up your formulas.
False!! Always reference cells when you can so that your data automatically updates itself.
100
TRUE or FALSE. Functions are already in excel, You do not need to do anything to them.
FALSE! You need to add arguments or input information fro excel to carry out the functions.
100
Name the chart that is like a column chart on its side.
Bar
200
TRUE or FALSE. You should always use complete sentences on your slides.
FALSE. Short, concise language should be used on slides.
200
TRUE or FALSE. Letters go down the rows and number go across the columns in an excel worksheet.
FALSE!
200
True or false. Excel evaluates your formulas from left to write in calculating your answers.
FALSE! Excel uses the Order of Operations to evaluate your formulas.
200
What function can I use if I want to add all column B values that meet a certain criteria in column A?
SUMIF
200
TRUE or FALSE. Excel has over 10 chart types to choose from.
TRUE! Excel has 11 with variations of each.
300
TRUE or FALSE. You can customize how quickly or slowly (down to the second) text and images appear on slides.
TRUE!
300
Write a formula to add these cells: A1, A2, A3, B4, B5, B6, C1
=SUM(A1:A3,B4:B6,C1) =SUM(A1, A2, A3, B4, B5, B6, C1) =A1+A2+A3+B4+B5+B6+C1
300
TRUE or false. The MEAN function includes empty cells in its calculation
FALSE! The MEAN function omits empty cells.
300
If I want to randomly generate a set of numbers in excel, what function can I use to do that? State the specific function.
RANDBETWEEN
300
What is the best type of chart to use to show stock prices the best.
Stock chart!
400
The way a slide changes from one to the next is called a __________________________
Transition
400
If I want my cells to stay the same when I drag my formulas, what do is the name of the thing I have to do to them? It is indicated by the $ symbol.
Absolute Reference
400
What is the symbol to write an exponent in a written formula?
^
400
In the AVERAGEIF function it calls for 3 arguments: (range, criteria, sum_range). What does the range refer to? …be specific.
The range indicates the area you want excel to "lookup" the criteria to meet or not.
400
Name the most appropriate chart for showing the contribution of each store to the entire corporation.
Pie Chart
500
Motions of text or images within a slide are called______
Animations
500
When I import data from a text file, what do I have to do to indicate breaks where I want Excel to separate the columns?
Deliminate the file
500
How would a I reference cell C7 on a separate sheet named FSU Football?
‘FSU Football!’C7
500
Write a formula to round cell B15 to the nearest hundredth.
= ROUND(B15,2)
500
Which chart should you use to illustrate the relationship between two variables.
Scatter plot
M
e
n
u