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. Move # of Rows/Columns






2. Create Data Table






3. Copy Formula Down






4. Absolute Value






5. Delete Comment






6. Count Number of Entries






7. Find Item






8. Copy value from above cell






9. Record Macros






10. Trace all precedents (indirect)






11. Remove tracing arrows






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






13. Highlight Dependents






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






15. Show Formulas






16. Maximum






17. Go to Formulas






18. Conditional






19. Trace immediate precedents






20. Copy Formula Right






21. Jump Back to Original Cell






22. Create Pivot Table






23. A model used to investigate dynamic behavior






24. Displays the date in a variety of formats.






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






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






27. Sum Numbers






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






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






30. Paste Formats & Formulas






31. Multiply/Sum Range






32. Find Based on Row






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






34. Trace immediate dependents






35. Go to dependent cells






36. Use Relative References






37. Erase Traces






38. Show all Precedents






39. Trace all dependents (indirect)






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






41. Evaluate formula






42. Show formulas/values






43. Go to Formulas






44. Trace Dependents






45. Enter Formula






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






48. Highlight Precedents






49. Average






50. Show all Dependents