AutoSum-Where
Over the Rainbow
Over the Rainbow
This function looks similar to a backwards "3", is on the far right side of the ribbon, and can be a shortcut to using "Sum" function
What is AutoSum?
It's an emergency! You just deleted three whole rows of information that you realized you still need. If you don't want to get fired, just use this shortcut to "undo."
What is Control-Z?
This can be generated to create a visual representation of your data, and can be formatted to highlight trends or comparisons.
What is a "Chart"?
The section within the Excel program that contains all functions, formatting, and workbook management tools. This section runs along the top of the application and is called...
What is the Ribbon?
This symbol is used to begin any formula. Entering this symbol in a cell indicates that you want Excel to calculate something.
What is the "=" sign?
This function allows you to automatically repeat relative formulas, or consecutive patterns of information (i.e. "1,2,3" or "Sun, Mon, Tues")
What is Autofill?
Use this option to temporarily remove a row or column from view, without deleting it permanently.
What is "Hide"?
This kind of chart fits in a single cell.
This refers to the section containing all document options, including file permissions, open/save, and printing.
What is Backstage View?
This formula is used to join the text strings in multiple columns.
What is Concat (or Concatenate)?
This symbol is used before the row and column labels in a formula to make the cell reference absolute instead of relative.
What is a dollar sign?
This allows you to divide the information in a cell into multiple cells, as long as you define a delimiter.
What is "Text-to-Columns"?
This type of sparkline uses bars instead of lines.
What is a "column" or "bar" sparkline?
You want to share a document with your coworkers, but you don't want them to change any data you have entered. This option in the Backstage View will allow you to prevent these changes.
What is "Protect Workbook"?
This formula will return the largest number in a range.
What is "MAX"?
Use this option to format all of the information in a cell range according to certain criteria, i.e. all dates before a certain date, or dollar amounts below $0.
What is "Conditional Formatting"?
You have a worksheet with 450 rows of data. You want to scroll down your sheet without losing sight of the column headings. What can you use?
What is "Freeze Panes"?
This option allows you to summarize information in a large dataset or table.
What is "Pivot Table"?
This allows you to see what your finished worksheet printout will look like.
What is "Print Preview"?
This formula is used to calculate payments and other cost information related to loans. You could use this formula to determine whether you can afford that new car...
What is the "PMT" function?
This allows you to change the size of the row or column to fit the data inside. A quick way to do this is to double-click the right side of the column label, or the bottom edge of the row label.
What is "AutoFit"?
Use this to quickly filter information in a table. For example, on a list of employees and their job titles, you want to filter out all except two particular job titles.
What is a slicer?
What is "Recommended Charts"?
This tool on the "Insert Tab" will allow you to view how your data will appear in several chart formats.
You know you autosaved your worksheet every day for the last 2 weeks. You've made an error in your calculations, and you can't undo any farther to find your mistake. This will help you go back to what you saved yesterday.
What is "Version History"in Backstage View?
This formula allows you to find information in a specified COLUMN using a unique value in the first column of your data.
What is "VLOOKUP"?