Insert a column after the Assg2 column and two columns after the Final Exam column. Name the new inserted columns as CW, Final Mark and Grade respectively.

others

Description

Objective:

1. To practice your skill on using IF formula 


2. To learn COUNTIF formula for counting values of cells Using the template given (lab3template.xls), try out the following:


2. Insert a column after the Assg2 column and two columns after the Final Exam column. Name the new inserted columns as CW, Final Mark and Grade respectively.


3. Calculate : 

a. CW column. Note that CW must be normalized to 100 and you must round every CW to an Integer (use ROUND function). CW is composed of Lab 20% Test 10% Assg1 15% Assg2 15% 


b. Final Mark column.

Instruction Files

Related Questions in others category