Study the spread sheet below and answer the questions that follow. i)Write down the function that can be used to find price of most costly book....

Study the spread sheet below and answer the questions that follow.

i)Write down the function that can be used to find price of most costly book.
ii)Write down the formula that can be used to determine the total sales for the book titled COMMUTER
iii)Write down the function that can be used to determine the average price of the books in cell D10.
iv)Write down the formula in cell D3 that can be used to calculate new price for DBASE IV
if the price went up by a percentage written in B10 (5%).
v)State any two advantages of using an electronic spread sheet as compared to a traditional spread sheet.

Answers

i)= MAX (C3 : C9)
ii)= C9: B9
iii)= AVERAGE (D2: D9)
iv)= B10*400 + 400
v)Automatic recalculation
Utilises the powerful aspects of comp such as speed, accuracy and efficiency.
Have inbuilt functions
Enable users to produce neat work

---

Kavungya answered the question on October 8, 2019 at 09:27

Next: Nomino zifuatazo ni za ngeli gani? i) Nzi ii) Soksi
Previous: Saidi : Hallo............Hallo....Huyo ni Bw. Mohamed?Mohamed : Ndio...uko wapi...Saidi : Shuleni...sasa...ulinifikishia ujumbe?Mohamed : La. Parade ilikuwa imehitimishwaSaidi : Sina credit. Nipigie tafadhali.Mohamed : Sina...

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

• Convert the following numbers into denary 111.01011 (Solved)
  

  Convert the following numbers into denary
  111.01011

  Date posted: October 8, 2019.  Answers (1)

• Work out the following binary additions and subtractions. 00111101011₂ - 100011₂ + 0101011₂ - 11001₂ + 00111₂ (Solved)
  

  Work out the following binary additions and subtractions.
  00111101011₂ - 100011₂ + 0101011₂ - 11001₂ + 00111₂

  Date posted: October 8, 2019.  Answers (1)

• Evaluate the following numbers into binary equivalent. 77²120₁₀ (Solved)
  

  Evaluate the following numbers into binary equivalent.
  77²120₁₀

  Date posted: October 8, 2019.  Answers (1)

• What is line spacing in word processing? (Solved)
  

  What is line spacing in word processing?

  Date posted: October 8, 2019.  Answers (1)

• State the importance of Program testing in programming.(Solved)
  

  State the importance of Program testing in programming.

  Date posted: October 8, 2019.  Answers (1)

• State the importance of Assembler in programming. (Solved)
  

  State the importance of Assembler in programming.
  
  

  Date posted: October 8, 2019.  Answers (1)

• Explain the functions of complementary metal-oxide semiconductor (CMOS)(Solved)
  

  Explain the functions of complementary metal-oxide semiconductor (CMOS)

  Date posted: October 1, 2019.  Answers (1)

• Briefly explain what happen during power on self test (POST)(Solved)
  

  Briefly explain what happen during power on self test (POST)

  Date posted: October 1, 2019.  Answers (1)

• State and explain the following types of relationship as used in database design(Solved)
  

  State and explain the following types of relationship as used in database design
  

  Date posted: October 1, 2019.  Answers (1)

• State the following types of transcription errors: i. 3455 instead of 3456 ii. Simth instead of Smith(Solved)
  

  State the following types of transcription errors:
  i. 3455 instead of 3456
  ii. Simth instead of Smith

  Date posted: October 1, 2019.  Answers (1)

• Using one’s complement, calculate 5₁₀ – 9₁₀. Use six bit in your calculation.(Solved)
  

  Using one’s complement, calculate 5₁₀ – 9₁₀. Use six bit in your calculation.

  Date posted: October 1, 2019.  Answers (1)

• Convert 3BD₁₆ to Octal.(Solved)
  

  Convert 3BD₁₆ to Octal.

  Date posted: October 1, 2019.  Answers (1)

• Convert 0.11011₂ to its decimal equivalent(Solved)
  

  Convert 0.11011₂ to its decimal equivalent

  Date posted: October 1, 2019.  Answers (1)

• Convert binary number 11010110.1001₂ into hexadecimal number.(Solved)
  

  Convert binary number 11010110.1001₂ into hexadecimal number.

  Date posted: October 1, 2019.  Answers (1)

• Convert binary number 11010110.1001₂ into octal number.(Solved)
  

  Convert binary number 11010110.1001₂ into octal number.

  Date posted: October 1, 2019.  Answers (1)

• Find the sum of binary number 101.101₂ and 110.100₂(Solved)
  

  Find the sum of binary number 101.101₂ and 110.100₂

  Date posted: October 1, 2019.  Answers (1)

• Subtract 110₂ from 11010₂(Solved)
  

  Subtract 110₂ from 11010₂

  Date posted: October 1, 2019.  Answers (1)

• Give a reason why HTML is not considered as a true programming language.(Solved)
  

  Give a reason why HTML is not considered as a true programming language.

  Date posted: October 1, 2019.  Answers (1)

• Benjos was instructed by his teacher while typing a Microsoft word document to replace all the occurrences of the word MS with Microsoft. Highlight the...(Solved)
  

  Benjos was instructed by his teacher while typing a Microsoft word document to replace all the occurrences of the word MS with Microsoft. Highlight the steps to do this

  Date posted: October 1, 2019.  Answers (1)

• Name two files that are created in mail merging process(Solved)
  

  Name two files that are created in mail merging process

  Date posted: October 1, 2019.  Answers (1)