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. Track changes






2. Create Pivot Table






3. Sum Numbers






4. Anchor Cell






5. Highlight Comments






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






7. Find Based on Row






8. Use Relative References






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






10. Add/Edit Comment






11. Conditional Count






12. Recalculate all workbooks






13. Create Data Table






14. Insert AutoSum formula






15. Validate Data






16. Enter Formula






17. Copy value from above cell






18. Advanced Data Filter






19. Find Item






20. Minimum






21. Go to Formulas






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






23. Trace immediate dependents






24. Multiply/Sum Range






25. Absolute Value






26. Remove tracing arrows






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






28. Conditional Sum






29. Paste Formats & Formulas






30. Show all Precedents






31. Highlight Precedents






32. Trace all precedents (indirect)






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






34. Trace Precedents






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






36. Paste Link






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






38. Find Item's Position






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






40. Refresh Worksheet / Calculate Formulas






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






42. Copy Formula Right






43. Zoom to selection






44. Sum Adjacent Cells






45. Find Based on Column






46. At Least 1 Must Be True






47. Displays the date in a variety of formats.






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






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






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