Test your basic knowledge |

Microsoft Office Excel

Subject :
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. Sections or areas in a window that enable you to see different parts of the worksheet at the same time






2. Alphanumeric entry in a worksheet that is not a cell or range address






3. Shortcut used to insert repeated information






4. Formatting arrangement that specifies the location and sizes of chart elements such as the chart title and legend






5. graphic that compares and contrasts worksheet data in visual format






6. Command used to place data from the clipboard to a location on the worksheet






7. Reference in a destination document to an object in a source document - changes to the linked object in the source document are automatically made to the object in the destination document






8. Typeface or design of text






9. Default chart type that displays each data point as a vertical column






10. Feature that enables excel to create a series automatically






11. Cell entry that indicates a date or time and is stored as a date code






12. Excel file with one or more worksheets






13. Feature that shows you how a gallery formatting choice will appear in the worksheet when you move the mouse pointer over that choice






14. Work area for entering and calculating data made up of columns and rows separated by gridlines aka spreadsheet






15. Command used to redo an action you have undone






16. An identifying label assigned to a group of cells






17. Tool that enables you to copy formatting from a cell and apply it to another cell or range






18. Cell address in a formula that will not change when you copy the formula to another location - dollar signs in the cell reference indicate when it is absolute






19. Using a function as an argument within another function






20. Lines of measurement along the category and value axis






21. Symbols used in mathematical operations






22. Instruction Excel uses to calculate a result






23. Chart placed as an object within a worksheet






24. Type of conditional formatting that applies to a background fill color that varies depending on the relative value stored in each of the formatted cells






25. Displays the relationships within an organization such as managers in an office - the people they manage and who they report to






26. Contains the cell pointer and is outlined by a dark box






27. Block of cells in an excel worksheet






28. Cells in a worksheet that act as a block - but are not necessarily adjacent to each other






29. Feature that causes long cell entries to appear on multiple lines






30. To see how a worksheet will look when printed






31. To insert and object in a destination document so that it can still be edited by the source application - the original object remains unchanged






32. Command used to place a copy of data from the selected cell or range on the clipboard






33. To move a pie slice away from the pie chart - for emphasis






34. Measurement of the typeface in points






35. Feature that causes long cell entries to appear on multiple lines within a cell






36. Using formulas and other tools in Excel to examine the results of particular data






37. Descriptive text appearing at the bottom of each printout page






38. overall background for the chart and all its elements - like titles






39. Predrawn graphic used to illustrate a specific data relationship such as a list or other relationship






40. Method to keep specified rows and columns in view when scrolling through a worksheet






41. vertical scale of a chart on which the values from each category is plotted






42. Feature used to complete and entry based on previous entries made in the column containing the active cell






43. Free floating text object added to a sheet or a chart - to which you can apply special formatting effects






44. Set of related data points to be charted






45. Command that enables you to display the formulas in a worksheet so that you can check them






46. Process of saving data to internet






47. Windows feature that holds data or graphics that you cut or copy prior to pasting into another location






48. values and other inputs that a function uses to calculate the result






49. Box at the far left end of the formula bar that you can use to create and navigate to named ranges






50. New - empty workbook which contains 3 sheets