Excel Parts
Shortcuts
Formulas
Miscellaneous I
Miscellaneous II
100
In what direction do columns run?
Veritcally/Up and Down
100
What is the shortcut for bold?
Ctrl + B
100
Write a range for cells A1 to D5 on the board.
(A1:D5)
100
What do you always start a formaula with?
=
100
What is the Excel file extension for Office 2010?
.xlsx
200
In what directions to rows run?
Horizontally/Side to Side
200
What is the shortcut for redo?
Ctrl + Y
200
Write out a manual addition formula to add cells C2 and C3 on the board.
=C2+C3
200
How do you format a range of cells as currency? Explain the steps.
-Highlight the range of cells. -Right click -Format Cells -Under Category: choose currency -$ and 2 decimals
200
What is the difference between a workbook and a worksheet?
A workbook is the entire file, which contains a series of worksheets (similar to the pages in a book)
300
What is a cell?
The intersection of a column and row. (each individual square in a worksheet)
300
What is the shortcut for undo?
Ctrl + Z
300
What key do you press to absolute reference a specific cell?
F4
300
Explain how to format the title above multiple column headings.
Select the range of cells above the column headings and click Merge & Center on the Home Ribbon.
300
What is the difference between relative and absolute cell referencing?
With relative cell referencing, you copy a formula and it will change the “referenced cell” for each row and column appropriately. With absolute cell referencing, when selecting a “referenced cell” if you press the F4 key Excel will prevent it from changing when using the fill handle.
400
What is the entire file called?
Workbook
400
What is the shortcute that brings you to the end of the spreadsheet?
Shift + Ctrl + down arrow
400
Write out the function to multiply cells A1 and A2 on the board.
=PRODUCT(A1,A2) OR =PRODUCT(A1:A2)
400
Explain the steps for inserting a pie chart.
-Highlight the fields to be put in the chart -Insert Tab -Pie Chart -Choose type of pie chart
400
What does the fill handle do?
Fills data automatically in worksheet cells; used to copy patterns or formulas.
500
What is each page (tab) in an entire Excel file called?
Worksheet
500
What is the shortcut to bring you to the end of the area you used?
Ctrl + End
500
Write out a multiplication formula that multiplies A1 and B1 and absolute cell references A1 on the board.
=$A$1*B1
500
Describe 3 ways to add cells together.
1. manual formula - =A1+A2+A3 2. insert function - =SUM(A1:A3) 3. Alt =
500
List 3 things Excel is designed to do.
• Organize data • Complete calculations • Graph data • Create reports • Be used for analysis
M
e
n
u