Please answer all questions: 1.)If cell E15 contains the formula =$C$5*J$15, wha
ID: 3790498 • Letter: P
Question
Please answer all questions:
1.)If cell E15 contains the formula =$C$5*J$15, what type of cell reference is j$15 in the formula?
a. syntax
b. mixed reference
c. absolute reference
2.Which of the following functions should be used to insert that current date and time in a cell?
a.=DATE
b.=NOW()
C.=CURRENT()
3.which of the following is not true about the VLOOKUP function
a.the match type must be false when completing an exact match
b.the lookup must be in descending order
c. the lookup must be in ascending order
4.the function =PMT(C5,C7-C3) is stored in cell c15. What must be stored in cell c5?
a. number of payment periods
b.APR
c. periodic interest rate
Explanation / Answer
1) answer B. mixed reference
Explanation:A mixed cell reference is either an absolute column and relative row or absolute row and relative column
2) Answer B. =NOW() it gives current date and time
3) Answer A --the match type must be false when completing an exact match
Explanation: If the function cannot find an exact match to the supplied lookup_value, it should return an error.
4) answer C.periodic interest rate
Explanation: =PMT(rate,nper,pv,[fv],[type]) this is the syntax of the PMT formula