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. Sum Adjacent Cells






2. Go to Formulas






3. Refresh Worksheet / Calculate Formulas






4. Conditional Count






5. Delete Comment






6. Go to Constants






7. Average






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






9. Evaluate formula






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






11. Trace all dependents (indirect)






12. Create Data Table






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






14. Trace all precedents (indirect)






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






16. Go to dependent cells






17. Paste Formats & Formulas






18. Erase Traces






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






20. Show formulas/values






21. Count Number of Entries






22. Enter Formula






23. A model used to investigate dynamic behavior






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






25. Find Based on Column






26. Jump Back to Original Cell






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






28. Conditional






29. Insert AutoSum formula






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






31. Highlight Comments






32. Enter Built-In Formula






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






34. Copy Formula Right






35. Paste Link






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






37. Multiply/Sum Range






38. Find Item's Position






39. Zoom to selection






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. Select From List






42. Go to Formulas






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. Find Item






45. Copy value from above cell






46. Create Pivot Table






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






48. Minimum






49. Anchor Cell






50. Remove tracing arrows