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. Block of adjacent cells in a worksheet






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






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






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






5. Area that holds the data points on a chart






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






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






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






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






10. Style that displays numbers with a thousands separator






11. Lines of measurement along the category and value axis






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






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






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






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






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






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






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






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






20. Feature that enables excel to create a series automatically






21. Shortcut used to insert repeated information






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






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






24. Specific values plotted on a chart






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






26. New - empty workbook which contains 3 sheets






27. An identifying label assigned to a group of cells






28. Contains the cell pointer and is outlined by a dark box






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






30. Using a function as an argument within another function






31. Instruction Excel uses to calculate a result






32. Feature that speeds up the manual entry of functions






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






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






35. Chart placed as an object within a worksheet






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






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






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






40. Symbols used in mathematical operations






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






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. Intersection of a column and a row on a worksheet






44. Chart that occupies its own worksheet






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






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






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






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






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






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