In a worksheet, the marks scored by ten students are stored in cell B3 to B12. i) In cell C3, show an expression you would use...

      

In a worksheet, the marks scored by ten students are stored in cell B3 to B12.
i) In cell C3, show an expression you would use to obtain positions of the students using marks scored in descending order
ii) In cell B13, write an expression you would use to extract the highest score from the marks

  

Answers

---

i)= RANK ( & B & 3 : & B & 12,O)
ii)= Max ( B3 : B12)

---

Kavungya answered the question on April 17, 2019 at 13:46

Next: Give two reasons why hardwood trees species in Kenya are in danger of extraction
Previous: The diagram below shows a simple fold.

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

Learn High School English on YouTube

Related Questions

---

• Explain briefly the difference between bound and unbound controls(Solved)
  

  Explain briefly the difference between bound and unbound controls

  Date posted: April 17, 2019.  Answers (1)

• Define the term control as used in report and form design(Solved)
  

  Define the term control as used in report and form design

  Date posted: April 17, 2019.  Answers (1)

• Explain two uses of forms in database design.(Solved)
  

  Explain two uses of forms in database design.

  Date posted: April 17, 2019.  Answers (1)

• Give any two reasons why passwords may not be reliable as security control measures.(Solved)
  

  Give any two reasons why passwords may not be reliable as security control measures.

  Date posted: April 17, 2019.  Answers (1)

• Briefly describe how the following data security measures function i) Audit trail ii) Log files iii) Fire walls(Solved)
  

  Briefly describe how the following data security measures function
  i) Audit trail
  ii) Log files
  iii) Fire walls

  Date posted: April 17, 2019.  Answers (1)

• Write the acronym BIOS in full.(Solved)
  

  Write the acronym BIOS in full.

  Date posted: April 17, 2019.  Answers (1)

• Describe the use of the following utilities i) Linkers ii) Debuggers iii) Loaders(Solved)
  

  Describe the use of the following utilities
  i) Linkers
  ii) Debuggers
  iii) Loaders

  Date posted: April 17, 2019.  Answers (1)

• Define utility software.(Solved)
  

  Define utility software.

  Date posted: April 17, 2019.  Answers (1)

• Use one’s complement to calculate 1101 – 11.(Solved)
  

  Use one’s complement to calculate 1101 – 11.

  Date posted: April 17, 2019.  Answers (1)

• In relation to weather forecasting Write GIS in full.(Solved)
  

  In relation to weather forecasting Write GIS in full.

  Date posted: April 17, 2019.  Answers (1)

• What is the difference between a teletext and videotext communication.(Solved)
  

  What is the difference between a teletext and videotext communication.

  Date posted: April 17, 2019.  Answers (1)

• Give two advantages of telecommuting.(Solved)
  

  Give two advantages of telecommuting.

  Date posted: April 17, 2019.  Answers (1)

• Define the term start button.(Solved)
  

  Define the term start button.

  Date posted: April 17, 2019.  Answers (1)

• What is the system tray?(Solved)
  

  What is the system tray?

  Date posted: April 17, 2019.  Answers (1)

• Define the term task manager.(Solved)
  

  Define the term task manager.

  Date posted: April 17, 2019.  Answers (1)

• Write the following abbreviations in full. LCD EL GPD TFT(Solved)
  

  Write the following abbreviations in full.
  LCD
  EL
  GPD
  TFT

  Date posted: April 17, 2019.  Answers (1)

• List the advantages of star topology.(Solved)
  

  List the advantages of star topology.

  Date posted: April 17, 2019.  Answers (1)

• List three advantages of bus topology.(Solved)
  

  List three advantages of bus topology.

  Date posted: April 17, 2019.  Answers (1)

• Give the advantages and disadvantages of ring topology.(Solved)
  

  Give the advantages and disadvantages of ring topology.

  Date posted: April 17, 2019.  Answers (1)

• Define the following terms: a) Biometric analysis b) Telecommuting(Solved)
  

  Define the following terms:
  a) Biometric analysis
  b) Telecommuting

  Date posted: April 17, 2019.  Answers (1)