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 1

Project 1

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

1.       Color “Sam” sheet tab to Green, Accent 6.

2.       Unhide “Cong Academy” worksheet so that it will be displayed between “Data” worksheet and “Sam” worksheet.

3.       On the “Data” worksheet, use an automatic formatting method to format the cells in the “ĐIỂM TOÁN” column that contain values greater than 9 by applying Light Red Fill. Use a technique that automatically updates the formatting if the values change.

4.       On the “Data" worksheet, delete “KHU VỰC” column without changing cell ranges above and below it.

5.       On the “Data” worksheet, configure cell range A15:D19 so that data entries that are wider than column width will be wrapped to multiple lines.

6.       Configure column width of all cells in the table on the “Sam” worksheet will be fit its contents.

7.       Copy only value from cell range M1:M10 in the “Sam” worksheet to C3:C12 in the “Data” worksheet.


  • Project 1.xlsx Project 1.xlsx
    24 November 2022, 4:08 PM
Contact site support
You are currently using guest access (Log in)
Data retention summary
Powered by Moodle