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. Set of related data points to be charted






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






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






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






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






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






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






8. Color that fills a cell appearing behind the data






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






10. Selected worksheet






11. Area that holds the data points on a chart






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






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






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






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






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






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






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






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






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






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






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






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






24. An identifying label assigned to a group of cells






25. To use a function as an argument within another function






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






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






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






29. Shortcut used to insert repeated information






30. Chart that occupies its own worksheet






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






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






33. Each column of a charted worksheet contains a category






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






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






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






37. Private network of computes within a business or organization






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






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






40. Process of saving data to internet






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






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






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






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






45. Style that displays decimal numbers as a percentage






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






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






48. Chart that occupies its own worksheet






49. To see how a worksheet will look when printed






50. Symbols used in mathematical operations