1 . ============================================== BIS 155 iLab 2 : First National Bank ( New )
Clean-up the formatting of your report , taking into account professional appearance . The minimum requirement ( per the Grading Rubric ): Apply a color to each tab ( sheet ) in the workbook Assign a descriptive name to each tab ( sheet ) in the workbook Printing Setup ( for each sheet ) o Create a Custom Page Header o Set the page orientation to landscape Note : Refer to the Formatting Cleanup video in the lesson tutorials for help with this step . Remember , professional appearance doesn ' t only promote better readability of your report , but represents you as a professional . STEP 6 : Create Charts to Represent the Data Because a picture is worth a thousand words , create each of the charts below to further enhance your report . Each chart should be on a separate sheet in the workbook .
• Pie chart
• Bar chart
• Line chart Note : Refer to the Creating Bar Charts , Pie Charts , and Line Charts videos in the lesson tutorials for help with this step . Once you have completed the tutorials , you can apply your skills to this step of the assignment . Be sure to properly label the charts - do not leave default titles such as " Axis " or " Series ". STEP 7 : Save and Submit Save your Excel file . Your Excel file should contain five worksheets .
• Documentation
• Sales-Data
• Profit by Product
• Percent Sales Graph
• Profits-by-Day
1 . ============================================== BIS 155 iLab 2 : First National Bank ( New )