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
|
Primary Resources
College Resources
Can't find what you want? Use this Search box. |
Secondary Resources
|
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii Tel: 0728 450 424 Tel: 0738 619 279 E-mail - sales@manyamfranchise.com |