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. Chart that occupies its own worksheet






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






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






4. Built in calculation used to add range of values together






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






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






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






8. Symbols used in mathematical operations






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






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






11. Block of adjacent cells in a worksheet






12. Process of saving data to internet






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






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






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






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






17. Color that fills a cell appearing behind the data






18. Selected worksheet






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






20. Set of related data points to be charted






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






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






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






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






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






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






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






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






29. New - empty workbook which contains 3 sheets






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






31. Worksheets that are selected as a unit - any action performed to one will affect all the group






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






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






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






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






36. Chart that occupies its own worksheet






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






38. Specific values plotted on a chart






39. To remove a cells contents or formatting






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






41. An identifying label assigned to a group of cells






42. Name given to on of excels predefined formulas






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






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






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






46. Shortcut used to insert repeated information






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






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






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






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






Content not found.:)

Browse BasicVersity