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. Erase Traces






2. Copy value from above cell






3. Sum Adjacent Cells






4. Record Macros






5. Displays the date in a variety of formats.






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






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






8. Show formulas/values






9. Move # of Rows/Columns






10. Zoom to selection






11. Use Relative References






12. Trace immediate precedents






13. Create Data Table






14. Sum Numbers






15. Enter Formula






16. Recalculate all workbooks






17. Go to Formulas






18. Remove tracing arrows






19. Displays the payment per period needed to repay a loan at a specified interest rate for a specified number of periods.






20. Absolute Value






21. Refresh Worksheet / Calculate Formulas






22. Show all Precedents






23. Trace all precedents (indirect)






24. Conditional Count






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






26. All Must Be True






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






28. Add/Edit Comment






29. At Least 1 Must Be True






30. Paste Formats & Formulas






31. Trace Dependents






32. Find Based on Row






33. Find Item's Position






34. Show Formulas






35. Validate Data






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






37. Jump Back to Original Cell






38. Copy Formula Right






39. Create Pivot Table






40. Highlight Comments






41. Find Based on Column






42. Delete Comment






43. Evaluate formula






44. Go to precedent cells






45. Count Number of Entries






46. Go to dependent cells






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






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






49. Insert AutoSum formula






50. Select From List