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. Recalculate all workbooks






2. Paste Formats & Formulas






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






4. Copy Formula Down






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






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






7. Zoom to selection






8. Sum Numbers






9. Trace all precedents (indirect)






10. Copy formula from above cell


11. Trace Dependents






12. Copy Formula Right






13. Record Macros






14. Evaluate formula






15. Go to Constants






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






17. Enter Formula






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






19. Highlight Comments






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






21. Trace Precedents






22. Multiply/Sum Range






23. Conditional Count






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






25. Show all Dependents






26. Validate Data






27. Create Data Table






28. Maximum






29. Insert AutoSum formula






30. Go to Formulas






31. Trace immediate dependents






32. Go to dependent cells






33. Advanced Data Filter






34. Use Relative References






35. Paste Link






36. Highlight Dependents






37. Copy value from above cell






38. Trace all dependents (indirect)






39. Remove tracing arrows






40. Find Item's Position






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






42. Trace immediate precedents






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






44. Highlight Precedents






45. Show Formulas






46. Go to Formulas






47. Absolute Value






48. Track changes






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






50. Find Item