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






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






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






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






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






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






7. Alphanumeric entry in a worksheet that is not a cell or range address






8. Measurement of the typeface in points






9. Instruction Excel uses to calculate a result






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






11. Chart that occupies its own worksheet






12. Excel file with one or more worksheets






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






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






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






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






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






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. Collection of coordinated fonts - colors - and effects for graphic elements such as charts and images that can be quickly applied to all sheets






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. Predefined formula performs a specific calculation using the inputs you specify






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






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






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






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






26. Process of saving data to internet






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






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






29. Private network of computes within a business or organization






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






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






32. Combination of font - text color - cell color - and other attributes applied to a single cell






33. Each column of a charted worksheet contains a category






34. Located above the worksheet data appears here






35. Command used to redo an action you have undone






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






37. Area that holds the data points on a chart






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






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






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






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






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






43. Using a function as an argument within another function






44. Block of adjacent cells in a worksheet






45. Block of cells in an excel worksheet






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






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






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






49. An identifying label assigned to a group of cells






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