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. Box at the far left end of the formula bar that you can use to create and navigate to named ranges






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






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






4. Predefined formula performs a specific calculation using the inputs you specify






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






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






7. Block of adjacent cells in a worksheet






8. Set of related data points to be charted






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






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






11. Each column of a charted worksheet contains a category






12. Selected worksheet






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






14. Symbols used in mathematical operations






15. Located above the worksheet data appears here






16. Measurement of the typeface in points






17. Using a function as an argument within another function






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






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






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






21. Style that displays decimal numbers as a percentage






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






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






24. Cell entry that consists of a number and numeric formatting only






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






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






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






28. Process of saving data to internet






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






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






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






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






33. Feature that enables excel to create a series automatically






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






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






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






37. Color that fills a cell appearing behind the data






38. An identifying label assigned to a group of cells






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






40. Name given to on of excels predefined formulas






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






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






43. Feature that speeds up the manual entry of functions






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






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






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






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






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






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






50. Private network of computes within a business or organization