Excel Basics
Normal view, Page Layout view, or Page Break view.
What are Worksheet Views?
These are are the basic building blocks of a worksheet.
What are Cells?
Every formula starts with this.
What is an equals (=) sign?
To stop your header row from scrolling with the rest of your data, you do this.
What is Freeze Panes?
This is the intersection of a row and a column.
What is a Cell?
This appears when you click the FILE menu
What is the Backstage (view)?
This symbol separates a cell range.
What is a colon (:)?
**D4 is an example of this.**
What is a Relative Cell Reference?
When you want to organize your data in a specific way, you use this tool.
What is Sort or Sorting?
This feature starts with a desired result, then calculates the input value that will give that result?.
What is Goal Seek?
Do this if you frequently use the same workbook
What is Pin It?
These tell your spreadsheet exactly what type of data you're using, like percentages (%), currency ($), times, and dates.
What are Number Formats?
$D$3 is an example of this.
What is an absolute reference?
This tool is used to narrow down your data.
What is Filter?
This formula will calculate cells A1 through A5.
What is =SUM(A1:A5)
A predesigned spreadsheet you can use to create a new workbook quickly.
What is a Template?
When you want to edit multiple worksheets at the same time, you do this.
This function ets you search for specific information in your spreadsheet and return a value.
What is VLOOKUP?
You use this command to remove table formatting.
What is Convert to Range?
This chart type is best for viewing values across categories.
What is a Column Chart?
You do this to save a different version of a workbook while keeping the original.
What is Save As?
You double click between columns to do this.
What is AutoFit the column width?
The correct formatting of this formula:
=VLOOKUP(TAG, A2:A20, 2, FALSE)
What is
=VLOOKUP("TAG",A2:A20,2,FALSE)
Will also accept Missing Quotation marks around TAG/First Argument
This allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.
What is Conditional Formatting?
This is indicated by a red box in the lower right corner of a cell.
What is a note?