Excel
Financial Statements
Investment Banking
General Trivia
100

What does the SUM function do

sum all the cells inputed

100

How many key financial statements are there?

3

100

Name a bulge bracket bank

GS etc.

100

Largest animal in the world

blue whale

200

True or False: It is possible to freeze the top row

True

200

What are the 3 key financial statements?

BS, CF, IS

200

Name a boutique bank

Lazard, etc

200

Who played Ken in Barbie

Ryan Gosling

300

How do you lock a cell

$

300

What does the income statement start with?

Revenue

300

What is the entry level position in bank?

Analyst

300

Smallest country in the world

Vatican

400
Describe vlookup

Allows for location of a cell from a group of data

400

Components of an income statement?

Rev-exp = income

400

Who is the CEO of Goldman Sachs

David Solomon

400

How much revenue did the Eras tour generate

1.04 billion

500

What is the keyboard shortcut to change font size?

Alt H Fs

500

What is the difference between depreciation and amortization?

amortization is for intangibles (patents, copyrite)

500

JP Morgan's share price as of yesterday

172.28

500

What is the capital city of Kuwait

Kuwait City