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. Find Item's Position






3. Erase Traces






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






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. Go to Constants






7. Find Item






8. Use Relative References






9. Minimum






10. Conditional Count






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






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






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






14. Anchor Cell






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






16. Evaluate formula






17. Copy Formula Down






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






19. Displays the date in a variety of formats.






20. Jump Back to Original Cell






21. Average






22. Add/Edit Comment






23. All Must Be True






24. A quantitative representation - or approximation - of a real object or system. Analytical models - statistical models - financial model.






25. Enter Built-In Formula






26. Conditional






27. Highlight Dependents






28. Copy formula from above cell


29. Track changes






30. Go to Formulas






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






32. Trace immediate dependents






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






34. Go to dependent cells






35. Advanced Data Filter






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






37. Recalculate all workbooks






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






39. Trace all dependents (indirect)






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






41. Go to precedent cells






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






43. At Least 1 Must Be True






44. Delete Comment






45. Find Based on Row






46. Multiply/Sum Range






47. Trace all precedents (indirect)






48. Show all Dependents






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






50. Highlight Comments