Excel 2007 Exam

82 Questions  I  By Karismalicious
Please take the quiz to rate it.

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

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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. 
    To enter a mixed reference, type $ after either the row or column reference.
    • 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. 
    You can rotate cell contents in Excel so that they appear at any angle or orientation.
    • 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. 
    Put the following five steps in the order in which you would perform them to use the Paste Special function:1. Select and copy a range2. Click the Paste button arrow in the Clipboard group3. Specify exactly what you want to paste4. Click Paste Special to open the dialog box5. Select the range where you want to pase the Clipboard contents
    • 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. 
    With the Last Quarter criteria filter, quarters are defined as, for example_________.
    • 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


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.