Take Another Quiz

Excel 2007 Exam

82 Questions
Excel 2007 Exam

Here is a basic knowledge exam based off of quiz's from my college course.

Questions and Answers
  • 1. 
    In pie charts with legends, it's best to make the slice colors as similar as possible.
    • A. 

      True

    • B. 

      False

  • 2. 
    Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
    • A. 

      True

    • B. 

      False

  • 3. 
    You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
    • A. 

      True

    • B. 

      False

  • 4. 
    In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
    • A. 

      True

    • B. 

      False

  • 5. 
    Excel has a built in format to display 4 digit year values, so you do not need to create on.
    • A. 

      True

    • B. 

      False

  • 6. 
    One challenge of nesting functions is to make sure that you include all of the parentheses.
    • A. 

      True

    • B. 

      False

  • 7. 
    A "mixed reference" locks one part of the cell reference while the other part can change.
    • A. 

      True

    • B. 

      False

  • 8. 
    • A. 

      True

    • B. 

      False

  • 9. 
    If a formula contains several functions, Excel starts with the outermost function and then moves inward.
    • A. 

      True

    • B. 

      False

  • 10. 
    As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
    • A. 

      True

    • B. 

      False

  • 11. 
    Pie charts are most effective with ___________ or fewer slices.
  • 12. 
    This is a collection of one or more data series.
  • 13. 
    This compares three sets of values in a 3D chart.
  • 14. 
    This compares a collection of values from several different data sets.
  • 15. 
    This compares relative values of different categories to the whole; similar to the pie chart except that it can display multiple sets of data.
  • 16. 
    This compares value from different categories; often used to show trends and changes over time.
  • 17. 
    What is a range of values that is plotted as a single unit on the chart.
  • 18. 
    What displays values in different categories; column chart on its side.
  • 19. 
    What uses vertical rectangles to compare values across categories.
  • 20. 
    In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are ________
  • 21. 
    The numbers, text, or cell references used by the function to return a value are
    • A. 

      Expressions

    • B. 

      Arguments

    • C. 

      Data

    • D. 

      Values

  • 22. 
    In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
    • A. 

      The formula returns the text "RESTART"

    • B. 

      The formula returns the text "DONE"

    • C. 

      The formula returns the text "NO"

    • D. 

      The formula returns the text "NO, RESTART"

  • 23. 
    The ____ button is equivalent to using the sum button.
    • A. 

      COUNT

    • B. 

      ADD

    • C. 

      AutoSum

    • D. 

      AddSum

  • 24. 
    FUNCTION(argument1,argument2, ...) is ________.
    • A. 

      The syntax of writing optional arguments.

    • B. 

      An example of a formula.

    • C. 

      The general syntax of all functions.

    • D. 

      The general syntax of all formulas.

  • 25. 
    In "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
    • A. 

      Letters

    • B. 

      Cell references

    • C. 

      Symbols

    • D. 

      Operators

  • 26. 
    Formatting changes only the appearance of data- it does not affect the data itself.
    • A. 

      True

    • B. 

      False

  • 27. 
    After you merge a range into a single cell, you can't realign its content.
    • A. 

      True

    • B. 

      False

  • 28. 
    • A. 

      True

    • B. 

      False

  • 29. 
    When a worksheet is printed, the grid lines that surround the cells are printed by default.
    • A. 

      True

    • B. 

      False

  • 30. 
    A conditional format can make negative numbers red and positive numbers black.
    • A. 

      True

    • B. 

      False

  • 31. 
    Once you hide a row, it remains hidden as long as the workbook is active.
    • A. 

      True

    • B. 

      False

  • 32. 
    What is a workbook made up of?
  • 33. 
    Multiplication before addition is an example of ____________________
  • 34. 
    When you copy a range of cells, you must press the _____ key while you drag the selection to its new location.
  • 35. 
    A named operation that returns a value is a ______.
  • 36. 
    A group of worksheet cells is called a _________.
  • 37. 
    Pressing Ctrl + ' switches to the _________ view.
  • 38. 
    A _______________ is an excel document.
  • 39. 
    ___________ view shows the contents of a worksheet.
  • 40. 
    The _____________ button quickly inserts Excel functions.
  • 41. 
    The  ___________ allows you to use excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.
  • 42. 
    The _________________ displays the name of the sheets in the workbook.
  • 43. 
    The ____________ displays the cell reference of the active cell.
  • 44. 
    I the background color for a workbook is green, what color should you not use for any of the font or highlight colors?
    • A. 

      Red

    • B. 

      White

    • C. 

      Black

    • D. 

      Any color is fine

  • 45. 
    If there are too many numbers after the decimal place displayed in a cell, creating a distraction from the data, you could make the data appear cleaner by:
    • A. 

      Reenter all the numbers

    • B. 

      Decrease the column width

    • C. 

      Decrease the font size

    • D. 

      Use the Number group to decrease the number of digits displayed

  • 46. 
    If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:
    • A. 

      Type the data in A1 and Merge cells A1:A5

    • B. 

      Type the data in A1 and Merge cells A1:E1

    • C. 

      Type the data in C1

    • D. 

      Choose Center from the Format menu

  • 47. 
    If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the test visible without loosing data would be to:
    • A. 

      Abbreviate all text

    • B. 

      Reduce the font size to 8 pt

    • C. 

      Click Wrap text

    • D. 

      Delete one column

  • 48. 
    The most efficient way to format several cells with a specific font, number format, alignment, fon color would be to:
    • A. 

      Use Format Painter

    • B. 

      Format each element using the Toolbar

    • C. 

      Select all and use the Formatting dialog box

    • D. 

      Apply a table style

  • 49. 
    When creating an Excel document, you should avoid using ______ text and background together, since this is the most common form of color blindness.
    • A. 

      Red and green

    • B. 

      Yellow and blue

    • C. 

      Black and white

    • D. 

      Red and yellow

  • 50. 
    As a general rule you should______________
    • A. 

      Center column titles, left align text, and right align numbers

    • B. 

      Center column titles, right align text, and left align numbers

    • C. 

      Right column titles, left align text, and right align numbers

    • D. 

      Left column titles, left align text, and right align numbers

  • 51. 
    The Paste Options button allows you to________.
    • A. 

      Keep source formatting

    • B. 

      Copy formatting only

    • C. 

      Copy values only

    • D. 

      All of the above

  • 52. 
    • A. 

      1, 2, 4, 3, 5

    • B. 

      1, 2, 4, 5, 3

    • C. 

      1, 5, 2, 4, 3

    • D. 

      1, 5, 2, 3, 4

  • 53. 
    If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.
    • A. 

      True

    • B. 

      False

  • 54. 
    When using a data bar, changing the value of one cell in the range will not affect the size of all the other cells.
    • A. 

      True

    • B. 

      False

  • 55. 
    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
    • A. 

      True

    • B. 

      False

  • 56. 
    An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
    • A. 

      True

    • B. 

      False

  • 57. 
    None of the data shown is _________.
    • A. 

      Aligned

    • B. 

      Truncated

    • C. 

      Formatted

    • D. 

      Formulated

  • 58. 
    Removing the contents of a cell is known as ____ a cell.
    • A. 

      Clearing

    • B. 

      Emptying

    • C. 

      Editing

    • D. 

      Deleting

  • 59. 
    The amount of money being loaned is known as the _____.
    • A. 

      Mortgage

    • B. 

      Principal

    • C. 

      Loan amount

    • D. 

      Proposed principal

  • 60. 
    60%-Accent is an example of a cell _____.
    • A. 

      Size

    • B. 

      Style

    • C. 

      Border color

    • D. 

      Height

  • 61. 
    To sort data in an Excel worksheet you can use the ______.
    • A. 

      Sort A to Z and Sort Z to A buttons

    • B. 

      QuickSort Options

    • C. 

      Sort command on the Formulas tab

    • D. 

      Any of the above

  • 62. 
    Item ______ in the figure indicates the fields you want to summarize.
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 63. 
    A(n)_____________________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
  • 64. 
    When you are in _________ mode, some keyboard shortcuts will work differently.
  • 65. 
    A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
  • 66. 
    You can create at most one Excel table in a worksheet
    • A. 

      True

    • B. 

      False

  • 67. 
    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.
    • A. 

      True

    • B. 

      False

  • 68. 
    You can use a table's sizing handle to add columns or rows to a table
    • A. 

      True

    • B. 

      False

  • 69. 
    When you clear a filter, all filters in the worksheet are cleared
    • A. 

      True

    • B. 

      False

  • 70. 
    When you designate a range as a(n) ______, Excel provides the same operations as are available for a structured range of data
    • A. 

      Table

    • B. 

      Catalogue

    • C. 

      Index

    • D. 

      Roster

  • 71. 
    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry
    • A. 

      Shift

    • B. 

      Tab

    • C. 

      Esc

    • D. 

      Alt

  • 72. 
    You use ______ filters to find all objects with a value greater than X or acquired after a certain date
    • A. 

      Custom

    • B. 

      Criteria

    • C. 

      Index

    • D. 

      Pivot

  • 73. 
    • A. 

      April, May, June

    • B. 

      March, April, May

    • C. 

      May, June, July

    • D. 

      March, April, May, June, July

  • 74. 
    If you want to use your PivotTable to combine items into groups, which of the following would not be true?
    • A. 

      Items that appear as row labels cannot be grouped

    • B. 

      Items that appear as column labels can be grouped

    • C. 

      If items are dates, they can be grouped automatically using the Grouping dialog box

    • D. 

      If items are numbers, they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu

  • 75. 
    A field name is also called a(n)  _____________
  • 76. 
    The process of hiding certain records and viewing the ones you want is called ____________ your data.
  • 77. 
    The ____________________ criteria filter requires that the records displaying begin with the specified text string.
  • 78. 
    In PivotTable terminology, the fields that you summarize are known as ______________ fields.
  • 79. 
    A(n) _______________ is a range of values that spans the vertical axis in a column chart.
  • 80. 
    A(n) ________ function is conditional.
  • 81. 
    The function arguments dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 82. 
    The Insert Function dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False