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. To apply attributes to cell data to change the appearance of the worksheet






2. Collection of coordinated fonts - colors - and effects for graphic elements such as charts and images that can be quickly applied to all sheets






3. Descriptive text appearing at the bottom of each printout page






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






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






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






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






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






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






10. Style that displays numbers with a thousands separator






11. values and other inputs that a function uses to calculate the result






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






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






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






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






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






17. Measurement of the typeface in points






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






19. Feature that causes long cell entries to appear on multiple lines






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






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






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






23. Specific keyboard keys that you press together or in sequence to execute commands or apply settings






24. Instruction Excel uses to calculate a result






25. Command used to redo an action you have undone






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






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






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






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






30. Cell entry that indicates a date or time and is stored as a date code






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






32. Shortcut used to insert repeated information






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






34. Feature that enables excel to create a series automatically






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






36. Located above the worksheet data appears here






37. Excel file with one or more worksheets






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






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






40. To see how a worksheet will look when printed






41. Private network of computes within a business or organization






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






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






44. Name given to on of excels predefined formulas






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






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






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






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






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






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