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. Remove tracing arrows






2. Trace all precedents (indirect)






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






4. Go to Formulas






5. Copy Formula Down






6. Move # of Rows/Columns






7. Erase Traces






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






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






10. Highlight Precedents






11. Show formulas/values






12. Copy value from above cell






13. Find Item






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






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






16. Displays the date in a variety of formats.






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






18. Recalculate all workbooks






19. Trace all dependents (indirect)






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






21. Highlight Dependents






22. Find Based on Column






23. Conditional Count






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






25. All Must Be True






26. Enter Built-In Formula






27. Highlight Comments






28. At Least 1 Must Be True






29. Paste Link






30. Absolute Value






31. Evaluate formula






32. Sum Adjacent Cells






33. Go to precedent cells






34. Average






35. Select From List






36. Maximum






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






38. Multiply/Sum Range






39. Create Data Table






40. Trace immediate precedents






41. Add/Edit Comment






42. Use Relative References






43. Conditional






44. Count Number of Entries






45. Refresh Worksheet / Calculate Formulas






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






47. Copy formula from above cell

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


48. Find Item's Position






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






50. Delete Comment