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. Row and column labels that reprint on each page of a printout






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






3. Buttons that appear just to the left of the sheet tabs - which allow you to scroll hidden tabs into view






4. Style that displays numbers with a thousands separator






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






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






7. Measurement of the typeface in points






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






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






10. Shortcut used to insert repeated information






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






12. Area that holds the data points on a chart






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






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






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






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






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






18. Block of adjacent cells in a worksheet






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






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






21. Excel file with one or more worksheets






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






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






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






25. Process of saving data to internet






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






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






28. New - empty workbook which contains 3 sheets






29. Name given to on of excels predefined formulas






30. Private network of computes within a business or organization






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






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






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






34. Feature that enables excel to create a series automatically






35. Symbols used in mathematical operations






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






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






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






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






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






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






42. Set of related data points to be charted






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






44. Chart that occupies its own worksheet






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






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






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






48. Method used to move or copy the contents of a range of cells by dragging the border of a selection from one location and dropping it in another






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






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






Content not found.:)

Browse BasicVersity