100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
WALL STREET PREP; EXCEL CRASH COURSE FORMULAS EXAM QUESTIONS EXPLAINED CA$12.33   Add to cart
Quickly navigate to
Preview
  2.  
  3. WALL STREET PREP
  4.  
  5. WALL STREET PREP

Exam (elaborations)

WALL STREET PREP; EXCEL CRASH COURSE FORMULAS EXAM QUESTIONS EXPLAINED
 9 views  0 purchase
  • Course
  • WALL STREET PREP
  • Institution
  • WALL STREET PREP

WALL STREET PREP; EXCEL CRASH COURSE FORMULAS EXAM QUESTIONS EXPLAINED Average Function Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function Definition: A function that returns one value when a cond...

[Show more]

Preview 2 out of 8  pages

Document information

  • April 18, 2024
  • 8
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • wall street prep excel crash course formulas exam

Written for

  • WALL STREET PREP
All documents for this subject (909)

Seller

avatar-seller
NurseAdvocate

Reviews received

Content preview

WALL STREET PREP; EXCEL CRASH COURSE
FORMULAS EXAM QUESTIONS EXPLAINED

Average Function
Definition: An Excel function that adds a group of values, and then divides the result by
the number of values in the group.
IF Statement Function
Definition: A function that returns one value when a condition you specify evaluates to
true and a different value if it evaluates to false.
Explanation: First you begin with the logical test for the function, and then provide the
value the function should output if the logical test is evaluated to true, and last value the
function should output if the logical test is evaluated to false.
Nested IF Statement Function
Definition: IF function with various IF functions within each other.
IFS Statement/Function
Definition: A function that resolves the chunkiness of IF statements/functions and
Nested IF statements/functions. Can allow for more than one IF statement all in one.
IFERROR Function
Definition: A function that returns a value you specify if the formula evaluates to an
error. If the formula does not result in an error, this function will return the result of the
formula.
Explanation: Begin by putting the value you want to see if an error is evaluated by this
value, example: something divided by 0. Then input what the function should output if
this is truly an error.
& Function
A function that concatenates cells with a text string.
EOMONTH Function

, Definition: A function that allows you to create monthly date headers. By outputting the
last day of the specified month.
Explanation: Start by inputting the start_date into the first argument. Then input how
many months ahead or behind you would like to go from that start_date.
EDATE Function
Definition: Similar to EOMONTH but this return the exact date from the start-date, after
the specified number of months.
Explanation: Start by inputting the start_date into the first argument. Then input how
many months ahead or behind you would like to go from that start_date.
ISNUMBER Function
Definition: A function that is useful criteria in IF Statements/Functions, and it is basically
test to see if a cell has a number in it.
Explanation: Simply input value to check to see if value inputted comes out to true or
false.
ISTEXT Function
Definition: A function that evaluates if there is text inside a cell and will output TRUE or
FALSE depending on the result. Also a useful criteria to add to IF statements/functions.
Explanation: Simply input value to check to see if value inputted comes out to true or
false.
YEARFRAC Function
Definition: A function that return the proportion of the year between two given dates, the
start_date and the end_date. An optional basis parameter can be used do represent the
number of days per month/year used to calculate the proportion of the year.
Optional Basis Parameters:
1. 0 - or Omitted = U.S. 30/360
2. 1 - Actual/Actual
3. 2 - Actual/360
4. 3 - Actual/365
5. 4 - European 30/360
Explanation: Simply input the start_date and the end_date with the desired basis

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller NurseAdvocate. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for CA$12.33. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

77254 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling

Recently viewed by you

Exam (elaborations) ·

(0)

NSG 552 Exam 3 Practice Questions and Correct Answers

Exam (elaborations) ·

(0)

Arthrex Exam Questions with complete solution 2024

CA$12.33
  • (0)
  Add to cart