Spreadsheet Assignment Mastering Excel Refer to the job cost sheet in Exhibit 12.3.

Required Construct a spreadsheet that recreates the job cost sheet in Exhibit 12.3. Use formulas wherever possible, such as in the total row.

(1) Center the headings for direct materials, direct labor, and applied overhead across two or three columns by choosing Format and Cells and checking the Merge box under the alignment tab.
A shortcut to center these is to click on the Merge and Center icon in the formatting tool bar.
(2) All lines in the job cost sheet can be drawn using Format and Cells and then choosing the border tab.