Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
MODE.SNGL. MODE.SNGL(range) returns the value that appears most often. If two values tie, it returns the one that appears first in the range. If nothing repeats, it gives #N/A. The older name MODE works the same way.
=MODE.SNGL(B2:B50) the most common number of seats per booking
Purchasing wants to set the default quantity on the Copy Paper A4 (500) reorder form to the pack count customers order most often. D2:D27 lists every completed copy paper line from Q1.
In G2, return the quantity that appears most often in D2:D27.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Packs | Copy paper, Q1 | |||
| 2 | 50003 | 2025-01-01 | Silver Print Co | 6 | Most common qty | |||
| 3 | 50049 | 2025-01-17 | Silver Pharmacy | 5 | Average qty | 5.8 | ||
| 4 | 50061 | 2025-01-22 | Orchard Consulting | 4 | ||||
| 5 | 50067 | 2025-01-23 | Harbor Consulting | 13 | ||||
| 6 | 50079 | 2025-01-28 | Harbor Studios | 5 | ||||
| 7 | 50098 | 2025-02-03 | Lakeside Pharmacy | 8 | ||||
| 8 | 50101 | 2025-02-04 | Copper Pharmacy | 6 | ||||
| 9 | 50114 | 2025-02-07 | Beacon Fitness | 6 | ||||
| 10 | 50118 | 2025-02-10 | Oak Studios | 3 | ||||
| 11 | 50126 | 2025-02-12 | Beacon Accounting | 6 | ||||
| 12 | 50130 | 2025-02-13 | Cedar Realty | 9 | ||||
| 13 | 50155 | 2025-02-21 | Beacon Architects | 3 | ||||
| 14 | 50166 | 2025-02-25 | Willow Studios | 6 | ||||
| 15 | 50168 | 2025-02-26 | Summit Fitness | 5 | ||||
| 16 | 50175 | 2025-02-27 | Harbor Hotels | 6 | ||||
| 17 | 50178 | 2025-02-28 | Orchard Consulting | 5 | ||||
| 18 | 50190 | 2025-03-05 | North Pharmacy | 4 | ||||
| 19 | 50197 | 2025-03-07 | Harbor Realty | 4 | ||||
| 20 | 50202 | 2025-03-10 | Copper Media | 14 | ||||
| 21 | 50209 | 2025-03-11 | Harbor Labs | 13 | ||||
| 22 | 50210 | 2025-03-12 | Oak Fitness | 6 | ||||
| 23 | 50239 | 2025-03-20 | Orchard Logistics | 5 | ||||
| 24 | 50253 | 2025-03-26 | Granite Accounting | 3 | ||||
| 25 | 50261 | 2025-03-28 | Harbor Studios | 3 | ||||
| 26 | 50262 | 2025-03-28 | Cedar Studios | 3 | ||||
| 27 | 50263 | 2025-03-29 | Copper Dental | 1 | ||||
| 28 | ||||||||
| 29 | ||||||||
| 30 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe