Wall Street Prep; Excel Crash Course Formulas Exam With 100% Correct And Verified Answers
2 views 0 purchase
Course
Excel Crash Course
Institution
Excel Crash Course
Wall Street Prep; Excel Crash Course Formulas Exam With 100% Correct And Verified Answers
Average Function - Correct Answer-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 - Correct Answer-Definit...
Wall Street Prep; Excel Crash Course
Formulas Exam With 100% Correct And
Verified Answers
Average Function - Correct Answer-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 - Correct Answer-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 - Correct Answer-Definition: IF
function with various IF functions within each other.
IFS Statement/Function - Correct Answer-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 - Correct Answer-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 - Correct Answer-A function that concatenates cells
with a text string.
EOMONTH Function - Correct Answer-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 - Correct Answer-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 - Correct Answer-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 - Correct Answer-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 - Correct Answer-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.
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 Vendarsol. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
