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. Go to precedent cells






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






3. Create Pivot Table






4. Highlight Precedents






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






6. Highlight Comments






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






8. Insert AutoSum formula






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






10. Add/Edit Comment






11. Conditional Sum






12. Trace immediate dependents






13. Track changes






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






15. Show Formulas






16. Paste Formats & Formulas






17. Validate Data






18. Refresh Worksheet / Calculate Formulas






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






20. Average






21. Show all Dependents






22. Sum Adjacent Cells






23. Trace Dependents






24. Trace all precedents (indirect)






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






26. Select From List






27. Recalculate all workbooks






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






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






30. Go to Formulas






31. Enter Built-In Formula






32. Count Number of Entries






33. Erase Traces






34. Record Macros






35. Conditional






36. Highlight Dependents






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






38. Find Item's Position






39. Go to Formulas






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






41. Show formulas/values






42. Find Based on Row






43. Go to dependent cells






44. Multiply/Sum Range






45. Anchor Cell






46. Enter Formula






47. Displays the square root of the number identified in the argument. For example =SQRT(C4) will display the square root of the value in C4.






48. Conditional Count






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






50. Sum Numbers