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






2. Show all Precedents






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






4. Anchor Cell






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






6. Trace all precedents (indirect)






7. Copy value from above cell






8. Refresh Worksheet / Calculate Formulas






9. Trace all dependents (indirect)






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






11. Select From List






12. Count Number of Entries






13. Trace immediate dependents






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






15. Validate Data






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






17. Conditional Count






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






19. Absolute Value






20. Use Relative References






21. Show Formulas






22. Show all Dependents






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






24. Highlight Precedents






25. Minimum






26. Evaluate formula






27. Move # of Rows/Columns






28. Delete Comment






29. Show formulas/values






30. Track changes






31. Highlight Comments






32. Create Data Table






33. View Macros






34. At Least 1 Must Be True






35. Create Pivot Table






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






37. Conditional Sum






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






39. Go to precedent cells






40. Find Item's Position






41. Insert AutoSum formula






42. Find Based on Column






43. Sum Adjacent Cells






44. Sum Numbers






45. Highlight Dependents






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






47. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.






48. Find Based on Row






49. A model used to investigate dynamic behavior






50. Copy Formula Down