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. Erase Traces






2. Find Item






3. Anchor Cell






4. View Macros






5. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell






6. Show all Dependents






7. Multiply/Sum Range






8. Find Item's Position






9. Show formulas/values






10. Zoom to selection






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






12. Show Formulas






13. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells






14. 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.






15. Show all Precedents






16. Paste Formats & Formulas






17. Trace immediate dependents






18. Highlight Comments






19. Paste Link






20. Copy Formula Right






21. Go to Formulas






22. Count Number of Entries






23. Trace Precedents






24. 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.






25. Sum Adjacent Cells






26. Insert AutoSum formula






27. Displays the standard deviation of the numbers contained in the range of the argument.






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






29. Enter Built-In Formula






30. All Must Be True






31. Find Based on Row






32. Conditional Sum






33. Minimum






34. Sum Numbers






35. Delete Comment






36. Validate Data






37. Displays the average of the range identified in the argument. For example - =AVERAGE(E4:E9) displays the average of the numbers contained in the range E4:E9.






38. Trace immediate precedents






39. Average






40. Displays the date in a variety of formats.






41. Copy value from above cell






42. Copy formula from above cell


43. 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.






44. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.






45. Maximum






46. Track changes






47. Select From List






48. Go to Constants






49. Uses two input cells - but only the value of a single result cell can be displayed. Used to explore the impact of changing two values on a single result






50. Trace all dependents (indirect)