Preview

07 - Formatting in Excel

 1. Excel provides numerous predefined table styles that you can use to quickly format a table

  FALSE

  TRUE

 2. You can further adjust the table formatting by choosing __________ for table elements, such as Header and Total Rows, First and Last Columns, Columns, as well as Auto Filtering

  Far fetched options

  B style options

  Quick Styles options

  Kind options

 3. There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. By default all cells are ____________________.

  formatted with the Text format

  formatted with the General number format

  formatted with the currency format

  formatted with the bordered autonumber format

 4. With the General format, anything you type into the cell is usually changed into text. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as EAFWQTY.

  TRUE

  FALSE

 5. You can position text and numbers, change the orientation and specify text control in cells by using the ___________in the Format Cells dialog box.

  Data tab

  Alignment tab

  Formulas tab

  Fill tab

 6. Use the Patterns tab in the Format Cells dialog box to set the background color of the selected cells. You can also use the Pattern list to apply two-color patterns or shading for the:

  text inside a cell

  text in the comment that is outside each cell

  border of a cell

  background of a cell

 7. The Protection tab offers you two options for protecting your worksheet data and formulas:

  Lost and Found

  Open and Accessible

  Open and Blocked

  Locked and Hidden

 8. Selecting the ___________ option decreases the font size of the text in a cell until all the contents of the cell can be displayed

  find to fit

  seam to fit

  enlarge to fit

  shrink to fit

 9. The Merge Cells option ____________________________.

  combines the text in two or more cells without touching the cell

  combines two or more selected cells into a single cell.

  splits a cell into several multi-cells

  deletes any cell attached to a merged cell

 10. The date format option allows you to select the ____________ from the Type list box.

  style of the date

  fill colour of the background of the cell that will contain the date

  colour of the date

  alignment of the date