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 Formats & Formulas






2. Conditional Count






3. Select From List






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






5. Go to precedent cells






6. Conditional Sum






7. Minimum






8. Paste Link






9. Go to Constants






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






11. At Least 1 Must Be True






12. Recalculate all workbooks






13. Trace all dependents (indirect)






14. Show all Precedents






15. Displays the date in a variety of formats.






16. Count Number of Entries






17. Trace Precedents






18. Sum Adjacent Cells






19. A model used to investigate dynamic behavior






20. Erase Traces






21. Trace immediate dependents






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






23. Average






24. Insert AutoSum formula






25. Anchor Cell






26. Validate Data






27. Record Macros






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






29. Trace all precedents (indirect)






30. Conditional






31. Show all Dependents






32. Copy formula from above cell

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


33. Show formulas/values






34. Create Data Table






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






36. Advanced Data Filter






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






38. Go to Formulas






39. All Must Be True






40. Remove tracing arrows






41. Go to dependent cells






42. Trace immediate precedents






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






44. Trace Dependents






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






46. Find Item






47. Copy Formula Down






48. Zoom to selection






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






50. Track changes