Matching
Match the example by replacing the “____” with the proper function:
Premises:
=“____” (12%/12,360,-120000)
=“____” (B7>9,"Bigger","Smaller")
=“____” (B9:E21)
=“____” (A4,B4:F9,2)
=“____” ()
Responses:
VLOOKUP
NOW
SUM
IF
PMT
Correct Answer:
Premises:
Responses:
=“____” (12%/12,360,-120000)
=“____” (B7>9,"Bigger","Smaller")
=“____” (B9:E21)
=“____” (A4,B4:F9,2)
=“____” ()
Premises:
=“____” (12%/12,360,-120000)
=“____” (B7>9,"Bigger","Smaller")
=“____” (B9:E21)
=“____” (A4,B4:F9,2)
=“____” ()
Responses:
Related Questions
Q4: In the PMT function, the PV argument
Q9: The _ is the lowest value for
Q10: The range that contains the lookup table
Q13: If you will never copy and paste
Q16: What does the AVERAGE function not ignore?<br>A)Text<br>B)Empty
Q24: Match the following terms with their description:
Q27: If you wanted to reference a cell
Q42: The test argument in an IF statement
Q75: Which keyboard shortcut toggles through the types
Q91: The _ feature in Excel displays various