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 4

Project 4

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

1.       On the “Scores” worksheet, use a function to fill the value of “Full Name” column (column D) by joining “First Name” and “Last Name” which separated by space.

2.       On the “Scores” worksheet, use a function to fill the value of “Total score” (column J) by calculating the total value from column G to column I.

3.       On the “Scores” worksheet, enter a formula in J24 that uses an Excel function to return the “Total score” value of the student that has the highest value.

4.       In cell B3 of the “Data” worksheet, use a function that will display of first three characters from cell A3 and capitalize all of them. Fill the formula to the entire “Code name” column.

5.       On the “Scores” worksheet, use a function to fill the value of “Result” column by showing the text “Pass” if value of “Total score” is greater than or equal to the value of “Benchmark” column. Otherwise, leave it blank

6.       On the “Data” worksheet, in the “Number” column, use a function to count the number of occurrences of countries from the value in “Code” column (column D).

7.       Navigate to cell range named “Academy” and merge all cells of it into a cell without changing alignment.


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