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. Move # of Rows/Columns






2. Jump Back to Original Cell






3. Zoom to selection






4. Anchor Cell






5. Sum Adjacent Cells






6. Create Pivot Table






7. Validate Data






8. Copy Formula Down






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






10. Insert AutoSum formula






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






12. Absolute Value






13. View Macros






14. Trace all precedents (indirect)






15. Go to dependent cells






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






17. Displays the date in a variety of formats.






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






19. Refresh Worksheet / Calculate Formulas






20. Delete Comment






21. Conditional






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






23. All Must Be True






24. Highlight Dependents






25. Go to precedent cells






26. Create Data Table






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






28. Trace Precedents






29. Show all Precedents






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






31. Find Based on Column






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. Trace all dependents (indirect)






34. Track changes






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






36. Conditional Count






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






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






39. Highlight Precedents






40. Minimum






41. Erase Traces






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






43. Add/Edit Comment






44. Enter Formula






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






46. Recalculate all workbooks






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






48. Sum Numbers






49. Go to Formulas






50. Paste Formats & Formulas