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. Displays the current date or time based on the computer's clock.






2. Conditional Sum






3. Validate Data






4. Enter Built-In Formula






5. Show all Precedents






6. Find Based on Column






7. Enter Formula






8. Trace immediate dependents






9. Displays the date in a variety of formats.






10. At Least 1 Must Be True






11. Recalculate all workbooks






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






13. Go to Formulas






14. Conditional Count






15. Copy Formula Right






16. Show all Dependents






17. Jump Back to Original Cell






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






19. Zoom to selection






20. Erase Traces






21. All Must Be True






22. Average






23. Find Based on Row






24. Refresh Worksheet / Calculate Formulas






25. Minimum






26. Find Item's Position






27. Trace Dependents






28. Trace all precedents (indirect)






29. Copy Formula Down






30. Add/Edit Comment






31. Highlight Comments






32. Conditional






33. Copy value from above cell






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






35. Use Relative References






36. Advanced Data Filter






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






38. Highlight Dependents






39. View Macros






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






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






42. Sum Numbers






43. Delete Comment






44. Track changes






45. Go to precedent cells






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






47. Create Pivot Table






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






49. Paste Link






50. Go to Formulas