Test your basic knowledge |

Microsoft Excel Functions Formulas Shortcuts

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.






2. Displays the number of cells with numerical values in the argument range. For example - =COUNT(D6:D21) displays 16 if all the cells are filled.






3. Select From List






4. Copy formula from above cell


5. Count Number of Entries






6. Remove tracing arrows






7. Paste Formats & Formulas






8. Go to dependent cells






9. Trace Dependents






10. Delete Comment






11. Enter Built-In Formula






12. Insert AutoSum formula






13. Trace immediate precedents






14. Evaluate formula






15. Displays the sum of cells with numerical values in the argument range. For example - =SUM(D6:D21) displays the total added together if all the cells are filled.






16. Find Based on Row






17. Record Macros






18. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.






19. Conditional Count






20. Create Data Table






21. Displays the square root of the number identified in the argument. For example =SQRT(C4) will display the square root of the value in C4.






22. Show formulas/values






23. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.






24. Find Based on Column






25. Advanced Data Filter






26. Go to Constants






27. Conditional






28. Refresh Worksheet / Calculate Formulas






29. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.






30. Maximum






31. Trace all dependents (indirect)






32. Sum Numbers






33. Paste Link






34. Zoom to selection






35. Show Formulas






36. Go to precedent cells






37. Copy value from above cell






38. Conditional Sum






39. Move # of Rows/Columns






40. View Macros






41. Displays the future value of a series of equal payments at a fixed rate for a specified number of periods.






42. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.






43. Add/Edit Comment






44. Copy Formula Right






45. Displays the date in a variety of formats.






46. Displays the minimum or smallest of the range identified in the argument. For example - =MIN(E4:E9) displays the minimum or smallest of the numbers contained in the range E4:E9.






47. Go to Formulas






48. All Must Be True






49. Track changes






50. Ranges that do not have a $ before the column portion of the reference.