Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,160,411 members, 7,843,223 topics. Date: Tuesday, 28 May 2024 at 09:00 PM

Excel Quiz - Education - Nairaland

Nairaland Forum / Nairaland / General / Education / Excel Quiz (297 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)

(1) (Reply) (Go Down)

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:
#ExcelQuiz
===============
Which bank was most generous giving out the highest loan? GTBANK, ECOBANK or ZENITH?

#Excel #HR #Banking
GTBANK
Re: Excel Quiz by Mist100: 8:57am On May 21, 2022
matex97:
GTBANK

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:

Did you just count or you applied a function.
The rows could be as much as 700,000.
Will share original data set soon.
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:
#ExcelQuiz
===============
Which bank was most generous giving out the highest loan? GTBANK, ECOBANK or ZENITH?

#Excel #HR #Banking
Simple use Pivot table
alt N V

Drag Bank name to row.
Then amount to value..
Very simple calculation

(1) (Reply)

Did You Know Fire Has No Shadow / Upfront Medical / FG - ASUU STRIKE Not Simple As Nigerian Think

(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. 13
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.