This class was created by Brainscape user Host Mom. Visit their profile to learn more about the creator.
By:
Host Mom
- decks
- flashcards
- learners
Decks in this class (24)
Formatting
Converts to excel defaultcell format,
Converts to comma two decimal format,
Converts to date dd mmm yy format
28
cards
Navigation & Selection
Switch between applications,
Switch between open excel workbooks,
Go to previous worksheet
13
cards
Editing / Formulas
Inserts a new worksheet,
Inserts new cell s row s column s,
Deletes cell s row s column s
19
cards
Auditing
Toggle between normal display and...,
On same sheet selects cells direc...,
On same sheet selects cells direc...
8
cards
Cheats
What are the 5 functions in excel,
What is the pmt formula,
How do you calculate pmt manually
3
cards
Formulas
Return on equity,
Financial leverage,
Return on assets roa
17
cards
Excel shortcuts Function->KeyStroke
Move one screen to the right to t...,
Move to the edge of next data reg...,
Move to the beginning of a row in...
113
cards
Chapter 1 - Applying Fundamental Excel Skills and Tools in Problems Solving
What are the 2 main types of errors,
Which type of error occurs when y...,
Which type of error occurs when t...
32
cards
Chapter 2 - Solving Problems with Statistical Analysis Tools
What is the arithmetic average of...,
What is the value in the middle,
Which statistics fundamental occu...
35
cards
Chapter 3 - Determining Effective Data Display with Charts
List 5 data graphic principles,
What refers to the portion of ink...,
What are small word sized charts ...
18
cards
Chapter 4 - Decision Logic
What is the key to statements,
True or false some condition must...,
What is the format of the if formula
12
cards
Chapter 5 - Retrieving Data for Computation, Analysis, and Reference
What contain data that can be use...,
What is the most effective and fl...,
Which function searches a specifi...
57
cards
Linear Regression
What does a slope of 2 mean,
What is the formula to find the s...,
What is the formula to find linear
38
cards
Chapter 6 - Evaluating Financial Impact
What is it called when we add int...,
Does compound or simple interest ...,
What is used by most financial in...
30
cards
Chapter 7 - Organizing Big Data
List the 2 formats that can be im...,
List 4 examples of databases that...,
What is an example of the text da...
13
cards
Chapter 8 - What-If Analysis
What asks a what if question invo...,
What performs many calculations a...,
What runs a simulation with a two...
27
cards
Chapter 9 - Solver
What determines the optimal set o...,
What is an excellent tool for det...,
Is the solver more powerful than ...
15
cards
Section 3: Excel Environment
What is line up break and its sho...,
What is short key for quick move ...,
What is short key for quick move ...
17
cards
Section 4: Excel Environment Summary
What is special select,
What is the process for special s...,
Where is macro
16
cards
Section 5: Formulas Summary
Functions vocabulary list,
What are arguments for sum if,
What is the difference between su...
29
cards
Section 6-P&L from Scratch
What is p l,
What elements are inside data sou...,
What is the process of ordering s...
39
cards
Formulas COPY
Return on equity,
Financial leverage,
Return on assets roa
17
cards
Mod 1 Professional Responsibilities
1 under the ethical standards of ...,
2 under the ethical standards of ...,
3which of the following actions s...
119
cards
Mod 2 Engagement Planning MCQs
1 during the audit of a new clien...,
2 in developing an overall audit ...,
3 an auditor intends to use the w...
104
cards
More about
excel 101 - financial modeling & other bs
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Host Mom's Excel 101 - Financial Modeling & Other BS flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
Financial Modeling
- 4 decks
- 26 flashcards
- 1 learners
Decks:
Income Statement, Balance Sheet Projections, Discounted Cashflow, And more!
Random BS
- 15 decks
- 393 flashcards
- 14 learners
Decks:
Rollcall Entries Abbreviations, Receipt Of Alarm Signals Abbreviations, Flagging Column Abbreviations, And more!
5th Grade EXCEL
- 4 decks
- 28 flashcards
- 17 learners
Decks:
Explorers And Native American Tribes Que, Explorers And Native Americans Tribes Qu, Explorers And Native American Tribes Que, And more!
