Excel 2016 - Module 3: Formatting A Worksheet

It is acceptable for dates to have a currency format.

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

You can apply formatting before or after you enter data in a cell or range.

Table styles are organized in four categories: Black & White, Light, Medium, and Dark.

You can change the font and font size of any cell or range using the Mini toolbar.

The Format Painter Button copies both the cell's content and formatting.

With Excel, you can adjust the width of one or more columns by using the mouse.

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

When you change a theme, cell styles are automatically updated.

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

You can add words to the dictionary of the spelling checker.

To check the spelling in more than one sheet of multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

The font size is measured in units called pixels.

Once you have formatted a range as a table, you can use Live Preview to view the table in other styles

To add an image to a worksheet, click Pictures in the Illustrations group on the Home tab.

Double-clicking the right edge of a column heading activates the AutoSize feature which automatically resizes the column to accommodate the widest entry in the column.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width.

After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references.

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme.

The _______ of a cell determines how the labels and values look

To format a cell or range, first you select it, and then you apply the formatting using the _______, the Mini toolbar, or a keyboard shortcut.

The default Accounting number format adds dollar signs and _______ decimal places to data.

Cells and ranges in a worksheet can be formatted _____.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect range of cells), click the Format as Table button in the ______ group on the Home tab, and then click a style in the gallery.

The _____ size is the physical size of the text.

In the _____ window you can search for online pictures (or Clip Art) in Office.com, through Bing search engine, or on OneDrive.

A ___ is an individual media file, such as art, sound, animation, or a movie.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

You can apply font styles and alignment options using the ____ dialog box.

Font ______ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

You can change the ____ labels and values in cells to be left, right, or center.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

To remove all formatting for a selected range, click the _______ button in the Editing group on the Home tab.

##### in a cell means ______.

The delete key removes only the contents of a selected row or column

To hide the selected column, click the _____ button in the Cells group on the Home tba.

You insert a comment in a worksheet by using a command on the _____ tab on the Ribbon.

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

You can use colors, patterns, and boarders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use Boarders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon

You can change colors, patterns, and borders of cells by using the Fill tab and the Border in the ____ dialog box

Cell ____ are predesigned combinations of formats.

___ shows you how a fill color will look before you apply it.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the ribbon.

____ formatting is automatically updated if you change data in the worksheet.

The default format for cells that meet a condition with conditional formatting is ___.

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

You can add multiple worksheets to a workbook by clicking the Home tab on the Ribbon, pressing and holding___, and then clicking the number of existing worksheets tabs that correspond with the number of sheets you want to add,clicking the Insert list arrow in the Cells group on the Home tab, then clicking insert sheet.

The Spelling button is found in the proofing group on the ___ tab on the Ribbon.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

The ____________ number format adds dollar signs and two decimal places to the data.

You can search for online pictures in Office.com, through the Bing search engine, or on OneDrive by typing one or more ____________, which are words related to your subject.

The ________ heading is the box at the top of each column containing a letter.

It can be difficult to see a(n) ________ when a cell is selected.

The color of a tab changes depending on whether it is the ________ tab.

What is meant by the format cell?

How do format a cell or range?

When do you apply formatting to a cell or range?

What does format painter do?

Explain why you would add colors, patterns, and borders to a worksheet.

Explain conditional formatting.