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






3. Remove tracing arrows






4. Evaluate formula






5. Create Pivot Table






6. Sum Numbers






7. Create Data Table






8. Show all Dependents






9. Conditional Count






10. Highlight Dependents






11. Delete Comment






12. Track changes






13. Recalculate all workbooks






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






15. Trace Precedents






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






17. Trace Dependents






18. Copy formula from above cell


19. Conditional






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






21. Find Based on Column






22. Go to dependent cells






23. Average






24. Go to Constants






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






26. Trace immediate dependents






27. A model used to investigate dynamic behavior






28. Sum Adjacent Cells






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






30. Validate Data






31. Jump Back to Original Cell






32. Zoom to selection






33. Displays the date in a variety of formats.






34. Find Item






35. Copy value from above cell






36. Maximum






37. Find Based on Row






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






39. Erase Traces






40. Trace immediate precedents






41. Show Formulas






42. Conditional Sum






43. Insert AutoSum formula






44. Use Relative References






45. Multiply/Sum Range






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






47. Minimum






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






49. Copy Formula Right






50. Show all Precedents