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. Displays the date in a variety of formats.






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






4. Find Based on Column






5. Copy value from above cell






6. Paste Link






7. At Least 1 Must Be True






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






9. Trace all dependents (indirect)






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






11. Anchor Cell






12. Recalculate all workbooks






13. Erase Traces






14. Copy formula from above cell

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


15. Highlight Comments






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






17. Insert AutoSum formula






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






19. Go to Formulas






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






21. Trace Precedents






22. Conditional Sum






23. Delete Comment






24. Average






25. Enter Built-In Formula






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






27. Trace all precedents (indirect)






28. Maximum






29. Trace immediate dependents






30. Show all Precedents






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






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






33. Absolute Value






34. Jump Back to Original Cell






35. Highlight Dependents






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






37. Conditional






38. Multiply/Sum Range






39. Create Data Table






40. Go to dependent cells






41. Show Formulas






42. Enter Formula






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






44. Validate Data






45. Evaluate formula






46. Use Relative References






47. Sum Adjacent Cells






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






49. Trace Dependents






50. Find Item