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. Trace all precedents (indirect)






2. Add/Edit Comment






3. Sum Adjacent Cells






4. Trace immediate dependents






5. At Least 1 Must Be True






6. Conditional






7. Record Macros






8. Evaluate formula






9. All Must Be True






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






11. Jump Back to Original Cell






12. Trace immediate precedents






13. Sum Numbers






14. A model used to investigate dynamic behavior






15. Find Based on Column






16. Create Data Table






17. Highlight Dependents






18. Show all Precedents






19. Refresh Worksheet / Calculate Formulas






20. Use Relative References






21. Trace all dependents (indirect)






22. Go to dependent cells






23. Conditional Count






24. Trace Precedents






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






26. Enter Built-In Formula






27. View Macros






28. Advanced Data Filter






29. Multiply/Sum Range






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






31. Copy formula from above cell


32. Select From List






33. Anchor Cell






34. Show all Dependents






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






36. Validate Data






37. Copy Formula Right






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






39. Move # of Rows/Columns






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






41. Zoom to selection






42. Find Item's Position






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






44. Go to Formulas






45. Paste Link






46. Recalculate all workbooks






47. Enter Formula






48. Maximum






49. Find Based on Row






50. Conditional Sum