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. Each column of a charted worksheet contains a category






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






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






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






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






6. Symbols used in mathematical operations






7. Color that fills a cell appearing behind the data






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






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






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






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






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






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






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






15. Excel file with one or more worksheets






16. Feature that speeds up the manual entry of functions






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






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






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






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






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






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






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






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






25. Shortcut used to insert repeated information






26. Cell address that can change in a copied formula - so the new address is expressed in relation to the cell containing the copied formula






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






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






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






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






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






32. New - empty workbook which contains 3 sheets






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






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






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






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






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






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






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






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






41. Chart that occupies its own worksheet






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






43. Typeface or design of text






44. Private network of computes within a business or organization






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






46. An identifying label assigned to a group of cells






47. Set of related data points to be charted






48. Descriptive text appearing at the bottom of each printout page






49. A free floating box added to a sheet or chart that contains any text you specify and can be formatted separately






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