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?
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 tab contains the "Charts" group.
What is "insert"?
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 refers to the section containing all document options, including file permissions, open/save, and printing.
What is Backstage View?
This part of a formula dictates what is happening with the cells/ranges referred to in the argument section of the formula. This could be an operator, or could return information based on conditions.
What is the "function"?
Before you can insert a chart in your worksheet, you must first do this:
What is "select a range" (or "select data")?
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?
After entering demographic information for 783 employees, you realize that you transposed a letter in the job title column while typing, and now several hundred employees are assigned to be "pianters." How can you correct this error quickly?
What is "replace?"
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 is used to join the text strings in multiple columns.
What is Concat (or Concatenate)?
This option in the Charts group allows you to previes your data in several different chart formats, and choose the best one.
What is "Recommended Charts"?
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 allows you to see what your finished worksheet printout will look like.
What is "Print Preview"?
This formula will return the largest number in a range.
What is "MAX"?
The Charts tab is an example of this special type of tab on the Ribbon.
What is "contextual tab"?
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"?
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"?
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 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 is the name for the horizontal and vertical areas that on the border of the chart, which contain information about the chart data points.
What is the "axis"? (X-Axis and/or Y-Axis is acceptable.)