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. Setting that determines whether the worksheet will be printed with the paper in portrait or landscape






2. Measurement of the typeface in points






3. Lines of measurement along the category and value axis






4. Chart placed as an object within a worksheet






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






6. Typeface or design of text






7. Using formulas and other tools in Excel to examine the results of particular data






8. Shortcut used to insert repeated information






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






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






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






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






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






14. Selected worksheet






15. Symbols used in mathematical operations






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






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






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






19. An identifying label assigned to a group of cells






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






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






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






23. Style that displays numbers with a thousands separator






24. Instruction Excel uses to calculate a result






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






26. Chart that occupies its own worksheet






27. List of sequential numbers - dates - times - or text






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






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






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






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






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






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






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. Process of saving data to internet






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






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






38. Using a function as an argument within another function






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






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






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






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






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






44. Command used to redo an action you have undone






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






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






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






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






49. Type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells






50. Located above the worksheet data appears here