ALE Palt a) What is a spreadsheet? b) Give three examples of spreadsheets. 5 6 Use...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ALE Palt a) What is a spreadsheet? b) Give three examples of spreadsheets. 5 6 Use the Excel diagram below to answer questions [c] te B A A 1 STAFF ID 2 3 4 10026922 10026923 10026924 10026925 10026926 7 10026927 8 10026928 9 10026929 10 10026930 READY #E MOT 11 10026931 12 10026932 S M -m B NAME WALINGO MARY VENESSA MWANGI KARIUKI MONARI OKELLO MAURICE WINNIE CHEBI KONES ALFRED ZURA AHMED KANDA ZORO TOBIAS OKENGO TARUS KING TALA ADHI D NEW NOW #Woop Twd C D SALES P/F 800 1000 3588 700 950 1200 400 5000 600 1700 1300 VA Como F E DIVIDEND Thym F Com Στα H I 27 14 1 c) Name the parts labeled A, B and C in the diagram above. [3 Marks] [2 Marks] d) What would happen if you click the part marked D? e) The sale representatives were each given a goal of 1000 shillings. Describe how you would use excel built in functions to complete the column for those who have passed the goal and those who have failed to pass the goal [P/F]. Clearly state the formula you would use. [5 Marks] f) Show how you would calculate the dividends for the sales representatives if they are to get dividends as follows: [5 Marks] (i) Less than 800 at 5% (ii) Between 800 and 1200 at 10% (iii) Between 1200 and 1600 at 15% ALE Palt a) What is a spreadsheet? b) Give three examples of spreadsheets. 5 6 Use the Excel diagram below to answer questions [c] te B A A 1 STAFF ID 2 3 4 10026922 10026923 10026924 10026925 10026926 7 10026927 8 10026928 9 10026929 10 10026930 READY #E MOT 11 10026931 12 10026932 S M -m B NAME WALINGO MARY VENESSA MWANGI KARIUKI MONARI OKELLO MAURICE WINNIE CHEBI KONES ALFRED ZURA AHMED KANDA ZORO TOBIAS OKENGO TARUS KING TALA ADHI D NEW NOW #Woop Twd C D SALES P/F 800 1000 3588 700 950 1200 400 5000 600 1700 1300 VA Como F E DIVIDEND Thym F Com Στα H I 27 14 1 c) Name the parts labeled A, B and C in the diagram above. [3 Marks] [2 Marks] d) What would happen if you click the part marked D? e) The sale representatives were each given a goal of 1000 shillings. Describe how you would use excel built in functions to complete the column for those who have passed the goal and those who have failed to pass the goal [P/F]. Clearly state the formula you would use. [5 Marks] f) Show how you would calculate the dividends for the sales representatives if they are to get dividends as follows: [5 Marks] (i) Less than 800 at 5% (ii) Between 800 and 1200 at 10% (iii) Between 1200 and 1600 at 15%
Expert Answer:
Answer rating: 100% (QA)
Question A a A spreadsheet is a file that exists of cells in rows and columns ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Wolfe, Inc. had credit sales for the period of $144,000. The balance in Allowance for Doubtful Accounts is a debit of $653. If Wolfe estimates that 2% of credit sales will be uncollectible, what is...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
(1) Suppose u = x1X2, (X1, X2 )E R+, find the expenditure function e (p, p2, u), that corresponds to the utility function. (2) Suppose u'= Inx1 + Inx2, (x1, x2 )E R+, find the expenditure function e'...
-
List the following classifications of accounts in all of the columns in which they appear on the work sheet, with the exception of the Adjustments columns. (Example: Assets) Assets ...................
-
Catherine Big has a cash balance of 52,900 on 1 June 20X3. She opens a current account on that date, with Belfast Bank, depositing 50,000. Her transactions during the next three days included the...
-
For the following exercises, determine why the function f is discontinuous at a given point a on the graph. State which condition fails. f(x) = x - 16x X , a = 0
-
Under the assumptions of the linear model, the residual plot will exhibit a linear pattern. In Exercises 9 and 10, determine whether the statement is true or false. If the statement is false, rewrite...
-
The Coca-Cola Companys manufacturing operations are ideal for process costing because it and its bottlers produce long runs of identical beverages in a continuous flow production process. Go to the...
-
What is the maximum price you will pay for a bond with a face value of $1,000 and a coupon rate of 14%, paid annually, if you want a yield to maturity of 10%? Assume that the bond will mature in 10...
-
A plant hire company purchases a mobile crane for 120,000. It plans to charge 190 a day for hiring out the crane. For each day on which it is hired out the company expects to incur variable costs of...
-
What is a Dutch auction share repurchase?
-
If a change in leverage raises a firms earnings per share, should this cause its share price to rise in a perfect market?
-
How do you determine the weight of a stock in the market portfolio?
-
What other techniques do corporations use to calculate the cost of capital?
-
Why does the equity beta of a levered firm differ from the beta of its assets?
-
Which of the following is true of internal control? A. Internal controls are only necessary for public companies. B. Internal control procedures tend to diminish the importance of operational...
-
What key concerns must functional tactics address in marketing? Finance? POM? Personnel?
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
What is a post-mortem?
-
A __________ is another name for a project close-out meeting A. celebration B. post project C. final review D. post mortem
-
What advice about project closing is most useful to you? What other advice would you add?
Study smarter with the SolutionInn App