• 1. 
    What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

  • SUMMING
  • SUM
  • ALL
  • None at all
  • 2. 
    To insert a new row, select the row heading _______ where you want the new row to appear.

  • Above
  • Below
  • 3. 
    By default, any new workbook you create in Excel will contain one ________, called __________.

  • workbook, workbook
  • worksheet, sheet1
  • 4. 
    To change the font, font size, color, or style: Select the ________ you want to modify.

  • Column Headings
  • Cells
  • 5. 
    _____________ will automatically modify a cell's row height.

  • Wrapping Text
  • Adjusting Column Height
  • 6. 
    To copy a worksheet: Right-click the worksheet you want to copy, then select _______ or _________ from the worksheet menu.

  • Copy, Move
  • Copy, Select
  • 7. 
    The bar that displays the data being entered in the active cell:

  • status bar
  • entry bar
  • Windows Task Bar
  • none of the above
  • 8. 
    How is the COLUMN in a MS Excel Spreadsheet named?

  • Numbers
  • Letters
  • Cells
  • Columns
  • 9. 
    ________ formats also allow you to work with a powerful set of ________ functions that use time and ________ information to calculate an answer.

  • Date
  • Number
  • 10. 
    Excel will usually apply the _______ number format by default if the entered data such as the number 12 is entered.

  • Percentage
  • General
  • Date
  • Long Date
  • 11. 
    To insert a new column, select the column heading to the _______ of where you want the new column to appear.

  • Left
  • Right
  • 12. 
    __________ merges the selected cells into larger cells while keeping each row separate

  • Merge and Center
  • Merge Across
  • 13. 
    What is an example of a RANGE in MS Excel.

  • B2-F5
  • F5:B2
  • B2:5F
  • (B2:F5)
  • 14. 
    You can select the desired cells and press ________ on your keyboard to access more number-formatting options.

  • Ctrl+1
  • Ctrl+F
  • 15. 
    How are ROWS in MS EXCEL spreadsheet named?

  • numbers
  • letters
  • cells
  • columns
  • 16. 
    To change the row height and column width for all cells in a worksheet, locate and click the _______ _____ button just below the name box to select every cell in the worksheet.

  • Select All
  • Fill Handle
  • Auto Fit
  • Auto Fill
  • 17. 
    _________ format is especially helpful when calculating things like the cost of sales tax or a tip.

  • Date
  • Percentage
  • Sum
  • Difference
  • 18. 
    Unique address of a cell that is the coordinate of the intersection of a row and a column:

  • entry bar
  • cell reference
  • name box
  • none of the above
  • 19. 
    Allows you to create clear and defined boundaries for different sections of your worksheet.

  • Cell Borders and Fill Colors
  • Headings
  • Font Size
  • Font Color
  • 20. 
    When is a MS Excel Spreadsheet used?

  • Making a Drawing
  • When Reading
  • For Collecting Information
  • For Baking a Cake
  • 21. 
    A quick way to include professional formatting for different parts of your workbook, such as titles and headers.

  • Font Color
  • Cell Style
  • Borders
  • Fill Color
  • 22. 
    In Microsoft Excel, the file you create and edit is called:

  • A form
  • A ledger
  • A table
  • A workbook
  • A record
  • 23. 
    To rename a worksheet: Right-click the worksheet you want to rename, then select __________ from the worksheet menu.

  • Rename
  • Open
  • 24. 
    The cell in a spreadsheet application in which data may be entered:

  • cell reference
  • name box
  • active cell
  • none of the above
  • 25. 
    At times, you may want to compare certain rows or columns without changing the organization of your worksheet. To do this you can __________ columns and rows.

  • Cut
  • Organize
  • View side by side
  • Hide
Report Question
warning
access_time
  Time