Q31. Which formula is used to find EMI ( Every Month Installment ) ? =pmt() =ipmt() =ppmt() none of the aboveQ32. What is the short key of Cut? Ctrl + C Ctrl + X Ctrl + F Ctrl + OQ33. What is the short key of Find? Ctrl + Z Ctrl + F Ctrl + H Ctrl + RQ34. What is the short key of replace? Ctrl + Z Ctrl + H Ctrl + R Ctrl + AQ35. ................is a method to find a specific value for a cell by adjusting the value of one other cell. Goal Seek Scenarios Filter CustomizeQ36. Which area in an Excel window allows entering values and formulas? Title Bar Menu Bar Formula Bar Standard Tool BarQ37. =FACT(5) Function returns? 5 15 120 25Q38. Alt + = shortcut key used for .............. Auto Correct Autofit AutoSum AutoTextQ39. What is the shortcut key of spelling check? F7 F8 F9 shift+F7Q40. = SQRT (49) function returns.... 7 14 48 28

Q31. Which formula is used to find EMI ( Every Month Installment ) ? =pmt() =ipmt() =ppmt() none of the above

Which of the following formula can be used to calculate the interest amount in EMI*PMTIPMTPPMTInterest

In a certain code “MATHEMATICS” is coded as “OXVEGJCQKZU”, then what is the code for “EMISSION”?

Which of the following formula can be used to calculate the amount in EMI*EMIPMTAnnuityNone of above

Rene is deciding whether to buy a new car to replace her old car. She pays about $300 to repair her old car every 6 months. She found a new car that costs $4,250. She needs to find her monthly payment if she pays $3,000 initially and uses a 4 year loan with an APR of 4.25% for the rest of the cost of the new car.Rene knows the following two commands in Microsoft Excel:PMT(rate, nper, PV, FV)FV(rate, nper, pmt, PV)Which of the following should Rene use to find her monthly payment?Group of answer choices=FV(0.0425/12,4,4250)=PMT(4.25/12,4,3000)=PMT(0.0425/12,4*12,1250)=PMT(0.0425,4*12,1250)=FV(4.25/12,12,4250)