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. Copy Formula Right






2. Trace Dependents






3. Go to dependent cells






4. Copy Formula Down






5. Show all Precedents






6. Average






7. Count Number of Entries






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






9. Show formulas/values






10. Trace immediate dependents






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






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






13. Remove tracing arrows






14. Maximum






15. Create Pivot Table






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






17. Conditional






18. Add/Edit Comment






19. Find Based on Row






20. Insert AutoSum formula






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






22. Use Relative References






23. Show Formulas






24. Go to Formulas






25. Go to precedent cells






26. Track changes






27. Absolute Value






28. All Must Be True






29. Evaluate formula






30. Trace all precedents (indirect)






31. Move # of Rows/Columns






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






33. Delete Comment






34. Highlight Comments






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






36. Displays the date in a variety of formats.






37. Find Item's Position






38. Zoom to selection






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






40. Minimum






41. Find Item






42. Paste Link






43. View Macros






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






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






46. Highlight Precedents






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






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






49. Recalculate all workbooks






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