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)