Excel Basics
A single "box" where data is entered.
What is the Ribbon?
A horizontal line of cells.
What is a row?
A formula that adds cells A1 and B1 only.
What is =A1+B1?
All rows are labeled with this.
What is a number?
The tab on the ribbon that contains tools for changing the font size and style.
What is the Home tab?
What is a workbook?
This function ADDS a range of cells.
What is SUM?
A vertical group of cells.
What is a column?
The button that changes the light gray grid lines to lines that will actually print in Excel.
What is the borders button?
A group of selected cells. (Example A1:C20)
What is a range?
The formula for finding the average of range C1:C10
=AVG(C1:C10)
The symbols that all formulas must start with in Excel to tell Excel to do the math.
What is an equals sign?
This button allows you to rearrange the data in a column alphabetically.
What is Sort and Filter?
A calculation that uses numbers and symbols in Excel.
What is a formula?
=F1*G1 ?
The process for making the cell columns just wide enough to fit all of the data.
What is double clicking between the columns?
This style applied to numbers in a column will change the number in the cell to a dollar amount with 2 decimal points with a dollar sign that lines up evenly.
What is Accounting Style?
A button that is a Greek symbol that allows one to do common formulas without typing the entire equation, such as Average and Maximum.
What is AutoSum?
The formula for calculating D4 divided by C4.
=D4/C4 ?