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. A model used to investigate dynamic behavior






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






3. Enter Formula






4. Insert AutoSum formula






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






6. Trace immediate precedents






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






8. Advanced Data Filter






9. Absolute Value






10. All Must Be True






11. Refresh Worksheet / Calculate Formulas






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






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






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






15. Show all Dependents






16. Conditional






17. Trace all dependents (indirect)






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






19. Copy Formula Down






20. Enter Built-In Formula






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






22. Zoom to selection






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






24. Add/Edit Comment






25. Go to precedent cells






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






27. Delete Comment






28. Track changes






29. Find Item






30. Find Based on Row






31. At Least 1 Must Be True






32. Use Relative References






33. Sum Adjacent Cells






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






35. Count Number of Entries






36. View Macros






37. Conditional Sum






38. Anchor Cell






39. Maximum






40. Trace all precedents (indirect)






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






42. Record Macros






43. Create Data Table






44. Trace Precedents






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






46. Go to Formulas






47. Copy formula from above cell

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


48. Go to Constants






49. Highlight Dependents






50. Copy Formula Right