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. Using formulas and other tools in Excel to examine the results of particular data






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






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






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






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






6. Block of cells in an excel worksheet






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






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






9. Row you can display below a table to calculate data in the columns above using a function you choose






10. Area that holds the data points on a chart






11. Feature that speeds up the manual entry of functions






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






13. Sort of equation that returns a value - like True or False. Excel uses expressions to identify cells to include in certain formulas such as IF and SUMIF






14. Shape - bar - column representing each data point of a chart






15. New - empty workbook which contains 3 sheets






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






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






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






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






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






21. Each column of a charted worksheet contains a category






22. Cell address that can change in a copied formula - so the new address is expressed in relation to the cell containing the copied formula






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






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






25. Feature that enables excel to create a series automatically






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






27. Process of saving data to internet






28. To see how a worksheet will look when printed






29. Measurement of the typeface in points






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






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






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






33. An identifying label assigned to a group of cells






34. Block of adjacent cells in a worksheet






35. Chart that occupies its own worksheet






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






37. Chart that occupies its own worksheet






38. Color that fills a cell appearing behind the data






39. Built in calculation used to add range of values together






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






41. variable formatting that changes the formatting applied based on the cells in the formatting range






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






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






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






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






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






47. value - some text - or and expression that defines the type of contend you want to see






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






49. Located above the worksheet data appears here






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