Explore all topics
Start Free Trial
Need Help? Contact us
back arrowfull exam logo
search
ai logoChat with AI
Servicesarrow
Discoverarrow

Topics

Explore all topics
Discover more topics

Exam 7: Specialized Functions

arrow
Exam 1: Introduction to Excel100 Questionsadd course
Exam 2: Formulas and Functions100 Questionsadd course
Exam 3: Charts100 Questionsadd course
Exam 4: Datasets and Tables100 Questionsadd course
Exam 5: Subtotals, Pivot-tables, and Pivot-charts100 Questionsadd course
Exam 6: What-If Analysis100 Questionsadd course
Exam 7: Specialized Functions100 Questionsadd course
Exam 8: Statistical Functions100 Questionsadd course
Exam 9: Multiple-Sheet Workbook Management98 Questionsadd course
Exam 10: Imports, xml, and Power Add-Ins95 Questionsadd course
Exam 11: Collaboration and Workbook Distribution96 Questionsadd course
Exam 12: Templates, styles, and Macros97 Questionsadd course
Exam 13: Office 2016 Common Features100 Questionsadd course
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags
Match each of the following terms with its best conceptual description:
Premises:
Responses:
NOT
Use the results of one function as an argument in another
IF
All conditions must be met for a true return
OR
Tests conditions to process decisions
Correct Answer:
Verified
Premises:
Responses:
NOT
Use the results of one function as an argument in another
IF
All conditions must be met for a true return
OR
Tests conditions to process decisions
Nested Function
False = true
AND
At least one condition must be met for a true return
(Matching)
4.9/5
(80)
Question 61

The criteria range must contain ________ at least rows in Advanced Filtering.

(Short Answer)
4.9/5
(78)
Question 62

What is the match_type argument value for an exact match in a MATCH function?

(Short Answer)
4.9/5
(75)
Question 63

An INDEX function returns the position of a value.

(True/False)
4.9/5
(88)
Question 64

The ________ function calculates the total number of periods in a loan.

(Short Answer)
4.9/5
(63)
Question 65

The formula = ________ (10/15/2018,2)would return 12/15/2018.

(Short Answer)
4.9/5
(82)
Question 66

4)If there are 5 possible outcomes,how many logical tests are required?

(Multiple Choice)
4.9/5
(74)
Question 67

IF you use the function,=MATCH(66,A1: A4,0),on the table below,what would be the result? IF you use the function,=MATCH(66,A1: A4,0),on the table below,what would be the result?

(Multiple Choice)
4.9/5
(85)
Question 68
Match each of the following functions to its best description:
Premises:
Responses:
NPV
Calculates the periodic rate for an investment or loan given the number of payment periods,a fixed periodic payment,and present value.
RATE
Calculates the number of payment periods for an investment or loan given a fixed interest Rate,periodic payment,and present value.
PV
Calculates the future value of an investment,given a fixed interest rate,term,and periodic payment
Correct Answer:
Verified
Premises:
Responses:
NPV
Calculates the periodic rate for an investment or loan given the number of payment periods,a fixed periodic payment,and present value.
RATE
Calculates the number of payment periods for an investment or loan given a fixed interest Rate,periodic payment,and present value.
PV
Calculates the future value of an investment,given a fixed interest rate,term,and periodic payment
FV
Calculates the net present value of an investment,given a fixed rate (rate of return)and futurepayments that may be identical or different.
NPER
Calculates the total present (current)value of an investment with a fixed rate,specified number of payment periods,and a series of identical payments that will be made in the future.
(Matching)
4.8/5
(82)
Question 69

The RATE function returns the periodic rate for an investment or loan.

(True/False)
4.8/5
(82)
Question 70

Which of these is not a capability of the Advanced Filter tool?

(Multiple Choice)
5.0/5
(90)
Question 71

Which function would calculate a final value of an investment of $250 per month for 5 years at 4% interest?

(Multiple Choice)
4.8/5
(76)
Question 72

The ________ function calculates the total future value.

(Short Answer)
4.8/5
(75)
Question 73

What is the first argument of an IF function?

(Multiple Choice)
4.8/5
(75)
Question 74

The ________ database function will add the values on a specified criteria range.

(Short Answer)
4.9/5
(81)
Question 75
Match each of the following nested functions to its correct return based on this table:
Match each of the following nested functions to its correct return based on this table:
Premises:
Responses:
in D3 =IF(AND(B2="Blue":(NOT(B3="Green"):A2:"else")
Phone
in D2 =IF(OR(B2="Blue":B2="Red"):A2:"else")
Flower
in D4 =IF(OR(B4="Blue":B4="Red"):A4:"else")
Else
Correct Answer:
Verified
Premises:
Responses:
in D3 =IF(AND(B2="Blue":(NOT(B3="Green"):A2:"else")
Phone
in D2 =IF(OR(B2="Blue":B2="Red"):A2:"else")
Flower
in D4 =IF(OR(B4="Blue":B4="Red"):A4:"else")
Else
in D3=IF(AND(B3="Blue":B3="Red"):A3:A4)
Car
in D4=IF(NOT(B4="Blue"):A3:A4)
An error
(Matching)
4.9/5
(70)
Question 76

Which is not an argument in an INDEX function?

(Multiple Choice)
4.9/5
(87)
Question 77

A Truth Table is a matrix that provides true or false for every possible combination for an OR,NOT,or AND criteria combination.

(True/False)
4.9/5
(77)
Question 78

Which database function returns the lowest value from the dataset based on your criteria?

(Multiple Choice)
4.8/5
(70)
Question 79

The ________ function calculates the periodic interest rate of a loan or investment.

(Short Answer)
4.8/5
(72)
Question 80
Showing 61 - 80 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)