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. Go to Formulas






2. Highlight Comments






3. Paste Formats & Formulas






4. Go to dependent cells






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






6. Zoom to selection






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






8. Jump Back to Original Cell






9. Count Number of Entries






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






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






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






13. Evaluate formula






14. Trace immediate dependents






15. Create Data Table






16. Displays the variance for the numbers contained in the range of the argument.






17. A model used to investigate dynamic behavior






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






19. Copy formula from above cell


20. Copy value from above cell






21. Enter Built-In Formula






22. Trace all dependents (indirect)






23. Find Based on Column






24. Conditional Count






25. Trace Dependents






26. Go to Formulas






27. Anchor Cell






28. Sum Numbers






29. Add/Edit Comment






30. Trace immediate precedents






31. Highlight Dependents






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






33. Displays the current date or time based on the computer's clock.






34. All Must Be True






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






36. Insert AutoSum formula






37. Delete Comment






38. Conditional






39. Show formulas/values






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






41. Go to Constants






42. Show Formulas






43. Trace Precedents






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






45. View Macros






46. Move # of Rows/Columns






47. Show all Precedents






48. Track changes






49. Record Macros






50. Multiply/Sum Range