Get premium membership and access questions with answers, video lessons as well as revision papers.
• Have inbuilt functions & formulae which can be used to perform most mathematical statistical, trigonometric or financial calculations
• Allows automatic recalculation on formulae
• #have ability to perform ‘what if’ analysis, which can be used to find out the effect of changing certain values in a worksheet on the other cells
• Have the ability to sort & filter data
• Have a data validation facility, which ensures that the correct data is entered into the spreadsheet.
• Have a chart facility that can be used to draw Line graphs, Bar charts, Pie charts, Histograms, etc.
• Some spreadsheets have a SOLVER facility that is used to uncover the best uses of scarce resources so that desired goals such as profit can be maximized, or undesired goals such as cost can be minimized.
• They enabled printing of entire worksheets, portions of a worksheet or several worksheets within the shortest time possible
• Have the ability to summarize data using Consolidation and Pivot tables.
Kavungya answered the question on June 6, 2019 at 09:45
- Define Rows(Solved)
Define Rows
Date posted: June 6, 2019. Answers (1)
- What are Sheet tabs?(Solved)
What are Sheet tabs?
Date posted: June 6, 2019. Answers (1)
- Define ‘What if’ analysis.(Solved)
Define ‘What if’ analysis.
Date posted: June 6, 2019. Answers (1)
- a) A formula to add the contents of B5 and C4 was entered in Cell F5.
what will it become when it is copied to Cell...(Solved)
a) A formula to add the contents of B5 and C4 was entered in Cell F5.
what will it become when it is copied to Cell H8?
b) Explain the reason for your answer.
c) What is the equivalent R1C1 reference for G20?
Date posted: June 6, 2019. Answers (1)
- Differentiate between relative and absolute cell reference as used in Ms-excel.(Solved)
Differentiate between relative and absolute cell reference as used in Ms-excel.
Date posted: June 6, 2019. Answers (1)
- The fist column in the table below contains formulas as entered into cell D46. In the second column, enter the formulas as they would appear...(Solved)
The fist column in the table below contains formulas as entered into cell D46. In the second column, enter the formulas as they would appear when copied to cell B56.
Date posted: June 6, 2019. Answers (1)
- A worksheet contains the data shown below:
State the value displayed in G1(Solved)
A worksheet contains the data shown below:
State the value displayed in G1
Date posted: June 6, 2019. Answers (1)
- 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...(Solved)
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.
Date posted: June 6, 2019. Answers (1)
- What is a chart wizard in spreadsheets?(Solved)
What is a chart wizard in spreadsheets?
Date posted: June 6, 2019. Answers (1)
- State the use of:
i) A pie chart
ii) A line graph(Solved)
State the use of:
i) A pie chart
ii) A line graph
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)