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. Standard settings excel uses in its software - such as column width or number of worksheets in a workbook






2. Process of saving data to internet






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






4. Symbols used in mathematical operations






5. Block of adjacent cells in a worksheet






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






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






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






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






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






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






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






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






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






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






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






17. Intersection of a column and a row on a worksheet






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






19. Using a function as an argument within another function






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






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






22. Shortcut used to insert repeated information






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






24. Style that displays decimal numbers as a percentage






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






26. Excel file with one or more worksheets






27. To remove a cells contents or formatting






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






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






30. Feature that speeds up the manual entry of functions






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






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






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






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






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






36. Feature that enables excel to create a series automatically






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






38. Chart placed as an object within a worksheet






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






40. Private network of computes within a business or organization






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






42. An identifying label assigned to a group of cells






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






44. Located above the worksheet data appears here






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






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






47. Area that holds the data points on a chart






48. Sort of equation that returns a value - like True or False. Excel uses expressions to identify cells to include in certain formulas such as IF and SUMIF






49. Set of related data points to be charted






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