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






2. Delete Comment






3. Trace all dependents (indirect)






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






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






6. Erase Traces






7. Maximum






8. Highlight Comments






9. Go to Constants






10. Create Pivot Table






11. Refresh Worksheet / Calculate Formulas






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






13. Find Based on Column






14. Average






15. A model used to investigate dynamic behavior






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






17. Select From List






18. Zoom to selection






19. Trace all precedents (indirect)






20. Find Item's Position






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






22. Sum Adjacent Cells






23. Record Macros






24. Conditional Count






25. Absolute Value






26. Conditional






27. Use Relative References






28. Validate Data






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






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






31. Remove tracing arrows






32. Add/Edit Comment






33. Enter Formula






34. Track changes






35. Insert AutoSum formula






36. Paste Formats & Formulas






37. Conditional Sum






38. Trace Precedents






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






40. Find Item






41. Copy Formula Right






42. Trace Dependents






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






44. Anchor Cell






45. At Least 1 Must Be True






46. Show all Precedents






47. Sum Numbers






48. Advanced Data Filter






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






50. Find Based on Row