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. At Least 1 Must Be True






2. Find Item






3. Add/Edit Comment






4. Paste Formats & Formulas






5. Trace immediate precedents






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






7. Move # of Rows/Columns






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






9. Remove tracing arrows






10. Refresh Worksheet / Calculate Formulas






11. All Must Be True






12. Use Relative References






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






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






15. Advanced Data Filter






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






17. Recalculate all workbooks






18. Highlight Dependents






19. Show all Dependents






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






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






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






23. Absolute Value






24. Delete Comment






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






26. Anchor Cell






27. Find Item's Position






28. Highlight Comments






29. Maximum






30. Trace Precedents






31. Evaluate formula






32. Trace Dependents






33. Copy formula from above cell


34. Sum Numbers






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






36. Select From List






37. Create Data Table






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






39. Record Macros






40. Show all Precedents






41. Zoom to selection






42. A model used to investigate dynamic behavior






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






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






45. Paste Link






46. Count Number of Entries






47. Create Pivot Table






48. Validate Data






49. Trace immediate dependents






50. Minimum