Assignment: Grade:
Assign. #1 58
Assign. #2 32
Quiz 48
Discussion 40
Final Exam 72
Final Grade 50
Guest Budget:
Reservation fee ₱ 150,000
Price / person ₱ 1,050
No. of Guests 334
Budget ₱ 500,700
My House Loan
Loan amount ₱ 200,000
Terms (months) 60
Interest rate 7.42%
Payment -₱ 4,000.00
Sum of Order amount: NCR Cities:
Salesperson: Makati City Marikina City Pasig City Quezon City Taguig City
Bartolome, Rose ₱2,471,711
Deblois, Christian ₱ 1,118,228
Navarro, Mjay ₱ 2,002,575
Obenita, Mishie ₱ 1,193,479
Wenceslao, Denelle ###
Total Result ₱ 1,118,228 ₱ 2,002,575 ### ₱ 1,193,479 ₱2,471,711
Total Result
₱ 2,471,711
₱ 1,118,228
₱ 2,002,575
₱ 1,193,479
₱ 3,169,566
₱ 9,955,559
Salesperson: Navarro, Mjay
NCR Cities: Sum of Order amount:
Marikina City ₱ 2,002,575 This shape represents a
slicer. Slicers are Total
Total Result ₱ 2,002,575 supported in Excel 2010 2500000
or later.
If the shape was modified 2000000
in an earlier version of
Excel, or if the workbook
1500000
was saved in Excel 2003
or earlier, the slicer
cannot be used. 1000000
500000
0
Marikina City Total Result
Total
Sum of Order amount:
a City Total Result
Salesperson: NCR Cities: Account: Order amount: Month:
Obenita, Mishie Quezon City 15341 ₱ 135,424 January
Deblois, Christian Makati City 34513 ₱ 314,135 May
Wenceslao, Denelle Pasig City 21413 ₱ 718,354 October
Bartolome, Rose Taguig City 85694 ₱ 386,645 February
Navarro, Mjay Marikina City 43132 ₱ 356,536 September
Obenita, Mishie Quezon City 15341 ₱ 651,783 January
Deblois, Christian Makati City 34513 ₱ 213,124 November
Wenceslao, Denelle Pasig City 21413 ₱ 895,413 October
Bartolome, Rose Taguig City 85694 ₱ 386,645 February
Navarro, Mjay Marikina City 43132 ₱ 356,536 September
Obenita, Mishie Quezon City 52141 ₱ 135,424 April
Deblois, Christian Makati City 54241 ₱ 213,124 March
Wenceslao, Denelle Pasig City 21413 ₱ 413,643 October
Bartolome, Rose Taguig City 85694 ₱ 738,952 July
Navarro, Mjay Marikina City 28813 ₱ 356,536 June
Obenita, Mishie Quezon City 91841 ₱ 135,424 November
Deblois, Christian Makati City 34513 ₱ 164,721 May
Wenceslao, Denelle Pasig City 18572 ₱ 413,643 October
Bartolome, Rose Taguig City 14231 ₱ 386,645 March
Navarro, Mjay Marikina City 43132 ₱ 576,431 September
Obenita, Mishie Quezon City 15341 ₱ 135,424 January
Deblois, Christian Makati City 34513 ₱ 213,124 April
Wenceslao, Denelle Pasig City 21413 ₱ 728,513 October
Bartolome, Rose Taguig City 63813 ₱ 572,824 December
Navarro, Mjay Marikina City 70284 ₱ 356,536 August
