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






2. Go to precedent cells






3. Maximum






4. Anchor Cell






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






6. Paste Formats & Formulas






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






8. Go to Constants






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






10. Go to Formulas






11. Trace immediate precedents






12. Show all Dependents






13. Copy Formula Down






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






15. Jump Back to Original Cell






16. Absolute Value






17. Trace all precedents (indirect)






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






19. Show Formulas






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






21. All Must Be True






22. Find Based on Row






23. Trace all dependents (indirect)






24. Select From List






25. Conditional






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






27. Advanced Data Filter






28. Copy Formula Right






29. Create Pivot Table






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






31. View Macros






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






33. Minimum






34. Add/Edit Comment






35. Trace Precedents






36. Go to Formulas






37. Highlight Dependents






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






39. Move # of Rows/Columns






40. Find Item's Position






41. Zoom to selection






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






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






44. Paste Link






45. Show all Precedents






46. Refresh Worksheet / Calculate Formulas






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






48. Show formulas/values






49. Find Based on Column






50. Copy value from above cell