University of Bahrain - Yaqoob Al-Slais



ITIS001 - Assignment 3 Template (10 marks)Group No.Student IDStudent NameSection No.Assignment Instructions:The assignment’s tasks must be handled cooperatively by a group of 2 students within 50 minutes as a maximumAssignment Questions: Download “Assignment3DataFile” from the website and save it on the desktop as “GroupNo-IDs”Follow the tasks shown belowUpload your file “GroupNo-IDs” to your section’s submission link on MarkWorkbook basics1Rename Sheet 1 as “UOB Stationary”12Delete Sheet 213Change the Width of Columns A and B to 2014Change the Height of Row 6 to 4015Apply AutoFill to the cell range A7:A11 16Apply BHD with 3 decimal places to Column C, D, and E1Working with formulas7Change the cell C4 to Percentage number format18Calculate the Wholesale Price where:Wholesale Price = Retail Price * Wholesale Rate19Use Absolute Cell Referencing to get a consistent result110Apply the same formula for the remaining items using AutoFill111Calculate the Price Difference where:Price Difference = Retail Price - Wholesale Price112Apply the same formula for the remaining items using AutoFill1working with functions13Using SUM function, calculate the Total Price Difference in cell E13114Using AVERAGE function, calculate the Average Price Difference in cell E14115Using MAX function, calculate the Highest Wholesale Price in cell D15116Using MIN function, calculate the Lowest Wholesale Price in cell D16117Using COUNT function, calculate the Number of Items in cell C171formatting cells and ranges 18Merge and Center the cell range A1:E1 119Change the cell style of the title to Heading 2120Apply Wrap Text to the column labels in Row 6121Center the column labels in Row 6 Horizontally and Vertically 122Change the cell range B4:C4 Style to “Light Orange, 40% Accent 2” 123Apply “Green Data Bar” Conditional Formatting on Price Difference numbers1formatting worksheets24Delete Column F125Insert a new row above Row 13126Hide Row 2127Apply “Crop” for the Worksheet Theme128Change the Worksheet View to Page Layout 129Insert a Header with your Name on the Left, ID on the right 130Insert a Footer with the Current Date in the Center1TOTal30Total10 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download