• 1. 
    To insert a new row, select the row heading _______ where you want the new row to appear.

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

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

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

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

  • Copy, Move
  • Copy, Select
  • 6. 
    ________ formats also allow you to work with a powerful set of ________ functions that use time and ________ information to calculate an answer.

  • Date
  • Number
  • 7. 
    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
  • 8. 
    To insert a new column, select the column heading to the _______ of where you want the new column to appear.

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

  • Merge and Center
  • Merge Across
  • 10. 
    You can select the desired cells and press ________ on your keyboard to access more number-formatting options.

  • Ctrl+1
  • Ctrl+F
  • 11. 
    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
  • 12. 
    _________ format is especially helpful when calculating things like the cost of sales tax or a tip.

  • Date
  • Percentage
  • Sum
  • Difference
  • 13. 
    Allows you to create clear and defined boundaries for different sections of your worksheet.

  • Cell Borders and Fill Colors
  • Headings
  • Font Size
  • Font Color
  • 14. 
    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
  • 15. 
    To rename a worksheet: Right-click the worksheet you want to rename, then select __________ from the worksheet menu.

  • Rename
  • Open
  • 16. 
    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
  • 17. 
    Excel 2016 will treat "October" as a

  • Date
  • Text string
  • 18. 
    To group worksheets: Select the first worksheet you want to include in the worksheet group. Press and hold the _______ ______ on your keyboard.

  • Ctrl Key
  • Group Key
  • 19. 
    The drop-down menu in the Number group is called the __________ drop-down.

  • Number Format
  • General
  • 20. 
    If you want to remove the content from a row or column without causing others to shift, right-click a heading, then select ________ Contents from the drop-down menu

  • Clear
  • Delete
  • 21. 
    If you select any cells with number formatting, you can see the actual value of the cell in the _______ _____.

  • formula bar
  • adjacent cell
  • 22. 
    To insert a new ________: Locate and select the New _____ button near the bottom-right corner of the Excel window.

  • Worksheet
  • Workbook
  • 23. 
    Excel allows you to insert new columns or rows, delete certain rows or columns, move them to a different location in the worksheet, or even ______ rows or columns.

  • Hide
  • Copy
  • 24. 
    _______ allows you to set a column's width to fit its content automatically.

  • Auto Fill
  • Resize
  • Fill Handle
  • Auto Fit
  • 25. 
    To access other date formatting options, select the Number Format drop-down menu and choose _______ Number Formats.

  • More
  • Date
Report Question
warning
access_time
  Time