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. Go to Formulas






2. Paste Link






3. Copy formula from above cell


4. Insert AutoSum formula






5. Average






6. Copy Formula Down






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






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






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






10. Advanced Data Filter






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






12. Jump Back to Original Cell






13. Highlight Comments






14. Validate Data






15. Use Relative References






16. Trace immediate dependents






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






18. Maximum






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






20. Delete Comment






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






22. Enter Built-In Formula






23. Absolute Value






24. View Macros






25. Find Based on Column






26. Sum Numbers






27. Trace Dependents






28. Go to precedent cells






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






30. Create Pivot Table






31. Create Data Table






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






33. Trace immediate precedents






34. Find Based on Row






35. Go to Formulas






36. Trace all precedents (indirect)






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






38. Trace all dependents (indirect)






39. Sum Adjacent Cells






40. Paste Formats & Formulas






41. Recalculate all workbooks






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






43. Conditional Sum






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






45. Erase Traces






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






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






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






49. Minimum






50. Record Macros