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. Show all Precedents






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






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






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






5. Go to Formulas






6. Go to Constants






7. Show all Dependents






8. Go to precedent cells






9. Erase Traces






10. Trace immediate dependents






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






12. Conditional Sum






13. Record Macros






14. Track changes






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






16. Use Relative References






17. Enter Built-In Formula






18. Multiply/Sum Range






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






20. Highlight Dependents






21. Add/Edit Comment






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






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






24. Select From List






25. Zoom to selection






26. Trace immediate precedents






27. Insert AutoSum formula






28. Refresh Worksheet / Calculate Formulas






29. View Macros






30. Absolute Value






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






32. Move # of Rows/Columns






33. Enter Formula






34. Validate Data






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






36. Sum Adjacent Cells






37. Average






38. Copy Formula Right






39. Trace all precedents (indirect)






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






41. Find Based on Row






42. Delete Comment






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






44. Go to dependent cells






45. Count Number of Entries






46. Minimum






47. Maximum






48. Jump Back to Original Cell






49. Displays the date in a variety of formats.






50. Create Data Table