Cells
What would the cell in Column A Row 2 be called?
A2
What is the button on Excel that quickly adds together a range of values?
Autosum
Name one type of column chart we've covered in class
Clustered/Stacked/Basic
What is one thing you can do using Conditional Formatting?
Is it possible to reference a cell from one worksheet on another worksheet?
Yes
What does flash fill do?
Fills in a column with data using a pattern matching on Excel from another column
What does the MIN function do?
Finds the least value in a range of cells
What do slicers do?
Filter data in Pivot Tables/Pivot Charts
What does autofit do?
Automatically adjusts the width of a column
What do markers on sparklines tell you?
Individual data points in a trend
How many cell styles are there?
Many
What are Sparklines?
Small trend lines or data bars you can add into individual cells
How do you make a slice of a pie chart stick out for emphasis?
Click on the chart and in the options, put in a percentage where it says Explode by
How do you group a bunch of worksheets together?
Click on a worksheet and then "Select All Worksheets"
What does the Show Details button on Pivot Tables do?
Shows you how the Pivot table got a given value by giving you a table with the information it collected to get to the value it gave you
Checks to see if you have misspelled any words
What would be the result of COUNTIF if my values are 100, 200, 300, and my criteria is >100
2
If I change data in a pivot table, will my pivot chart reflect that change?
Yes
How do you center a worksheet in a certain direction for printing?
Page Setup, Center Horizontally or Vertically
How do you rename a worksheet?
Right click and rename worksheet
What does the Replace all function in Find and Select do?
Replace all words you tell it to find that match a criteria
What does Goal Seek do?
Change the value of one cell to get a certain desired value in another cell
How do you move a worksheet onto another page?
Click Move Chart after clicking on the chart
How do you insert a file's name into a worksheet for printing?
Custom Header/Footer in Page Setup and click Insert File Name
What does Show Report Filter Pages do?
Creates separate worksheets for each filter you've applied to your pivot table