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. Used for basic calculations - stored by the excel document within specific cells or across different ranges of cells






2. Copy Formula Down






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






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






5. Trace immediate dependents






6. Conditional






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






8. Find Item's Position






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






10. Create Data Table






11. Move # of Rows/Columns






12. Trace all precedents (indirect)






13. Enter Built-In Formula






14. Evaluate formula






15. Show Formulas






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






17. Anchor Cell






18. Go to Formulas






19. Highlight Comments






20. Add/Edit Comment






21. Maximum






22. Track changes






23. Count Number of Entries






24. Show all Precedents






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






26. Go to dependent cells






27. Select From List






28. Use Relative References






29. Recalculate all workbooks






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






31. Show formulas/values






32. Delete Comment






33. Enter Formula






34. Insert AutoSum formula






35. Refresh Worksheet / Calculate Formulas






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






37. Remove tracing arrows






38. Paste Formats & Formulas






39. Conditional Count






40. Sum Adjacent Cells






41. Highlight Dependents






42. A model used to investigate dynamic behavior






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. Jump Back to Original Cell






45. Copy formula from above cell


46. Find Based on Row






47. Absolute Value






48. Find Based on Column






49. Create Pivot Table






50. Multiply/Sum Range