EX 4 • Use the Weekday function starting in C11 to extract the weekday by serial number starting in B11 Use the Switch f

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

EX 4 • Use the Weekday function starting in C11 to extract the weekday by serial number starting in B11 Use the Switch f

Post by answerhappygod »

Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 1
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 1 (43.29 KiB) Viewed 30 times
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 2
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 2 (70.49 KiB) Viewed 30 times
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 3
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 3 (46.07 KiB) Viewed 30 times
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 4
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 4 (43.96 KiB) Viewed 30 times
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 5
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 5 (45.72 KiB) Viewed 30 times
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 6
Ex 4 Use The Weekday Function Starting In C11 To Extract The Weekday By Serial Number Starting In B11 Use The Switch F 6 (97.34 KiB) Viewed 30 times
EX 4 • Use the Weekday function starting in C11 to extract the weekday by serial number starting in B11 Use the Switch function starting in D11 to get the the Weekdays. • Use the IF function to calculate the down payment starting in H11. If type=Finance, then the down payment is 10% of the amount. Else, it is equal to the amount. • Use a nested function to calculate Last PMT Date. If there is a Balance, then the date is 48 months after the date in column B (Use EDATE for this function). Else, there is no date. • Use countif to calculate the number of paid in full transactions in 2. • Use sumif to calculate the total dollar amount of the paid in full transactions in 13. • Use averageif to calculate the average dollar amount of the paid in full transactions in J4. • Use averageifs to calculate the average dollar amount of the paid in full transactions over $4000 in JS. • Use maxifs to calculate the Highest Paid-in-Full Transaction Amount.

Reid Furniture Store Day 1 2 Required Down Payment: No. of Monthly Payments: 15% 48 Nm Weekday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Paid-in-Full Transactions No. of Paid-in-Full Transactions Sum of Paid-in-Full Transactions Average of Paid-in Full Transactions Average Amount Above $4,000 Highest Paid-in-Full Transaction Amount 3 4 5 6 7 Weekday Number Number 2021-001 2021-002 2021-003 2021-004 2021-005 2021-006 2021-007 2021-008 2021-009 2021-010 2021-011 2021-012 2021-013 2021-014 2021-015 2021-016 2021-017 Date 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/1/2021 3/2/2021 3/2/2021 3/2/2021 3/3/2021 3/3/2021 3/3/2021 3/4/2021 3/4/2021 Weekday Department Type Bedroom Finance Bedroom Finance Living Room Finance Living Room Finance Appliances Finance Living Room Finance Dining Room Finance Dining Room Finance Appliances Finance Dining Room Finance Dining Room Finance Appliances Paid in Full Living Room Finance Dining Room Paid in Full Living Room Finance Appliances Paid in Full Appliances Finance Down Amount Payment 13,826 6,880 8,378 12,770 10,496 4,416 2,774 14,969 7,444 8,410 1,497 3,641 7,718 2,075 3,108 14,506 7,795 Balance Last PMT Date 13,826.00 6,880.00 8,378.00 12,770.00 10,496.00 4,416.00 2,774.00 14,969.00 7,444.00 8,410.00 1,497.00 3,641.00 7,718.00 2,075.00 3,108.00 14,506.00 7,795.00

Weekday Number Down Payment 10 Number 28 2021-018 29 2021-019 30 2021-020 31 2021-021 32 2021-022 33 2021-023 34 2021-024 35 2021-025 36 2021-026 37 2021-027 38 2021-028 39 2021-029 40 2021-029 41 2021-030 42 2021-031 43 2021-032 44 2021-033 Date 3/4/2021 3/5/2021 3/5/2021 3/5/2021 3/6/2021 3/6/2021 3/6/2021 3/7/2021 3/7/2021 3/8/2021 3/8/2021 3/9/2021 3/9/2021 3/9/2021 3/10/2021 3/10/2021 3/11/2021 Weekday Department Type Appliances Finance Living Room Paid in Full Living Room Paid in Full Dining Room Paid in Full Dining Room Finance Living Room Paid in Full Dining Room Finance Dining Room Finance Living Room Paid in Full Dining Room Finance Appliances Finance Appliances Finance Appliances Finance Living Room Finance Dining Room Finance Dining Room Paid in Full Appliances Paid in Full Amount 13,510 14,183 10,640 11,655 7,370 13,511 10,831 3,602 11,110 11,348 5,346 13,391 6,992 14,814 2,754 8,653 8,972 Balance Last PMT Date 13,510.00 14,183.00 10,640.00 11,655.00 7,370.00 13,511.00 10,831.00 3,602.00 11,110.00 11,348.00 5,346.00 13,391.00 6,992.00 14,814.00 2,754.00 8,653.00 8,972.00

45 2021-034 46 2021-035 47 2021-036 48 2021-037 49 2021-038 50 2021-039 51 2021-040 52 2021-041 53 2021-042 54 2021-043 55 2021-044 56 2021-045 57 2021-046 58 2021-047 59 2021-048 60 2021-049 61 2021-050 3/11/2021 3/12/2021 3/12/2021 3/13/2021 3/13/2021 3/13/2021 3/13/2021 3/14/2021 3/14/2021 3/14/2021 3/15/2021 3/15/2021 3/15/2021 3/16/2021 3/16/2021 3/17/2021 3/17/2021 Appliances Paid in Full Appliances Finance Appliances Paid in Full Dining Room Paid in Full Dining Room Paid in Full Appliances Finance Appliances Paid in Full Dining Room Finance Living Room Finance Dining Room Finance Living Room Paid in Full Appliances Paid in Full Dining Room Finance Living Room Paid in Full Appliances Finance Appliances Finance Dining Room Paid in Full 10,638 6,166 3,443 940 2,137 4,772 12,922 14,391 6,387 11,031 13,360 8,908 1,734 5,788 5,200 5,655 9,564 10,638.00 6,166.00 3,443.00 940.00 2,137.00 4,772.00 12,922.00 14,391.00 6,387.00 11,031.00 13,360.00 8,908.00 1,734.00 5,788.00 5,200.00 5,655.00 9,564.00

62 2021-051 63 2021-052 64 2021-053 65 2021-054 66 2021-055 67 2021-056 68 2021-057 69 2021-058 70 2021-059 71 2021-060 72 2021-061 73 2021-062 74 2021-063 75 2021-064 76 2021-065 77 2021-066 78 2021-067 3/18/2021 3/18/2021 3/19/2021 3/19/2021 3/19/2021 3/19/2021 3/20/2021 3/20/2021 3/20/2021 3/20/2021 3/21/2021 3/21/2021 3/21/2021 3/21/2021 3/22/2021 3/22/2021 3/22/2021 Dining Room Paid in Full Appliances Paid in Full Dining Room Paid in Full Appliances Paid in Full Dining Room Paid in Full Living Room Finance Dining Room Paid in Full Appliances Paid in Full Dining Room Finance Dining Room Finance Appliances Finance Dining Room Finance Dining Room Finance Appliances Finance Living Room Finance Appliances Paid in Full Living Room Finance 2,082 13,356 12,267 11,371 3,888 5,771 2,522 10,182 7,153 10,841 3,945 402 609 8,247 12,228 7,858 1,656 2,082.00 13,356.00 12,267.00 11,371.00 3,888.00 5,771.00 2,522.00 10,182.00 7,153.00 10,841.00 3,945.00 402.00 609.00 8,247.00 12,228.00 7,858.00 1,656.00

79 2021-069 80 2021-070 81 2021-071 82 2021-072 83 2021-073 84 2021-074 85 2021-075 86 2021-076 87 2021-077 88 2021-078 89 2021-079 90 2021-080 91 2021-081 92 2021-082 93 2021-083 94 2021-084 95 2021-085 96 2021-086 97 2021-087 98 2021-088 99 2021-089 100 2021-090 101 2021-091 102 2021-092 103 2021-093 104 2021-094 105 2021-095 106 2021-096 107 2021-097 108 2021-098 109 2021-099 110 2021-100 111 2021-101 112 2021-102 113 2021-103 3/23/2021 3/23/2021 3/23/2021 3/23/2021 3/24/2021 3/24/2021 3/24/2021 3/24/2021 3/24/2021 3/24/2021 3/24/2021 3/25/2021 3/25/2021 3/25/2021 3/25/2021 3/25/2021 3/26/2021 3/26/2021 3/26/2021 3/26/2021 3/26/2021 3/27/2021 3/27/2021 3/28/2021 3/28/2021 3/28/2021 3/29/2021 3/29/2021 3/29/2021 3/30/2021 3/30/2021 3/30/2021 3/31/2021 3/31/2021 3/31/2021 Dining Room Finance Living Room Finance Appliances Paid in Full Bedroom Finance Living Room Finance Living Room Paid in Full Living Room Paid in Full Bedroom Finance Bedroom Finance Bedroom Paid in Full Bedroom Finance Living Room Finance Bedroom Finance Bedroom Finance Bedroom Finance Bedroom Finance Dining Room Paid in Full Bedroom Paid in Full Bedroom Paid in Full Bedroom Paid in Full Bedroom Paid in Full Dining Room Paid in Full Bedroom Finance Living Room Finance Bedroom Paid in Full Bedroom Paid in Full Living Room Finance Bedroom Finance Bedroom Finance Dining Room Finance Bedroom Finance Bedroom Finance Bedroom Finance Bedroom Paid in Full Living Room Finance 7,102 14,079 12,379 9,805 4,308 13,684 5,442 2,185 7,857 7,351 3,712 4,467 5,070 10,186 1,454 5,736 2,339 10,050 6,164 9,812 2,117 11,223 1,669 10,123 990 5,470 1,260 613 5,294 3,789 12,124 14,727 9,867 1,195 6,550 7,102.00 14,079.00 12,379.00 9,805.00 4,308.00 13,684.00 5,442.00 2,185.00 7,857.00 7,351.00 3,712.00 4,467.00 5,070.00 10,186.00 1,454.00 5,736.00 2,339.00 10,050.00 6,164.00 9,812.00 2,117.00 11,223.00 1,669.00 10,123.00 990.00 5,470.00 1,260.00 613.00 5,294.00 3,789.00 12,124.00 14,727.00 9,867.00 1,195.00 6,550.00
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”