The cells K3 to K10 of a worksheet contain remarks on students ’ performance such as very good, good, fair and fail depending on the...

      

The cells K3 to K10 of a worksheet contain remarks on students ’ performance such as very good, good, fair and fail depending on the average mark. Write a formula that can be used to count ALL students who have the remark “very good”.

  

Answers

---

=COUNTIF (K3:K10,’’Verry Good’’)

---

Kavungya answered the question on June 5, 2019 at 08:48

Next: A serial file comprises of records placed in positions 1 to 10. State the position of the end of the file market.
Previous: For each of the following give one reason why they are not allowed in a computer laboratory (i) Smoking (ii) Eating foods

View More Computer Studies Questions and Answers | Return to Questions Index

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

---

• A serial file comprises of records placed in positions 1 to 10. State the position of the end of the file market.(Solved)
  

  A serial file comprises of records placed in positions 1 to 10. State the position of the end of the file market.

  Date posted: June 5, 2019.  Answers (1)

• Name the control structure depicted by the flowchart below(Solved)
  

  Name the control structure depicted by the flowchart below
  

  Date posted: June 5, 2019.  Answers (1)

• Consider the linear arrays: i) AA (5: 50) ii) BBB (-5:50) iii) CCC (18) Find the number of elements in each array. (Solved)
  

  Consider the linear arrays:
  i) AA (5: 50)
  ii) BBB (-5:50)
  iii) CCC (18)
  Find the number of elements in each array.
  
  

  Date posted: June 5, 2019.  Answers (1)

• What is Alignment?(Solved)
  

  What is Alignment?

  Date posted: June 5, 2019.  Answers (1)

• What is Word wrap in word?(Solved)
  

  What is Word wrap in word?

  Date posted: June 5, 2019.  Answers (1)

• Outline two ways in which computers can be used in hotels.(Solved)
  

  Outline two ways in which computers can be used in hotels.

  Date posted: June 5, 2019.  Answers (1)

• Write the number 451₁₀ in BCD notation(Solved)
  

  Write the number 451₁₀ in BCD notation

  Date posted: June 5, 2019.  Answers (1)

• Arrange the following data units in ascending order of size. BYTE, FILE, BIT, NIBBLE(Solved)
  

  Arrange the following data units in ascending order of size.
  BYTE, FILE, BIT, NIBBLE

  Date posted: June 5, 2019.  Answers (1)

• State the stage of program development in which: i) A flowchart would be drawn ii) The programmer would check whether the program does as required program iii) The...(Solved)
  

  State the stage of program development in which:
  i) A flowchart would be drawn
  ii) The programmer would check whether the program does as required program
  iii) The user guide would be written
  iii) The user guide would be written
  iv) The requirements specification would be written.

  Date posted: June 5, 2019.  Answers (1)

• State the output of the following flowchart segment(Solved)
  

  State the output of the following flowchart segment
  

  Date posted: June 5, 2019.  Answers (1)

• i) Draw a flowchart to compute the combined resistance (R) of two resistors R+1 and Ra=2 in parallel using the formula ii) WRITE A PROGRAM USING...(Solved)
  

  i) Draw a flowchart to compute the combined resistance (R) of two resistors R+1 and Ra=2 in parallel using the formula
  ii) WRITE A PROGRAM USING Pascal or c languages for the flowchart in c(i) above.

  Date posted: June 5, 2019.  Answers (1)

• List paragraph formatting activities in word processing.(Solved)
  

  List paragraph formatting activities in word processing.

  Date posted: June 5, 2019.  Answers (1)

• Differentiate between bolding and highlighting text.(Solved)
  

  Differentiate between bolding and highlighting text.

  Date posted: June 5, 2019.  Answers (1)

• The following information shows the income and expenditure for “behayote” matatu for five days. The income from Monday to Friday was Ksh. 4,000, 9,000, 10,000, 15,000,...(Solved)
  

  The following information shows the income and expenditure for “behayote”
  matatu for five days. The income from Monday to Friday was Ksh. 4,000, 9,000, 10,000, 15,000, and 12,000 respectively while the expenditure for the same period was Kshs. 2,000, e, 000, 7,000, 5,000, and 6,000 respectively.
  
  i) Draw a spreadsheet that would contain the information. Indicate the rows as 1, 2, 3…..And the columns as a, B, C….
  ii) State the expression that would be used to obtain:
  I Monday’s profit
  II Total income
  III Highest expenditure.

  Date posted: June 5, 2019.  Answers (1)

• Subtract 0111₂ from 1001₂(Solved)
  

  Subtract 0111₂ from 1001₂

  Date posted: June 5, 2019.  Answers (1)

• Using two's complement, subtract 7 from 4 and give the answer in decimal notation.(Solved)
  

  Using two's complement, subtract 7 from 4 and give the answer in decimal notation.

  Date posted: June 5, 2019.  Answers (1)

• Convert 91B₁₆ to octal.(Solved)
  

  Convert 91B₁₆ to octal.

  Date posted: June 5, 2019.  Answers (1)

• Convert 376₈ to hexadecimal(Solved)
  

  Convert 376₈ to hexadecimal

  Date posted: June 5, 2019.  Answers (1)

• Convert 9.625₁₀ to binary(Solved)
  

  Convert 9.625₁₀ to binary

  Date posted: June 5, 2019.  Answers (1)

• Convert 254₁₀ to hexadecimal(Solved)
  

  Convert 254₁₀ to hexadecimal

  Date posted: June 5, 2019.  Answers (1)