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 keyboard shortcut to "undo."
What is Control-Z?
This can be generated to visually display your data in colorful ways.
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 tab is not always visible; common examples of this tab are "Pivot Table Tools," "Chart Layout/Design," and "Shape Format."
What is a Contextual Tab?
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 is a good place to start when entering charts, because it allows you to see previews of what your actual data would look like in chart form.
What is Recommended Charts?
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"?
This feature (found on at least two different tabs) allows you to change the order of your data, and organize it based on criteria found in a single column or multiple columns.
What is "Sort"?
This option allows you to summarize information in a large dataset or table.
What is "Pivot Table"?
This function allows you to see what your finished worksheet printout will look like.
What is "Print Preview" or "Print Layout"?
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 tool is similar to Autofill, but rather than copying a formula or continuing a series of data, this feature will recognize and replicate a pattern if you create the first example.
What is Flash Fill?
To see a drop-down menu of frequently used tools that can be applied to any cell in a worksheet, just hover over any cell with your mouse pointer and hit this button:
What is the right mouse button?
This tool is particularly helpful when using Pivot Tables, and allows you to create a quick filter pop-up to use in analyzing your data.
What is a Slicer?
This option allows you to personalize the Ribbon for your own needs. To find it, first click on "Options" in the Backstage View.
What is Customize Ribbon?
This is used to separate the arguments in a formula, or to define the relationship between cells in a cell reference (i.e., adjacent or nonadjacent). It is also used to define the column boundaries when using Text-to-Columns.
What is a Delimiter?