Charts
All About Pivot Tables
=If statements!
'90s Songs
Health
100
Chart of parts of a whole
What is a pie chart
100
The tab and function group under which you will find the option to insert a pivot table
What is the Insert tab in the Tables group
100
True or False
For every single IF( function, there needs to be the same number of closing round brackets.
What is True
100
Song that opens with: "It's been seven hours and fifteen days since you took your love away?"
What is Nothing Compares 2 U by Sinead O'Connor
100
What virus did the World Health Organization say would infect 40 million people by the year 2000?
What is HIV
200
Chart of trends over time
What is a line chart
200
Which of the following is not a box in the PivotTables Fields list?
Column Labels
Values
Report Filter
Formulas
What is "Formulas"
200
Which is correct?
=IF(D2>=60,”Great”,IF(D2>40,”Average”,”Bad”))
=IF(D2>=40,”Average”,IF(D2>60,”Great”,”Bad”))
What is =IF(D2>=60,”Great”,IF(D2>40,”Average”,”Bad”))
200
Song that opens with: "Treated me kind, sweet destiny. Carried me through desperation..."
What is Vision by Mariah Carey
200
How many times a day must you take medication if your prescription reads "q.i.d."?
What is four
300
The difference between a bar chart and a column chart
What is different orientation
300
What is the first step in creating a PivotTable
What is select the data that needs to be analyzed
300
=IF(B9>=18,"Adult",IF(B9>12,"Teen","Child")) is in an Excel sheet. B12 has a value of 14. The value that will enter into the cell
What is "Teen"
300
Song that opens with: "I can't light no more of your darkness. All my pictures seem to fade to black and white?"
What is George Michael and Elton John duet of "Don't Let The Sun Go Down On Me"
300
What does the "myo" mean in myocardial?
What is muscle
400
Chart of age and LOS
What is a scatter chart
400
_____ fields correspond to summary values of original data across categories
What is 'data'
400
Put this picture into an If statement
What is
=IF(C3>=65,"Pass","Fail")
400
Song about the city Dr. Hearld went to school in and includes the lyric "Doin' a little east coast swing"
MotownPhilly by Boyz II Men
400
What organ is inflamed when one has encephalitis?
What is the brain
500
Pareto Chart
What is a combination chart
500
The summary function that calculates the number of data values in a PivotTable
What is "Count"
500
Put this picture into an IF statement
=IF(C3="","Incomplete",IF(C3>=65,"Pass","Fail"))
500
Song that opens with "As I walk through the valley of the shadow of death, I take a look at my life and realize there's nothing left"
What is Gangsta's Paradise by Coolio featuring L.V.
500
What, along with heart disease and cancer, accounts for 64 percent of U.S. deaths?
What is stroke