How To Make Excel Sheet?

30 Questions

Settings
Please wait...
Excel Quizzes & Trivia

Do you know how to make excel sheet? Let's prove yourself now by taking this quiz!


Questions and Answers
  • 1. 
    What is a worksheet tab in Excel 2007?
    • A. 

      A worksheet tab is used to access tools associated with the worksheet

    • B. 

      A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

    • C. 

      A worksheet tab is used to get help when working with Microsoft Excel 2007

    • D. 

      A worksheet tab is used to move from one cell to the next cell in a worksheet

  • 2. 
    True or False: Tables created through Excel's table feature allow users to filter columns by different values.
    • A. 

      True

    • B. 

      False

  • 3. 
    True or False:  Pivot tables allow filtering of table information by different values in column and row headers.
    • A. 

      True

    • B. 

      False

    • C. 

      Only when using Excel 2003 or earlier versions

  • 4. 
    Creating tables is as easy as highlighting cells that have already been filled in appropiately, followed by clicking on the insert tab and then clicking on the table button.
    • A. 

      No, highlighting cells disables the ability to create tables

    • B. 

      Yes, it is that simple, but the highlighted cells must have numerical data

    • C. 

      No, you go to the home tab and then click on the table button

    • D. 

      Yes, it is that simple, but the highlighted selection should not contain any blank cells

  • 5. 
    Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.
    • A. 

      False, you may change filters up to three times

    • B. 

      True

    • C. 

      False, you may change filters as many times as you please without limits

    • D. 

      False, tables cannot be filtered

  • 6. 
    Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?
    • A. 

      Default Pivot Table Layout

    • B. 

      Classic Pivot Table Layout

    • C. 

      Master Pivot Table Layout

    • D. 

      Operation Geronimo Layout

  • 7. 
    True or False:  For a table to work properly, the top row should have column headings.
    • A. 

      True

    • B. 

      False, only rows may have headings

    • C. 

      False

  • 8. 
    True or False:  Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.
    • A. 

      True

    • B. 

      False, pivot tables do not contain enough information for graphs or charts

    • C. 

      False, only regular tables may be used to create graphs or charts

  • 9. 
    What is the function of the Formulas tab in Microsoft Excel 2007?
    • A. 

      The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically

    • B. 

      The Formulas tab contain only the most common formulas supported by Excel

    • C. 

      The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab

    • D. 

      The Formulas tab is used for automatic creation of a complete formula without any user interaction at all

  • 10. 
    Which of the following Excel features allows you to summarize the data in a large table?
    • A. 

      Data Validation

    • B. 

      Conditional Formatting

    • C. 

      Pivot Table

    • D. 

      Hyperlink

  • 11. 
    When number signs (#####) are displayed in the cell, it means:
    • A. 

      There are too many characters in the cell to be displayed with the current cell width

    • B. 

      The formula in the cell is wrong

    • C. 

      The decimal point placement in the cell is wrong

    • D. 

      All of the above

  • 12. 
    What does the Format Painter button do?
    • A. 

      Only changes the color of each cell

    • B. 

      Only changes the color of a group of cells that you choose

    • C. 

      Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.

    • D. 

      Only copies formulas from one cell or group of cells to another.

  • 13. 
    By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?
    • A. 

      Right click on sheet 2 and select insert

    • B. 

      Right click on sheet 1 and select insert

    • C. 

      Right click on sheet 3 and select insert

    • D. 

      None of the above

  • 14. 
    When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?
    • A. 

      Seperate the page into two for easier printing

    • B. 

      Use the Fit to Page option

    • C. 

      Highlight all cells to print and print selection

    • D. 

      None of the above

  • 15. 
    Once data is entered into a cell, can it be edited?
    • A. 

      Yes, but the file must be saved with a different file name

    • B. 

      No, once a file is saved, cell data cannot be changed

    • C. 

      Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

    • D. 

      No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

  • 16. 
    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
    • A. 

      Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

    • B. 

      Right click on the spreadsheet tab and select DELETE

    • C. 

      Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

  • 17. 
    What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?
    • A. 

      F3

    • B. 

      F5

    • C. 

      F7

    • D. 

      F9

    • E. 

      F11

    • F. 

      F13

  • 18. 
    Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
    • A. 

      Count

    • B. 

      Average

    • C. 

      Sum

  • 19. 
    Which of these will NOT select all the cells in a document?
    • A. 

      Clicking three times with the right mouse button in the spreadsheet

    • B. 

      Using the Edit - Select All menu item

    • C. 

      Pressing CTRL + A on the keyboard

  • 20. 
    When you see a cell with a red triangle in the top right corner, what does this signify?
    • A. 

      There is an error in the cell

    • B. 

      There is a comment associated with the cell

    • C. 

      The font color for text in the cell is red

    • D. 

      A formula cannot be entered into the cell

  • 21. 
    Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
    • A. 
    • B. 
    • C. 
  • 22. 
    Which of the following will NOT set text in selected cells to ITALICS?
    • A. 

      Pressing CTRL + I on the keyboard

    • B. 

      Using the Tools - Wizard - Web Form menu item

    • C. 

      Using the Format - Cells - Font menu item

  • 23. 
    Is it possible to insert an image from a file into an Excel spreadsheet?
    • A. 

      Yes

    • B. 

      No

  • 24. 
    How do you turn off automatic calculation for a spreadsheet ?
    • A. 

      You cannot turn off automatic calculation - its built into the spreadsheet / workbook.

    • B. 

      Right click on the spreadsheet tab and select MANUAL CALCULATION.

    • C. 

      Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.

  • 25. 
    What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection ?
    • A. 

      CTRL+TAB

    • B. 

      SHIFT+TAB

    • C. 

      ALT+TAB

    • D. 

      SHIFT+ENTER

    • E. 

      CTRL+ENTER

    • F. 

      ALT+ENTER

  • 26. 
    When working with a chart, which of the following will allow you to change the spacing of tick marks and labels on the category axis ? Click on the desired axis and go to:
    • A. 

      FORMAT - SELECTED AXIS - SCALE - Select options required

    • B. 

      FORMAT - CHART - AXIS - SCALE - Select options required

    • C. 

      Format Tab - Format Selection - Axis Options - Select options required

  • 27. 
    What does the following error mean - #REF! ?
    • A. 

      The #REF! error value occurs when a cell reference is not valid.

    • B. 

      The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

    • C. 

      The #REF! error value occurs when a cell has been formatted as a currency but contains text.

  • 28. 
    Which feature in Excel allows you to view two spreadsheets in one window?
    • A. 

      Freeze panes

    • B. 

      Split

    • C. 

      View side by side

  • 29. 
    What must first be created before copying the results of an advanced filter to another location?
    • A. 

      Criteria range

    • B. 

      Output range

    • C. 

      Setup range

    • D. 

      Filter range

  • 30. 
    Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?
    • A. 

      ROUND

    • B. 

      ROUNDUP

    • C. 

      ROUNDDOWN

    • D. 

      RAND