Excel Scavenger Hunt - Weebly
Excel Scavenger Hunt
Directions: Open an Excel Spreadsheet. Follow the instructions. You can include (type or complete action) your answers into the attached excel document. ([pic] Excel Scavenger Hunt.xls) This will spreadsheet will be emailed to Mr Funke (funke.michael.j@edumail..au).
The Scavenger Hunt questions are:
1. In the Toolbar, List 12shortcut symbols and explain its command/function
2. What do you find in the name box on the toolbar?
3. Place the cursor in cell F17; what happens when you hold down “Ctrl” and press the right arrow button?
4. Place the cursor in cell A1, press Alt + PageDown; what happens?
5. press F5, in the cell reference type J400
6. In the name box, type A2:B19; what does it do?
7. At the bottom of the worksheet in the tabs, type ‘Vacation’ in sheet 1; ‘Disney’ in sheet 2; ‘Beaches” in sheet 3
8. Press “shift+spacebar” what does it do?
9. Press “Ctrl+spacebar” what does it do?
10. Press “Ctrl+;” what does it do?
11. “Ctrl+ shift+;” what does it do?
12. Press F2 button; what does it do?
13. Press “shift+F3 button”; what does it do?
14. Go to File, Page Setup, Margins change the margins to Top: .7; Bottoms: .7; left: 1; Right: .5.
15. Go to File PageSet-up, Header, then Custom Header: your name in the left section, center section select page numbers; left section date:
16. Go to File PageSet-up, Header, then Custom Footers, in left section select date in
17. List the two ways to enter a formula in a spreadsheet
18. What is the symbol for a function?
19. Select “Help” in the menu bar; select Microsoft Excel Help; type keyboard combinations. From the following selections below, choose 4 shortcut for each (write the code and what it does) Total of 28 answers
1. Access and use menus and toolbars (choose 4 shortcuts)
2. Select cells, rows, columns, objects (choose 4 shortcuts)
3. Enter Data (choose 4 shortcuts)
4. Enter Special characters (choose 4 shortcuts)
5. Format Data (choose 4 shortcuts)
6. Calculate Formulas (choose 4 shortcuts)
7. Insert, Delete, Copy Cells (choose 4 shortcuts)
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.