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. Each column of a charted worksheet contains a category






2. Located above the worksheet data appears here






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






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






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






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






7. Feature that enables excel to create a series automatically






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






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






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






11. Color that fills a cell appearing behind the data






12. Predefined formula performs a specific calculation using the inputs you specify






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






14. Command used to remove data from a cell or range of cells and place it on a clipboard






15. Cell entry that consists of a number and numeric formatting only






16. An identifying label assigned to a group of cells






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






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






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






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






21. Black box on the lower-right corner of the selected cell or range that you can use to fill a series or formula






22. Feature that temporarily performs that following calculations on a range of cells without the user having to enter a formula - AVERAGE COUNT MIN MAX SUM






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






24. Excel file with one or more worksheets






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






26. Method of applying conditional formatting based on how cell contents compare with a specified criterion






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






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






29. Location of a cell in a worksheet as identified by its column letter and row number






30. Setting that determines whether the worksheet will be printed with the paper in portrait or landscape






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






32. The order in which excel performs the mathematical operations specified in a formula - based on the types of mathematical operators used






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






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






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






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






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






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






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






40. Feature that speeds up the manual entry of functions






41. Set of related data points to be charted






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






43. Symbols used in mathematical operations






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






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






46. Arrange the rows in a table or list of data in a new order according to the entries in one or more columns






47. New - empty workbook which contains 3 sheets






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






49. Specific values plotted on a chart






50. Typeface or design of text