Module 1 Getting Started with Excel - Skills Review

1. Explore Excel.
a. Start Excel.
b. Open IL_EX_1-2.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Travel.
c. Locate the Name box, formula bar, worksheet window, cell pointer, sheet tab scrolling buttons, mode indicator, and Tell me box.
2. Enter data.
a. Click cell B3, type Jan, then confirm the entry.
b. Click cell D7, type 202497, then conform the entry.
c. Activate cell B3, then use Auto Fill to enter the months Feb and Mar in the range C3:D3.
d. Save your changes to the file.
3. Edit data.
a. Use F2 to correct the spelling of Maimi in cell A6 (the correct spelling is Miami).
b. Click cell C7, then use the formula bar to change the value to 188270.
c. Click cell A17, then enter your name.
d. Save your changes.
4. Copy and move cell data.
a. Select the range G4:G6.
b. Copy the selection to the Clipboard.
c. Open the Clipboard task pane, then paste the selection to cell A10.
d. Delete the labels in the range G4:G6.
e. Close the Clipboard task pane, then activate cell A8.
f. Use the drag-and-drop method to copy the contents of cell A8 to cell E3. (Hint: Press and hold CTRL while dragging.)
g. Save your work.
5. Enter formulas and use AutoSum.
a. Activate cell E4, then enter a formula that adds cells B4, C4, and D4.
b. Use AutoSum to enter the total expenses for the month of January in cell B8.
c. Save your changes.
6. Copy formulas with relative cell references.
a. Activate cell E4, then use the fill handle to copy the formula in cell E4 to the range E5:E7.
b. Activate cell B8, then use the fill handle to copy the formula in cell B8 to the range C8:E8.
c. Save your work.
7. Copy formulas with absolute cell references.
a. Enter % of Total in cell F3.
b. In cell F4, create a formula that divides the value in cell E4 by the value in cell E8 using an absolute reference to cell E8.
c. Use the fill handle to copy the formula in cell F4 to the range F5:F7.
d. Save your work.
8. Enter a formula with multiple operators.
a. Enter a formula in cell B10 that calculates the average travel expenses for the month of January. Use a formula that contains cell references and not a function. (Hint: The formula is =(B4+B5+B6+B7)/4.)
b. Review the use of the parentheses in the formula.
c. Save your work.
9. Insert a function.
a. Use the Insert Function button to create a formula in cell B11 that calculates the maximum travel expense for January.
b. In cell B12, enter a function to calculate the minimum travel expenses for January.
c. Select the range B10:B12, then use the fill handle to copy the functions into the range C10:D12.
d. Save your work.
10. Switch worksheet views.
a. Click the View tab on the ribbon, then switch to Page Layout view.
b. Verify that the Ruler and Gridlines check boxes contain checkmarks.
c. Switch to Page Break view and adjust the page break so it comes at the bottom of row 20.
d. Switch to Normal View, use a button in the Zoom group of the View tab to zoom the worksheet to 100%, then use the Zoom buttons in the Status bar to zoom the worksheet back to 120%.
e. Save your changes.
11. Choose print options.
a. Use the Page Layout tab to change the orientation to Portrait.
b. Turn on gridlines for printing using a check box in the Sheet Options group of the Page Layout tab.
c. Preview the worksheet in Backstage view, then use the Page Setup dialog box to center the worksheet vertically and horizontally on the page. (Hint: The commands are located on the Margins tab.) Compare your screen to FIGURE 1-24.
d. Save your changes, submit your work to your instructor as directed, close the workbook, then exit Excel

Comments

Post a Comment

Popular posts from this blog

Module 1 Getting Started with Excel - Independent Challenge 1

download The CFO at Riverwalk Medical Clinic has hired you to help him analyze departmental insurance reimbursements. He also would like to see what quarterly revenues would look like with a 20% increase in quarterly reimbursements. You’ve been given a worksheet for this project that contains some but not all of the data. a. Open IL_EX_1-3.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Reimbursements. b. Enter the data shown in TABLE 1-4 in the range E4:E11. c. Type your name in cell A17. d. Move the label in cell F2 to cell A15. e. Use the Clipboard to copy and paste the label in cell F3 to cell A12. f. Use the formula bar to correct the spelling error in the label in cell A6. (Hint: The correct spelling is Immunology.) g. Edit cell A8 to correct the spelling error in the label. (Hint: The correct spelling is Ophthalmology.) h. Type Quarter 1 in cell B3, then use Auto Fill to enter Quarter 2, Quarter 3, and Quarter 4 in the range C3...
Read more

Module 1 Creating Documents with Word - Visual Workshop

download Create the letter shown in FIGURE 1-34. Before beginning to type, click the No Spacing button in the Styles group on the Home tab. Type the letter before formatting the letterhead and applying the theme. To format the letterhead, change the font size of the first line of text to 40 point and apply the Gradient Fill: Blue, Accent 5, Reflection WordArt style. Change the font color of the address line to Blue, Accent 5. Add the bottom border to the letterhead. When the letterhead is formatted, change the font size of the body text to 12 point, apply the Organic theme, then change the font color of the letterhead text to Green, Accent 1. Save the document as IL_WD_1-SakuraDoksa to the location where you store your Data Files, submit the letter to your instructor, then close the document and exit Word.
Read more

Module 1 Creating Documents with Word - Independent Challenge 1

download You work at the Riverwalk Medical Clinic, a large outpatient medical facility staffed by family physicians, specialists, nurses, and other allied health professionals. Your boss has drafted an information sheet to help seasonal allergy sufferers and asks you to edit and format it so that it is eye catching and attractive.  a. Open the file IL_WD_1-5.docx from the drive and folder where you store your Data Files, save it as IL_WD_1_AllergyInfo, then read the document to get a feel for the content. FIGURE 1-32 shows how you will format the info sheet. FIGURE 1-32 Riverwalk Medical Clinic Advice for Seasonal Allergy Sufferers b. Show the rulers in your document window if they are not already visible. c. Accept or ignore all suggested spelling and grammar changes in the document. d. Insert the Riverwalk Medical Clinic logo file Support_IL_WD_1-6.jpg at the top of the document. Change the height of the logo to 1", then position the logo in the bottom right with...
Read more