MUFG
Finance/Accounting
Excel
100
True/False
Mitsubishi Bank was founded in 1880 by a former samurai
TRUE
100
When does Fiscal year 2020 start?
April 1st 2020
100
This button 
represents
The AutoSum button
200
True or False
MUFG's vision is to be the world's most profitable financial group.
FALSE: MUFG's vision is to be the world's most trusted financial group.
200
Which basis of accounting best measures profitability during a short time interval?
Accrual basis
200
Which filename extension is used for Excel workbooks?
.xls
300
What are MUFG's logo colors?
Red and Gray
300
What does 6+6 forecast mean?
Six months actuals/ Six months forecast
300
If you have first names in one column and last names in another column, which function can you use to easily put both together as the full name in a third column?
CONCATENATE
400
MUFG owns approximately 20% of______________(major US bank) making it its biggest shareholder.
MUFG owns just under 22% of Morgan Stanley (JP Morgan) making it the most concentrated owner of any bank in America
400
Bank makes significant purchase to be used for more than one year. Should business expense or capitalize
Capitalize
400
Which of these statements on Vlookup() is false?
A: The Vlookup function can be used to compare a value that's between two values or for an exact value.
B: When this function is used to find a value between , you must always place the smallest possible value first in the first column.
C: The values of the first column must be in descending order.
D: With this function, the comparison table is always read vertically.
C: The values of the first column must be in descending order
500
List MUFG's core values
Integrity
Respect
Service
Collaboration
Inclusion
Stewardship
500
Is it acceptable that some of the expenses reported on the income statement be estimates?
Yes- Depreciation Expense is an example of a significant expense that is an estimate.
500
What is the keyboard shortcut to add filters to a row?
ctrl+shift++L