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






2. Symbols used in mathematical operations






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






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






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






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






7. graphic t data that compares and contrasts worksheet data in visual format






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






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






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






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






12. Command used to redo an action you have undone






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






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






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






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






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






18. Set of related data points to be charted






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






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






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






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






23. Process of saving data to internet






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






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






26. An identifying label assigned to a group of cells






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






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






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






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






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






32. Feature that speeds up the manual entry of functions






33. Keyboard shortcuts for choosing ribbon commands that you display by pressing Alt.






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






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






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






37. To remove a cells contents or formatting






38. Excel file with one or more worksheets






39. Shortcut used to insert repeated information






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






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






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






43. Tabs that appear at the bottom of the workbook window displaying sheet names






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






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






46. Selected worksheet






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






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






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






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