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. Copy Formula Down






2. At Least 1 Must Be True






3. Maximum






4. A model used to investigate dynamic behavior






5. Create Pivot Table






6. Evaluate formula






7. Highlight Precedents






8. Select From List






9. Insert AutoSum formula






10. Enter Formula






11. Multiply/Sum Range






12. Absolute Value






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






14. Jump Back to Original Cell






15. Find Based on Row






16. All Must Be True






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






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






19. Find Item






20. Conditional






21. Add/Edit Comment






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






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






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






25. Trace Precedents






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






27. Validate Data






28. Paste Link






29. View Macros






30. Trace immediate precedents






31. Recalculate all workbooks






32. Go to dependent cells






33. Conditional Sum






34. Conditional Count






35. Find Based on Column






36. Show all Precedents






37. Show Formulas






38. Copy formula from above cell


39. Displays the date in a variety of formats.






40. Erase Traces






41. Go to Constants






42. Find Item's Position






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






44. Trace all precedents (indirect)






45. Enter Built-In Formula






46. Displays the maximum or largest of the range identified in the argument. For example - =MAX(E4:E9) displays the maximum or largest of the numbers contained in the range E4:E9.






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






48. Track changes






49. Go to Formulas






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