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 shows you how a gallery formatting choice will appear in the worksheet when you move the mouse pointer over that choice






2. Block of cells in an excel worksheet






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






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






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






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






7. Specific keyboard keys that you press together or in sequence to execute commands or apply settings






8. Any element on a worksheet or chart that can be manipulated independently






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






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






11. Specific values plotted on a chart






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






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






14. Tool used to assist you in finding and correcting typographical or spelling errors






15. Chart placed as an object within a worksheet






16. Name given to on of excels predefined formulas






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






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






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. Instruction Excel uses to calculate a result






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






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






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






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






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






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






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






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






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






30. Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort - filter - and perform other functions on the table






31. Command used to redo an action you have undone






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






33. Row you can display below a table to calculate data in the columns above using a function you choose






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






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






36. Private network of computes within a business or organization






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






38. Area that holds the data points on a chart






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






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






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






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






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






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






45. Chart that occupies its own worksheet






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






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






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






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






50. Excel file with one or more worksheets