Excel Answers

Students NamesInt1 MarksInt2 MarksInt3 MarksFinal ICAStatusScore of 100Mpho Tau5010090Neo Kou1001030Dee Maps203525Dkay Reed1004585Thabo Koloi506530Thato Khahloe10010090

Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).

Section A    [40]

Part 1: Use Data in “Student Marks” Sheet

1. Use a formula (not a function) to calculate the Final ICA of Students. [2]
2. Use a function to test if there is a student who scored a 100 on one of the internal assessments. [2]
3. Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).     [6]
4. Count the number of students who are proceeding using “count-if” function                [4]
5. Count all none empty cells from cell A2 to cell F7 using a function.  [2]
6. Use v-lookup function to return Int2 Marks of Dkay Reed.        [2]
7. Use H-lookup function to return the name of a Student who got 45 on Int3 assessment. [2]

Section A    [40]

Part 1: Use Data in “Student Marks” Sheet

1. Use a formula (not a function) to calculate the Final ICA of Students. [2]
2. Use a function to test if there is a student who scored a 100 on one of the internal assessments. [2]
3. Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).     [6]
4. Count the number of students who are proceeding using “count-if” function                [4]
5. Count all none empty cells from cell A2 to cell F7 using a function.  [2]
6. Use v-lookup function to return Int2 Marks of Dkay Reed.        [2]
7. Use H-lookup function to return the name of a Student who got 45 on Int3 assessment. [2]

The BMI (Body Mass Index) is calculated using height (measured in meters) and weight (measured in

Kg) of a person. A person with BMI of 25.0 or more is considered overweight, while the

healthy/normal range is 18.5 to 24.9 and a person with BMI less than 18.5 is considered underweight.

draw flowchart of this statement

What are the 3 type of output for the project

Describe the function of the following statements as used in vba

1. Sheets ("sheets"). Range (A1")=me .T1.value

2. Exit button

Outline 4 traits of an effective software project management

You saw an advert for a used car that you would like to

buy.

The advert says that the dealer will give anyone a $500

trade in on his or her old vehicle.

The asking price for the car

(before trade-in) is $4,000. They will offer you a 4% interest

rate for a 3-year loan.

What is the amount you need to

finance?

Use the PMT function to determine what your

monthly payments will be. Copy the work, and then use the

Goal Seek tool to determine what the asking price of the car,

before trade-in would have to be to make a monthly payment

of $70. Show both scenarios in your worksheet. Present the

monthly payment and loan on a bar chart.

A car advert says the dealer would give anyone a $500 trade in on his old car. The asking price for the car (before trade in) is $4000, they will offer you a 4% interest rate for a 3year loan. What is the amount you need to finance? Use the pmt function to determine your monthly payment. Copy the work and then use the goal seek tool to determine what the asking price of the car before trade in would have to be to make a monthly payment of $70. Present the payment and loan on a bar chart.

Create a excel sheet and name it as Student_Attendance sheet with the following columns

a.      S.No , RegId, Name, Gender, Lectures Attended, Lectures Delivered, Attendance percentage.

(Note : Attendance percentage = LecturesAttended/LecturesDelivered * 100)

a.      Highlight Column Headings with background color and a different text color. Also Use text Rotation.

2.      Add data validation on

a.      Lectures Delivered Column to make sure that lectures delivered should be exactly equal to 45 for every student.

b.     Lectures Attended Column to make sure that lectures Attended should be less than or equal to 45

c.      Gender column to make sure user should be able to enter only two values i.e. Male or Female.

Note: For every validation, generate an error message in case of incorrect input.(10)