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. Specify one input cell and any number of result cells - often used to explore how altering one value can impact several result cell






2. Highlight Precedents






3. Trace immediate dependents






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






5. Conditional Count






6. Sum Adjacent Cells






7. Go to Formulas






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






9. Paste Link






10. Anchor Cell






11. Find Based on Row






12. Find Item






13. Minimum






14. Show formulas/values






15. Trace immediate precedents






16. Refresh Worksheet / Calculate Formulas






17. Go to precedent cells






18. Track changes






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






20. Trace Dependents






21. Go to Formulas






22. Paste Formats & Formulas






23. Find Based on Column






24. Insert AutoSum formula






25. Delete Comment






26. Go to dependent cells






27. Show all Dependents






28. Show Formulas






29. Copy formula from above cell


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






31. Highlight Comments






32. A model used to investigate dynamic behavior






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






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






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






36. Move # of Rows/Columns






37. Erase Traces






38. Show all Precedents






39. Copy Formula Down






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






41. Evaluate formula






42. Copy Formula Right






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






44. Jump Back to Original Cell






45. Zoom to selection






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






47. Count Number of Entries






48. Multiply/Sum Range






49. Maximum






50. Copy value from above cell