Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,156,126 members, 7,829,013 topics. Date: Wednesday, 15 May 2024 at 05:32 PM |
Nairaland Forum / Nairaland / General / Education / Excel Quiz (294 Views)
2nd Edition Of The XFIRE Nairaland Scholarship Quiz-Final Test In Progress / Annual Xfire Nairaland Undergraduate Quiz Competition (scholarship)- 2nd Edition / TOBI M. OLUSA SCIENCE QUIZ Season1 Episode 1 =>win Airtime (2) (3) (4)
Excel Quiz by Mist100: 8:12am On May 20, 2022 |
#ExcelQuiz =============== Which bank was most generous giving out the highest loan? GTBANK, ECOBANK or ZENITH? #Excel #HR #Banking
|
Re: Excel Quiz by Nobody: 10:30am On May 20, 2022 |
Mist100:GTBANK |
Re: Excel Quiz by Mist100: 8:57am On May 21, 2022 |
matex97: Did you just count or you applied a function. The rows could be as much as 700,000. Will share original data set soon. |
Re: Excel Quiz by Nobody: 9:00am On May 21, 2022 |
Mist100:I just counted |
Re: Excel Quiz by sirqeeboi(m): 1:37pm On May 21, 2022 |
=sumif(F3:f13,f30,h3:h13) In box f30 input bank name and type this command baside will be g30 |
Re: Excel Quiz by greattybee(m): 8:44pm On May 21, 2022 |
Mist100:Simple use Pivot table alt N V Drag Bank name to row. Then amount to value.. Very simple calculation |
(1) (Reply)
Children Will Benefit From Playing Mathematical Games. / Zamfara Student On Scholarship In Cyprus Kicked Out Of School Over Unpaid Fees / Private Teachers Should Never Be Poor
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |