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. Work area for entering and calculating data made up of columns and rows separated by gridlines aka spreadsheet






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






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






4. Feature that speeds up the manual entry of functions






5. Typeface or design of text






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






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






8. Each column of a charted worksheet contains a category






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






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






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






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






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






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






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






16. Name given to on of excels predefined formulas






17. Command used to reverse one or a series of editing actions






18. Selected worksheet






19. Private network of computes within a business or organization






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






21. Chart that occupies its own worksheet






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






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






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






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






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






27. Command used to redo an action you have undone






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






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






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






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






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






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






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






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. value - some text - or and expression that defines the type of contend you want to see






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






38. To remove a cells contents or formatting






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






40. Standard settings excel uses in its software - such as column width or number of worksheets in a workbook






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






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






43. Feature that enables excel to create a series automatically






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






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






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






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






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






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






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