7-8 Excel Exam Questions With Correct
Answers
An OR function evaluates to TRUE only if all of the conditions are true. - answerFalse
The YEARFRAC function returns the number of the month in a year. - answerFalse
Which function returns the relative position of a value? - answerMATCH
Why would y...
An OR function evaluates to TRUE only if all of the conditions are true. - answer✔✔False
The YEARFRAC function returns the number of the month in a year. - answer✔✔False
Which function returns the relative position of a value? - answer✔✔MATCH
Why would you nest MATCH in an INDEX function? - answer✔✔To use the position returned
in the Match function as an argument in the index function
Which of the following are not arguments for the IPMT function? - answer✔✔Collection
What is the first argument of an IF function? - answer✔✔Logical_test
A Truth Table is a matrix that provides true or false for every possible combination for an OR,
NOT, or AND criteria combination. - answer✔✔True
What effect does paying an extra small bit of principal on a mortgage have on the life of a 30
year loan? - answer✔✔It saves money in interest and shortens the length of the loan.
If you need to find out how many days between two dates, which function would you use? -
answer✔✔days
Which database function returns the lowest value from the dataset based on your criteria? -
answer✔✔dmin
An empty cell in the criteria in an Advanced Filter will display no records. - answer✔✔false
The MONTH function would return 25 when used on a cell containing August 25, 2018. -
answer✔✔false
NPER calculates the periodic interest rate of an investment or loan. - answer✔✔false
what is <> equivalent to in advanced filters - answer✔✔not equal to
The YEARFRAC calculates ________. - answer✔✔the fraction of a year in days between two
dates
, EXAM STUDY MATERIALS 8/7/2024 11:29 AM
The FREQUENCY function determines the strength of the relationship between two data sets. -
answer✔✔false
What is the Criteria2 argument of: - answer✔✔Black
What is the sum_range argument of: - answer✔✔C2:C64
Which of the following is not an argument in the PERCENTRANK.INC and
PERCENTRANK.EXC functions? - answer✔✔criteria
Inferential statistics and Descriptive statistics are the same thing. - answer✔✔false
The ________ function returns the variance of a sample of numerical data - answer✔✔VAR.S
STDEV.S calculates the standard deviation of a sample. - answer✔✔True
The FORECAST.ETS function returns a confidence interval for a forecast at all future dates. -
answer✔✔False
Which function returns the standard deviation of a population including logical values and text? -
answer✔✔STDEVPA
What would be the result of this formula:
=AVERAGEIF(A2:A64,"Green",C2:C64)? - answer✔✔An average of the values in the C
column when the values in the A column are Green
This is the first 4 lines of an excel list of 3082 records.
Which formula counts the number of Gold Level Members in the entire list? -
answer✔✔=COUNTIF(A2:A3083,"Gold")
________ is a measure of how two set of data vary simultaneously and is calculated by taking
the average of each product of the deviation of a data point. - answer✔✔Covariance
What is MS in an ANOVA summary report? - answer✔✔Mean of the sample squared
What are the two arguments for the FREQUENCY function? - answer✔✔data_array, bins_array
Which of the following is an allowable quart argument in a QUARTILE.EXC function? -
answer✔✔2
Which of the following is an Excel Add-in? - answer✔✔Analysis ToolPak
=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") - answer✔✔false
A(n) ________ is a dataset that contains a manageable subset of a population. -
answer✔✔sample
The benefits of buying summaries with Stuvia:
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
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 Brightstars. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.