Finally, let’s add color to the two sheet tabs. While you’re fixing errors, proofread the sheet and correct any typos. Use Increase Decimal and/or Decrease Decimal until one digit appears after the decimal place for all values. Apply the green fill color to A31:E31 (be sure to match the green fill color of the other states). 
Change the font size to 16 and apply Bold format.
To fix these errors, complete the following steps:. 
Also, these values should be formatted with Comma style to make them easier to read.
The number of digits after the decimal place for the Size values is inconsistent. The cells for the Nevada data should have the same green fill color as the other alternating states. The Year Established values for Hawaii are not center aligned like the other years. The formatting of the Utah label does not match the other states. Scroll through the worksheet and locate the following formatting errors:. The first thing you are going to do is review the worksheet for formatting inconsistencies. Figure 3.26 Completed National Parks worksheet Reviewing Formatting for Inconsistencies Figure 3.26 shows how the second page of the finished worksheet will appear in Print Preview. You also need to prepare it for printing. Your coworker formatted the workbook and has asked you to review it for consistency. You have been given a spreadsheet with data about the national parks in the western United States. Open the “CH3-Gradebook and Parks” workbook if it isn’t already open.Ĭlick on the “Park Size” sheet tab within your “CH3-Gradebook and Parks” workbook. A new data file will be used for this section. This worksheet currently prints on four pages, so we will learn new page setup options to control how these pages print. In this section, we will review a worksheet for formatting consistency, as well as learn two new formatting techniques. Control where page breaks occur in a multiple page worksheet. Use Print Titles to repeat rows and columns on each page of a multiple page worksheet. Locate and fix formatting consistency errors.
0 kommentar(er)
