Microsoft Excel Tour
An Excel file is called a:
Workbook
The most common way to select multiple cells:
Click & Drag method
What is the default cell alignment for text entered into a cell in Excel?
Left-aligned
How do you write a formula to add the values in cells A1 and B1?
=A1+B1
A predefined formula that performs a calculation based on values that are entered:
Function
Excel spreadsheet is also known as:
Worksheet
T/F: You do NOT have to use the Ctrl Key when selecting multiple cells that are spread out across the spreadsheet.
False
When entering a formula in a cell, which symbol must you start with?
=/Equal Sign
How can you use parentheses in a formula to ensure that addition is performed before multiplication?
=(A1 + B1) * C1
Adds all the values in a range of cells
SUM
Where rows and columns intersect (ex. E7)
Cell Address
This is known as the command center of the Excel Interface that houses the tabs, groups and commands
Ribbon
This determines which parts of a complex formula to calculate first:
Order of Operations
What formula would you use to calculate the total cost if you have 5 items each priced at $20?
=5 * 20
Calculates the mean of the values in a range of cells:
AVERAGE
A group of cells that run from top to bottom:
Columns
A formula that contains only one type of operator:
Simple Formula
This contains the information you want to use in the function's calculation:
Arguments
How would you write a formula to calculate the difference between the total of cells A1 and A2 and the total of cells B1 and B2?
=(A1 + A2) - (B1 + B2)
Provides the number of cells with numerical values in a range of cells
COUNT
This shows the address of the cell you have selected:
Name Box
A formula that contains more than one type of operator:
Complex Formula
A way to point to a cell location on the spreadsheet.
Cell reference
How do you use a formula to find the total of cells A1 through A5?
=A1 + A2 + A3 + A4 + A5
If you wanted to sum up the values in cells A1 through A10, what formula would you use?
=SUM(A1:A10)