A) Given the following excel table
A B C D
1 12 18
2 10 15
3 17 20
4 17 12
5 10 20
6 12 15
7 18 14
8
i. Give the formula that would be put in each of the cells in column C so that a cell in column C will contain the greater of the two values in the cells to its left. You can give the answer for only row 1 [2 marks]
=max(A1:B1) or MAX(A1,B1)
ii. In Cell A8, give a formula that counts the number of values that are greater than 15 in column A [2 marks]
=COUNTIF(A1:A11,”>15″)
iii. In cell D3 give a formula to output the row number [2 marks]
=row()
B) Given the following excel table
C) The excel function that you can use to show some values in a grid while other values are not show is called [1 mark]
filter
D) In Microsoft PowerPoint, the slide whose design once set, affects the design of all other slides is called [1 mark]
Slide Master
E) Differentiate between a single user and a multi user operating system
[2 marks]
In a single user OS, only one user can be logged in and using the system at any one time.
In a multi user operating system, many users can be logged in and using
the system at the same time
For a custom-written paper on the above topic, place your order now!
What We Offer
• On-time delivery guarantee
• PhD-level professionals
• Automatic plagiarism check
• 100% money-back guarantee
• 100% Privacy and Confidentiality
• High Quality custom-written papers
