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






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






3. Copy formula from above cell

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


4. Anchor Cell






5. Validate Data






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






7. Minimum






8. Count Number of Entries






9. Trace all dependents (indirect)






10. Conditional Count






11. Displays the date in a variety of formats.






12. Find Based on Column






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






14. Copy value from above cell






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






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






17. Recalculate all workbooks






18. Select From List






19. Show all Precedents






20. Advanced Data Filter






21. Go to dependent cells






22. Show all Dependents






23. View Macros






24. Track changes






25. At Least 1 Must Be True






26. Conditional Sum






27. Sum Numbers






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






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






30. Average






31. Create Pivot Table






32. Erase Traces






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






34. Use Relative References






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






36. Highlight Comments






37. Paste Formats & Formulas






38. Copy Formula Down






39. Sum Adjacent Cells






40. Trace immediate dependents






41. Maximum






42. Refresh Worksheet / Calculate Formulas






43. Find Based on Row






44. Highlight Precedents






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






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






47. Evaluate formula






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






49. Add/Edit Comment






50. Conditional