Step 33 of 40: Page Layout Settings
This step illustrates how to use Page Layout Settings to set page attributes.
Written description of the slides
In Step 33, begin by selecting cells A1:M26 on the Financial Statements worksheet and choose Home | Page Layout | Set Print Area. Then, choose Home | Page Layout | Set Print Area to change the orientation of the page. Then, choose Home | View | Page Break Preview and drag the dotted line between columns F and G to the left so that the Income Statement is on its own page. Next, drag the page break to the left so that each report is on a separate page. Finally, choose Home | View | Normal to return to the normal view.
FYI: Page breaks appear as light gray dotted ines in Normal View.
Steps labeled YOUR TURN are reinforcing steps that present opportunities to apply concepts covered earlier in the assignment.
We're here to help
If you're stuck or confused, send a copy of your workbook by way of one of these methods:
• Share: Click the Share command in the upper-right hand corner of the Excel screen, choose Share again, and then share the workbook with support@studentsexcel.com.
• Upload: You can upload a copy of your workbook at www.studentsexcel.com/student-upload.
• Email: You can email your workbook as an attachment to support@studentsexcel.com.
Be sure to listen to the audio portion of the video as you work through the assignment. The presenter elaborates further on what is being presented on screen and will offer tips.
This step illustrates how to make an Adjustment to an existing worksheet by modifying the reference cell on a different worksheet.
Written description of the slides
In Step 33, you’re going to reference cell B4 on the Assumptions worksheet instead of referencing a cell on the same worksheet. The adjustment steps are designed to reinforce concepts covered previously in the assignment.
Record an adjustment to the General Journal by rounding cell B1 on the Assumptions worksheet up to the nearest 1,000.
FYI: Page breaks appear as light gray dotted ines in Normal View.
NOTE: The debit and credit amounts should be derived by formulas that utilize cell references. You will only receive partial credit if you type amounts into the cells or formula instead of referencing the corresponding worksheet cells.
Steps labeled YOUR TURN are reinforcing steps that present opportunities to apply concepts covered earlier in the assignment.
We're here to help
If you're stuck or confused, send a copy of your workbook by way of one of these methods:
• Share: Click the Share command in the upper-right hand corner of the Excel screen, choose Share again, and then share the workbook with support@studentsexcel.com.
• Upload: You can upload a copy of your workbook at www.studentsexcel.com/student-upload.
• Email: You can email your workbook as an attachment to support@studentsexcel.com.
Be sure to listen to the audio portion of the video as you work through the assignment. The presenter elaborates further on what is being presented on screen and will offer tips.