Formulas
What formula would you use to figure out the number of something?
=COUNT
How do you add a chart?
Insert Tab, or highlight data and then insert tab
What tab can you change the page orientation on?
Page Layout
How do you add a property to your Excel sheet?
File --> Info --> Show All Properties
Who is the best Excel TA?
Emily
What formula would you use if you wanted to add up a section based on a critieria?
SUMIF
How do you know you are working in a table?
Dropdown boxes at the top & the table design tab!
Conditional Formatting!
Where is the "name box"?
Top left corner of your Excel spreadsheet
How many people currently live on Earth?
8 billion!!!
What do you need in every formula?
An = and ()
How do you add data to a chart?
Use Select Data
How do you copy the formatting of one cell and paste in on another cell?
The format painter!
How do you set the print area of your document?
Highlight what you want to set, go to page layout tab, Print Area, set Print Area
What was the first national park?
Yellowstone
What formula would you use to index something based on the leftmost column?
=VLOOKUP
Where would you add Data Labels?
Green plus sign, or on the Chart Design tab
How do you change the width of a column?
Home --> Format --> Column Width
How do you select all of the numbers in a column?
Ctrl + Shift + Down
How much is Tom Brady's new contract?
$375 million
What formula would you use to create the word EMILY - WINN - 21 from three different cells?
=CONCAT(EMILY, " - ", WINN, " - ", "21")
What do you have to do to remove data from a chart in the mini Excel window?
Drag the button in the bottom right corner!
How do you change the "type of number" in a cell?
The number dialogue box!!
How do you import Data into your spreadsheet?
Data Tab --> Get Data
When was Excel created?
1985