Preview

07 - Formatting in Excel

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

  TRUE

  FALSE

 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

  Quick Styles options

  Kind options

  B style options

  Far fetched 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 currency format

  formatted with the bordered autonumber format

  formatted with the General number format

  formatted with the Text 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.

  Alignment tab

  Fill tab

  Formulas tab

  Data 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:

  border of a cell

  text inside a cell

  background of a cell

  text in the comment that is outside each cell

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

  Lost and Found

  Open and Blocked

  Locked and Hidden

  Open and Accessible

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

  shrink to fit

  find to fit

  seam to fit

  enlarge 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.

  alignment of the date

  style of the date

  colour of the date

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