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. Worksheets that are selected as a unit - any action performed to one will affect all the group






2. New - empty workbook which contains 3 sheets






3. To see how a worksheet will look when printed






4. Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort - filter - and perform other functions on the table






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






6. Key that identifies each of the data series in a chart






7. A free floating box added to a sheet or chart that contains any text you specify and can be formatted separately






8. Shortcut used to insert repeated information






9. graphic t data that compares and contrasts worksheet data in visual format






10. Method used to move or copy the contents of a range of cells by dragging the border of a selection from one location and dropping it in another






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






12. Function that updates and displays a new result each time you open the workbook






13. Keyboard shortcuts for choosing ribbon commands that you display by pressing Alt.






14. Structured reference to a table column - which consists of the table column header name in square brackets






15. Any element on a worksheet or chart that can be manipulated independently






16. Lines of measurement along the category and value axis






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






18. Block of adjacent cells in a worksheet






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






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






21. hide nonmatching rows in a table or list of data according to the criterion or criteria you specify






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






23. Text entered to identify the type of data contained in a row or column






24. Reducing or enlarging worksheet information to fit on a specified number of pages






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






26. Using the table name or a table column header in a formula to refer to data in the entire table or specified column






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






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






29. Color that fills a cell appearing behind the data






30. Specific values plotted on a chart






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






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






33. To remove a cells contents or formatting






34. Intersection of a column and a row on a worksheet






35. Measurement of the typeface in points






36. Located above the worksheet data appears here






37. Symbols used in mathematical operations






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






39. Style that vertically aligns with dollar signs and decimal points






40. Type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells






41. Chart placed as an object within a worksheet






42. Block of cells in an excel worksheet






43. Combination of font - text color - cell color - and other attributes applied to a single cell






44. Chart that occupies its own worksheet






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






46. Style that displays decimal numbers as a percentage






47. Standard settings excel uses in its software - such as column width or number of worksheets in a workbook






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






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






50. Feature that enables excel to create a series automatically