Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,160,555 members, 7,843,723 topics. Date: Wednesday, 29 May 2024 at 10:24 AM |
Nairaland Forum / Nairaland / General / Education / Excel Quiz (298 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)
ASUU Warm Fg We Are Not Beggars Uniupdates / Online Coaching For Competitive Exams / Upload Jamb Result On Your Jamb Profile
(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. 9 |