COMPUTER STUDIES QUESTIONS WITH ANSWERS
Difference between 'count' and 'count if functions as used in spreadsheets
0 Comments
A worksheet contains the data as shown below.
The table below shows how a kiosk owner uses a spread sheet to keep records in a shop. Write a function to calculate the total buying price. =product(B2:C2) or =product(B2,C2) Write a formula to calculate the Profit. =E2-D2 The total buying prices of all items was increased by 12% and the value 12% is placed in cell B6. Using cell addresses with absolute referencing, write a formula to calculate the Total Selling Price in cell E2. =($B$6/100)*D2 State the output of the expression =SUMIF(F2:F5,"<1 500")would return.
2530 Define the following terms as used in charts. Legend
Data range
Meaning of “what if analysis”
Distinguish between workbook and a worksheet
Assume that cell F5 to F10 in a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the value of 5%. Write a formula that will be used to increase the value stored in cell F5 by 5 percent which will then be copied to other cells.=F5*(1+$F$12) or =F5+ (F5*$F$12)
Using relevant examples distinguish between a formula and function.
The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.(a) Describe the basic data types used in this spreadsheet (4mks)
(b) Provide a single formula that would be used to
|
Categories
All
Archives
December 2024
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|