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. Show all Dependents






2. Show Formulas






3. Average






4. Zoom to selection






5. Conditional Count






6. Jump Back to Original Cell






7. Go to Formulas






8. Displays the date in a variety of formats.






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






10. Go to Constants






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






12. Record Macros






13. Copy value from above cell






14. Paste Link






15. Delete Comment






16. Validate Data






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






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






19. Find Item






20. View Macros






21. Highlight Dependents






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






23. Trace immediate dependents






24. Maximum






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






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






27. Highlight Precedents






28. Go to dependent cells






29. Create Data Table






30. Erase Traces






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






32. All Must Be True






33. Enter Built-In Formula






34. Create Pivot Table






35. Copy Formula Right






36. Minimum






37. Enter Formula






38. Go to Formulas






39. Conditional Sum






40. Evaluate formula






41. Track changes






42. Find Based on Row






43. A model used to investigate dynamic behavior






44. Copy Formula Down






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






46. Recalculate all workbooks






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. Trace immediate precedents






49. Use Relative References






50. Highlight Comments