Skip to main content
KBIS
  • Home
  • All categories
  • Favorite courses
    Razkids Cambridge Practice Cambridge Exam Chinese Language Tin học AI English AI Chinese Assignment
  • More
You are currently using guest access
Log in
KBIS
Home All categories Favorite courses Collapse Expand
Razkids Cambridge Practice Cambridge Exam Chinese Language Tin học AI English AI Chinese Assignment
Expand all Collapse all

Blocks

  1. ICT11 Excel
  2. Nâng cao_Mos Excel
  3. Project 7

Project 7

Completion requirements
View
Make a submission
Receive a grade
Receive a passing grade
Opened: Friday, 25 November 2022, 12:00 AM

1.       On the “Database” worksheet, remove table functionable of the table. Retain value, format and data location.

2.       On the “BeSam” worksheet, insert a column sparkline in cell F3 to represent the quantity of Complaint Type from Quarter 1 to 4. Fill this sparkline to the entire “Histogram” column without changing formatting of other cells.

3.       Add the logo.png file in the CA.EDocument folder to the right of the “Monthly Budget” title on the “Database” worksheet. Apply Pencil Grayscale aristic effect and Fill Pattern type Horizontal Brick with Dark Blue Foreground color to this picture.

4.       On the “BeSam” worksheet, create Pareto Chart that shows the number by complaint types in Quarter 3. Change the Chart Title to “Complaint Status”. Place this chart to the right of data.

5.       Move the “INCOME OVERVIEW” chart on the “Summary” worksheet to its own chart sheet named “Overview”.

6.       Modify hyperlink of the image of a baby on the “BeSam” worksheet to link to cell A1 of “BeSam” worksheet.

7.       On the “Summary” worksheet, remove only legend of the “BUDGET OVERVIEW” chart. Accept all other default settings.


  • logo.png logo.png
    25 November 2022, 2:23 PM
  • Project 7.xlsx Project 7.xlsx
    25 November 2022, 2:23 PM
Contact site support
You are currently using guest access (Log in)
Data retention summary
Powered by Moodle