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. Descriptive text appearing at the bottom of each printout page






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






3. Selected worksheet






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






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






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






7. Standard settings excel uses in its software - such as column width or number of worksheets in a workbook






8. Command used to place data from the clipboard to a location on the worksheet






9. Collection of coordinated fonts - colors - and effects for graphic elements such as charts and images that can be quickly applied to all sheets






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






11. Set of related data points to be charted






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






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






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






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






16. To remove a cells contents or formatting






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






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






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






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






21. Style that displays numbers with a thousands separator






22. New - empty workbook which contains 3 sheets






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






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






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






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






27. Area that holds the data points on a chart






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






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






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






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






32. Type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells






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






34. Specific values plotted on a chart






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






36. Name given to on of excels predefined formulas






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






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






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






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






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






42. Color that fills a cell appearing behind the data






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






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






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






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






47. To change the angle of the contents on a cell






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






49. Private network of computes within a business or organization






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