Microsoft Excel Tour
An Excel file is called a:
Workbook
The most common way to select multiple cells:
Click & Drag method
How do you change the font style - Bold, Italic, Underlined
Home Tab Font group
How do you write a formula to add the values in cells A1 and B1?
=A1+B1
How do you copy a formula/function to other cells?
Click on the handle and drag
Excel spreadsheet is also known as:
Worksheet
What is a cell in excel?
Row/Column A1
When entering a formula in a cell, which symbol must you start with?
=/Equal Sign
How do you change the type of data contained in a cell? (Text, Date, Numeric, Etc)
Home Tab, Number section (dropdown)
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
How do you create boxes around a cell or a range
Home tab, Borders, drop-down
A group of cells that run from top to bottom:
Columns
How do you change a column width?
Right-click on the column and select column width. Type in the number you would like to make
What does the Auto Sum function do/what are the other options on the drop down?
Auto calculates the numbers directly above the function.
Min
Max
AVG
What is a data label and what is it used for?
Found in Charts tools, data labels are elements included in a chart to signify the numeric amount attached to a column/bar
How do you change the font type?
home tab, Font drop down
This shows the address of the cell you have selected:
Name Box
How do you highlight the entire worksheet?
left mouse click on the green triangle on the top of the row/column
How do you create a chart in excel? Name 3 types.
Insert, Charts,
Drop down to choose types
2D
3D
Bar
Scatter
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)