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. Button in a dialog box that you click to downsize a dialog box to make a selection on the sheet - and then click again to restore the dialog box to its regular size






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






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






4. Specific values plotted on a chart






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






6. Format that controls how numerical data is displayed including the use of commas - dollar signs - and decimal places






7. Row and column labels that reprint on each page of a printout






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






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






10. A way to view locations on the worksheet without changing the active cell






11. Buttons that appear just to the left of the sheet tabs - which allow you to scroll hidden tabs into view






12. List of sequential numbers - dates - times - or text






13. Color that fills a cell appearing behind the data






14. Command used to reverse one or a series of editing actions






15. Conditional formatting rules that format the highest or lowest values in the formatted range - or those that are above or below average






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






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






18. Feature that enables you to automatically combine cells and center the contents






19. Typeface or design of text






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






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






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






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






24. Using a function as an argument within another function






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






26. To apply attributes to cell data to change the appearance of the worksheet






27. Tool used to assist you in finding and correcting typographical or spelling errors






28. Tabs that appear at the bottom of the workbook window displaying sheet names






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






30. Default number of characters that display in a column based on the default font






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






32. Symbols used in mathematical operations






33. Block of adjacent cells in a worksheet






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






35. Feature that enables excel to create a series automatically






36. Chart placed as an object within a worksheet






37. Number entered in the worksheet as a label - not value - like the year 2012






38. Name given to on of excels predefined formulas






39. To remove a cells contents or formatting






40. Descriptive text appearing at the top of each printout page






41. Set of related data points to be charted






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






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






44. New - empty workbook which contains 3 sheets






45. Located above the worksheet data appears here






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






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






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






49. Lines of measurement along the category and value axis






50. Sections or areas in a window that enable you to see different parts of the worksheet at the same time