Up next

Spreadsheets Excel Lesson 8: How to compute for Percentage Increase or decrease in Excel using IF

6 Views· 05 May 2024
Landus Mumbere Expedito
Landus Mumbere Expedito
24 Subscribers

a) Due to inflation, the management increased the wages of employees who
earn 300,000 and below by 20% and for those who earn above 300,000 by
15% for month of September. Using an appropriate function, compute the
new wage for each employee in the month of September.
b) Add a columns for SEP PAYE, SEP NSSF, SEP NET PAY after SEP WAGES
c) Calculate the Pay as You Earn (PAYE) tax given that its rate is 8% of the
Gross wage. There after calculate the second oldest age in cell B9
d) NSSF is calculated at 3% of Gross wage. Calculate the NSSF savings for
September per employee.
e) Use a suitable formula to generate the NET PAY that will be available for
each employee.
f) In the TOTALS row, compute the Totals for all the columns having
g) In cell C10 use the count if function to compute for how many are managers.
h) Add “Shs” symbol as a suffix to your values in the table.
i) Apply a green line colour “all borders” outline to all cells with data.
j) Select the Names Column September Wages column to generate a 3-D
clustered column graph with appropriate labels to be saved as Employee
Pictorial Data.
k) Fill your bars with a green horizontal brick pattern.
l) Add your name and class as a right aligned footer and print your work in a
landscape orientation.

More Video Lessons on Excel By Kakuru Benard
Video Lesson 1: https://youtu.be/x3I3hd5Yno8
Video Lesson 2: https://youtu.be/Pg0WhScI-Ro
Video Lesson 3: https://youtu.be/EsQqJMpibUo
Video Lesson 4: https://youtu.be/P4-YUw0Zt5M
Video Lesson 5: https://youtu.be/1h8ZWtuXtfQ
Video Lesson 6: https://youtu.be/AtUnAAzTmHI
Video Lesson 7: https://youtu.be/ABET0r0rRk4
Video Lesson 8: https://youtu.be/XHie9m8h9Ek
Wakisha 2023: https://youtu.be/U5-oYEIUn5o
UNEB 2023 Paper 2: https://youtu.be/jAgtwfS6OC8
UNEB 2023 Paper 3: https://youtu.be/E2bwpS-Gwgw
UNEB 2023 Paper 1: https://youtu.be/GWRXjetAjpg

Show more

 0 Comments sort   Sort By

Up next