What is: Highlight Selection, Home, Format, AutoFit Column Width. Highlight Selection, Home, Format, AutoFit Row Height.
100
This is the formula to get the Average of cells B1, B2, B3, B4, B5.
What is =Average(B1:B5)
100
This shortcut Copies whatever is highlighted.
What is Ctrl C.
100
Graphs can be imported into this Microsoft Office program used for presentations.
What is Microsoft PowerPoint.
100
This shortcut will help you find a specific word or number within the Excel worksheet.
What is Ctrl F.
200
This is how to shrink multiple page worksheets into one for printing.
What is: File, Print, click on "No Scaling," select "Fit Sheet on One Page."
200
This formula will divide Cell B8 and Cell C8.
What is =B8-C8
200
This shortcut underlines the text.
What is Ctrl U.
200
Before graphing, this is how to sort a group of cells by last name.
What is Highlight Data, Click Home, Click Sort & Filter, Select Custom Sort. Sort by: select First Name or Last Name, then in the “Order,” select A to Z.
200
This is how to merge and center two cells together.
What is: Highlight the two cells, Go to Home, and click on the Merge & Center button.
300
This is how to rename a worksheet.
What is: either double click on the worksheet title or right click on the title and select: Rename.
300
This is called the Formula Bar.
What is: A place where you can enter data into Microsoft Excel located below the ribbon.
300
This shortcut is for printing.
What is Ctrl P
300
This is how to add a title to pie chart which did not intially have a title.
What is: Click on "Design" and then select one of the pictures with the pie graphs with a title box on the top.
400
This is how to add a NEW worksheet to an already open Excel workbook.
What is: click the button on the bottom of the page next to "Page 3" which has a yellow burst.
400
This is how to Auto Fill data.
What is: First enter in a formula for the top set of data. Example: =Sum(a1+b1) (then hit the enter button). From there click on the corner right of the cell and drag down to fill in the rest of the cells with that formula.
400
This is for undoing your last action.
What is Ctrl Z
400
This is called the ribbon.
What is: The entire area at the top of the Excel screen which contains all of the option buttons.
400
This is how to delete a column.
What is: Highlight the column you want deleted, click Home, Delete button (on the right hand side of the ribbon with the red star).
500
This is how to copy an entire worksheet.
What is: Right click on the worksheet title on the bottom left of the screen. Left click on "Move or Copy." Select "Before Sheet: Sheet 2. Then Click “Create a Copy.” Finally, hit the Enter button.
500
This is how to multiply Cell B8 on the page titled "Apples" with cell B8 on the page titled "Oranges" with the answer placed on cell B8 of the third sheet titled: "Fruit Amounts."
What is: Go to page the 3rd page titled "Fruit Amounts" and enter the following formula into cell B8:
=Apples!B8*Oranges!B8
500
This shortcut is for saving.
What is Ctrl S.
500
####### appears in a cell when this occurs.
What is: the cell is too small for the data so you must extend the size of the column.
500
This is what the Fill button does.
What is: Highlight data, click the Home tab, then click the Fill button (this is on the top right of the screen and is a blue arrow pointing down), then click Down. This will continue the pattern in one or more adjacent cells.