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. Count Number of Entries






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






3. Anchor Cell






4. Highlight Dependents






5. Evaluate formula






6. Use Relative References






7. Minimum






8. Paste Formats & Formulas






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






10. Go to Constants






11. Jump Back to Original Cell






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






13. View Macros






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






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






16. Sum Numbers






17. Multiply/Sum Range






18. Maximum






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






20. A model used to investigate dynamic behavior






21. Create Data Table






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






23. Add/Edit Comment






24. Copy Formula Right






25. Find Item






26. Find Based on Column






27. Average






28. Conditional






29. Sum Adjacent Cells






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






31. Show formulas/values






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






33. Trace all dependents (indirect)






34. Trace Dependents






35. Erase Traces






36. Highlight Precedents






37. All Must Be True






38. Validate Data






39. At Least 1 Must Be True






40. Refresh Worksheet / Calculate Formulas






41. Go to Formulas






42. Highlight Comments






43. Move # of Rows/Columns






44. Go to dependent cells






45. Displays the maximum or largest of the range identified in the argument. For example - =MAX(E4:E9) displays the maximum or largest of the numbers contained in the range E4:E9.






46. Paste Link






47. Go to Formulas






48. Recalculate all workbooks






49. Go to precedent cells






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






?:?:)

Search BasicVersity Tests



OR

Browse BasicVersity