Microsoft Office Tutorials and References
In Depth Information
Make It Right
3. With range D4:D18 selected, apply a
conditional format to the range that uses an
orange background to highlight cells that
contain Exemplary or Exceeds Requirements.
4. With range B4:B18 selected, apply a
conditional format to the range that uses a
red background color to highlight cells with
duplicate student names.
5. Change the document properties as specii ed
by your instructor. Save the workbook using
the i le name, Extend 2-1 State Wildlife
Department Employee Ratings Complete.
Submit the revised workbook as specii ed by
your instructor.
Figure 2 – 75
Make It Right
Analyze a workbook and correct all errors and/or improve the design.
Correcting Formatting, Functions, and Formulas in a Worksheet
Instructions: Start Excel. Open the workbook Make It Right 2-1 Dion Designwear Proi t Analysis. See
the inside back cover of this topic for instructions for downloading the Data Files for Students, or see
your instructor for information on accessing the i les required for this topic.
In this exercise you will learn how to correct formatting, functions, and formula problems in a
worksheet (Figure 2 – 76).
Figure 2 – 76
Continued >
Search JabSto ::




Custom Search