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. Feature that enables you to automatically combine cells and center the contents






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






3. New - empty workbook which contains 3 sheets






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






5. Block of cells in an excel worksheet






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






7. Feature that speeds up the manual entry of functions






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






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






10. Set of related data points to be charted






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






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






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






14. Instruction Excel uses to calculate a result






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






16. To remove a cells contents or formatting






17. Specific values plotted on a chart






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






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






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






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






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






23. Color that fills a cell appearing behind the data






24. Process of saving data to internet






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






26. Excel file with one or more worksheets






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






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






29. An identifying label assigned to a group of cells






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






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






32. Using a function as an argument within another function






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






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






35. Chart that occupies its own worksheet






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






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






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






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






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






41. Style that displays decimal numbers as a percentage






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






43. Feature used to automate the correction of common typing errors






44. Selected worksheet






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






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






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






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






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






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