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






2. Location of a cell in a worksheet as identified by its column letter and row number






3. Feature that speeds up the manual entry of functions






4. Each column of a charted worksheet contains a category






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






6. Chart that occupies its own worksheet






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






8. To see how a worksheet will look when printed






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






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






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






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






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






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






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






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






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






18. Color that fills a cell appearing behind the data






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






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






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






22. Block of adjacent cells in a worksheet






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






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






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






26. Instruction Excel uses to calculate a result






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






28. Area that holds the data points on a chart






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






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






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






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






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






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






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






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






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






38. Command used to redo an action you have undone






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






40. Measurement of the typeface in points






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






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






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






44. Excel file with one or more worksheets






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






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






47. Lines of measurement along the category and value axis






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






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






50. Process of saving data to internet