07 - Formatting in Excel

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



 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

  Far fetched options

  B style 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 currency format

  formatted with the General number format

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



 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

  Data tab

  Formulas 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 in the comment that is outside each cell

  text inside a cell

  background of a cell

  border of a cell

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

  Lost and Found

  Locked and Hidden

  Open and Accessible

  Open and Blocked

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

  enlarge to fit

  shrink to fit

  find to fit

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

  deletes any cell attached to a merged cell

  splits a cell into several multi-cells

 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