Excel Navigation 101
A entire file in Excel is also known as ...
What is a workbook?
Excel has many functions to help with data calculations. Commonly used functions from these three categories were covered this week.
What is
- Math Functions
- Logical Functions
- Statistical Functions
???
This formula allows you to add a group of numbers vertically or horizontally
What is SUM or AUTOSUM?
Selecting CTRL and this letter at the same time will allow you to Open a workbook.
What is the letter "O"?
This command allows you combine multiple cells into one cell
What is Merge and Center?
You can add or create several of these to create a workbook. You can also place these on your bed.
What is a sheet?
This is the grey area that includes a list of Excel tabs, groups, and commands. You can also tie this on a present
What is the Ribbon?
This formula allows you to highlight information if it meets a certain condition.
What is IF?
Selecting ATL and this letter at the same time will let you go to the Home Tab.
What is the letter "H"?
This command allows you to make fonts darker to highlight a font
What is BOLD?
This is where a column and a row intersect. You can enter data in this area. It is also the smallest unit of life a.k.a building blocks of life.
What is a cell?
This is where related commands are housed together.
What is a group?
This formula allows you to compute the average of a group of numbers
What is AVERAGE?
Selecting CTRL and this letter at the same time will allow you to undo something you've done
What is the letter "Z"?
This command allows you to add columns, rows, and more
What is Insert?
This is what a group of cells is called. You can also cook on this.
What is a range?
Performs various math functions on large data sets.You can search, sort, filter; makes it easier to clean. Beautify data and present with charts & tables. Reporting, accounting & analysis is easier. Provides security through locking cells, and passwords
What is Excel?
This formula allows you to multiply numbers.
What is PRODUCT?
Selecting CTRL and this letter at the same time will allow you to convert information from data into a table
What is the letter "T"?
This command allows you to put information/data in order
What is sort?
It is the vertical identification of information/data. It is labeled using letters. Newspapers also write these.
What is a column?
These are the horizontal areas that are represented by numbers
What is a row?
This formula allows you to quickly search for an item to return related information/data.
What is VLOOKUP?
Selecting CTRL and this letter at the same time will allow you to save your information.
What is the letter "S"?
This command allows you to remove information from sight (NOT DELETE IT) and only see the information you want
What is FILTER?