Excel Shortcuts
Excel Formulas
Variable Type and Scale
All about Charts
Finish the lyric
100

To search for anything in a workbook

What is Ctrl+F

100

Mean

What is =AVERAGE

100

Charges

What is numerical continuous / ratio

100

Chart depicting parts of a whole

What is a pie chart

100

And I can put you in ________, _________

What is "first class, up in the sky"

200

Shortcut to copy and paste a formula used in a cell to all cells below it (Dr. H's FAVORITE shortcut)

What is double-left-click on lower left corner

200

Calculates the sum of a group of values

What is =SUM

200

Number of beds in hospital

What is numerical discrete

200

Chart of trends over time

What is a line chart

200

She had apple bottom jeans. Boots with ________

What is "the fur"

300

Highlight all cells with data in a column

What is Ctrl+Shift+Down

300

Counts the number of cells in a range that match a criteria

What is =COUNTIF

300

ICD-10 Codes

What is categorical nominal

300

The difference between a bar chart and a column chart

What is orientation

300

And you call me up again just to break me like a promise, __________________

What is "So casually cruel in the name of being honest"

400

Highlight all cells with data in a row

What is Ctrl+Shift+Right arrow

400

Merges two or more text strings

What is =CONCATENATE

400

Age group

What is categorical ordinal

400

Chart of age and LOS

What is a scatterplot

400

In a minute I'ma need a sentimental __________

What is "Man or woman to pump me up"

500

To apply percentage formatting

What is Ctrl + Shift + % 

500

Converts a text cell to a number

What is =VALUE

500

Patient ID

What is categorical nominal

500

Pareto Chart

What is a combination chart

500

You don't have to be rich to be my girl
You don't have to be cool ____________

What is "to rule my world"

M
e
n
u