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. Find Based on Column






2. Delete Comment






3. Copy formula from above cell


4. Paste Formats & Formulas






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






6. Jump Back to Original Cell






7. Create Pivot Table






8. Enter Formula






9. Go to Formulas






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






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






12. Trace immediate precedents






13. Anchor Cell






14. Highlight Precedents






15. Sum Adjacent Cells






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






17. View Macros






18. A model used to investigate dynamic behavior






19. Minimum






20. Maximum






21. Absolute Value






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






23. Enter Built-In Formula






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






25. Show Formulas






26. Trace Precedents






27. Highlight Dependents






28. Advanced Data Filter






29. Move # of Rows/Columns






30. At Least 1 Must Be True






31. Copy Formula Down






32. Go to precedent cells






33. Recalculate all workbooks






34. Conditional






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






36. Add/Edit Comment






37. Trace all precedents (indirect)






38. Conditional Sum






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






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






41. Record Macros






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






43. Trace all dependents (indirect)






44. Use Relative References






45. Copy value from above cell






46. All Must Be True






47. Displays the natural logarithm of a number. For example - =LN(50) will display 1.69897.






48. Erase Traces






49. Select From List






50. Show formulas/values