Microsoft Office Tutorials and References
In Depth Information
Extend Your Knowledge
Extend Your Knowledge
Extend the skills you learned in this chapter and experiment with new skills. You may
need to use Help to complete the assignment.
Creating Styles and Formatting a Worksheet
Note: To complete this assignment, you will be required to use the Data Files for Students. Visit for detailed instructions or contact your instructor for
information about accessing the required les.
Instructions: Run Excel. Open the workbook Extend 1–1 Kaseey Vehicles (Figure 1– 74). Perform
the following tasks to create styles and format a worksheet using them.
1. Select cell A4. Use the New Cell Style command in the Cell Styles gallery to create a style that
fills only cell A4 using the Orange, Accent 2, Lighter 40% color (row 4, column 6). Name the
style, MyHeadings.
2. Select cell A5. Use the New Cell style dialog box to create a style that fills only cell A5 using
the Orange, Accent 2, Lighter 80% color. Name the style, MyRows.
Figure 1– 74
3. Select cell ranges B4:G4 and A5:A8. Apply the MyHeadings style to the cell ranges.
4. Select cell ranges B5:G5 and B7:G7. Apply the MyRows style to the cell ranges.
5. Apply a worksheet name to the sheet tab and apply a color of your choice to the sheet tab.
6. Change the font color for the text in cells A1 and A2 to the color of your eyes. Save the
workbook using the le name, Extend 1–1 Kaseey Vehicles First Quarter. Submit the revised
workbook as specied by your instructor.
7. Exit Excel.
What other styles would you create to improve the worksheet’s appearance?
Search JabSto ::

Custom Search