Question: Title: Making a BUSINESS TABLE. CLO2: Use office application software to produce relevant documents. Objective: - This is to test the ability of students on

 Title: Making a BUSINESS TABLE. CLO2: Use office application software to

Title: Making a BUSINESS TABLE. CLO2: Use office application software to produce relevant documents. Objective: - This is to test the ability of students on identifying commands under the following menu tabs in Microsoft Excel: - home, insert, formulas, and the formula bar. Tasks: - Refer to the worksheet provided, and explain the solution for the following. Your steps must include the cell addresses: a) Fill up the column header of the table from D4-G4 by not typing the months manually. b) In C9, type the formula for Jan total using +. In C9, type c) Fill up D9-H9 with the same formula. d) In I5, type the formula for the total of Plants using a formula name. e) Fill up I6 to I9 with the same formula. f) Explain what will you do add the average sales of products for every month in column J. g) Add borders to the table. Make the outer table border ticker and inner border thin. 1. Select B4:I9. 1. Select Borders, All Borders. 2. Select Borders, Thick Outside Borders. h) Change the color of the table column and row header as light orange. Bold the text. i) Highlight all sales that are below $400 with red color. j) Add vertical bar graph of the table below the chart. k) Copy both the table and the graph to the Word report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!