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. Enter Built-In Formula






2. Sum Adjacent Cells






3. Go to precedent cells






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






5. Go to dependent cells






6. Conditional






7. Highlight Comments






8. Track changes






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. Paste Link






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






12. Record Macros






13. Go to Constants






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






15. Use Relative References






16. Erase Traces






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






18. Conditional Count






19. Copy Formula Right






20. Average






21. Displays the date in a variety of formats.






22. Trace all precedents (indirect)






23. Minimum






24. Copy Formula Down






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






26. Anchor Cell






27. Move # of Rows/Columns






28. Remove tracing arrows






29. Find Based on Row






30. All Must Be True






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






32. Trace Precedents






33. Validate Data






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






35. Copy formula from above cell

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


36. Create Pivot Table






37. Show all Precedents






38. Trace immediate dependents






39. Trace Dependents






40. Find Based on Column






41. Advanced Data Filter






42. Trace all dependents (indirect)






43. Select From List






44. View Macros






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






46. Show formulas/values






47. Go to Formulas






48. Show all Dependents






49. Find Item's Position






50. Maximum