Study the worksheet below and answer the questions that follow: i) Write functions that can be entered to get total, maximum, and average of each region. ii) Write...

Study the worksheet below and answer the questions that follow:

i) Write functions that can be entered to get total, maximum, and average of
each region.
ii) Write down the function that returns the number of sales in the four regions
whose value is greater than or equal to 2000.
iii) The function = sum (B4:E4) is entered at F5 and then copied to F8. Write down the function as it appears in the destination cell.

---

i)Total = Sum (B4:B8)
Maximum: = Max (B4:B8)
Average: = Average (B4: B8)

ii)= SUMIF (B4:E4, “>=2000”)

iii)= sum (B7:E7)

---

Kavungya answered the question on June 6, 2019 at 09:28

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

---

• What is a chart wizard in spreadsheets? (Solved)
  

  What is a chart wizard in spreadsheets?

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

• State the components of a Database hierarchy in ascending order. (Solved)
  

  State the components of a Database hierarchy in ascending order.

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

• What are database management system software? (Solved)
  

  What are database management system software?

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

• Give the two classes of database software. (Solved)
  

  Give the two classes of database software.

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

• State the use of the following objects in databases. i) Tables ii) Forms iii) Query (Solved)
  

  State the use of the following objects in databases.
  i) Tables
  ii) Forms
  iii) Query

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

• Differentiate between Tabular and columnar form layout. (Solved)
  

  Differentiate between Tabular and columnar form layout.

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

• Describe four major shortcomings of the conventional (paper )file structures that are being addressed by the database approach. (Solved)
  

  Describe four major shortcomings of the conventional (paper )file structures that are being addressed by the database approach.

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

• The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost. a) Prepare a suitable database structure showing field names and... (Solved)
  

  The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost.
  a) Prepare a suitable database structure showing field names and their field data types
  b) Explain how you index the data such that cars of the same make and colour are together.
  c) Write a statement that can be used to select cars of colour green.
  d) Give an instruction that would:
  i) Select cars whose cost is between 500,000/= and 1,000,000/=
  ii) Determine the average cost of all cars.

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

• Differentiate between Fill and stroke (Solved)
  

  Differentiate between Fill and stroke

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

• Differentiate between Change case and drop cap. (Solved)
  

  Differentiate between Change case and drop cap.

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

• Differentiate between Margins and column guides. (Solved)
  

  Differentiate between Margins and column guides.

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

• Differentiate between pasteboard and printable page (Solved)
  

  Differentiate between pasteboard and printable page.

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

• Why is layering very useful in a desktop publisher? (Solved)
  

  Why is layering very useful in a desktop publisher?

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

• Name the two most common protocols for the Internet, and state their functions. (Solved)
  

  Name the two most common protocols for the Internet, and state their functions.

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

• Mention two examples of email software. (Solved)
  

  Mention two examples of email software.

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

• Briefly describe four factors contributing to Internet access and growth in Kenya. (Solved)
  

  Briefly describe four factors contributing to Internet access and growth in Kenya.

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

• Differentiate between data security and data integrity. (Solved)
  

  Differentiate between data security and data integrity.

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

• Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access... (Solved)
  

  Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access to its computer-based systems.

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

• Give four rules that must be observed in order to keep within the law when working with data and information. (Solved)
  

  Give four rules that must be observed in order to keep within the law when working with data and information.

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

• An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information. (Solved)
  

  An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.

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