Marquee16 presentation-excel s2

Skills© Paradigm Publishing, Inc. 1 Skills© Paradigm Publishing, Inc. 1

Marquee Series Microsoft Excel 2016

Skills© Paradigm Publishing, Inc. 2 Skills© Paradigm Publishing, Inc. 2

SECTION 2 SKILLSEditing and Formatting Worksheets2.1Edit and Clear Cells and Cell Formats

2.1 Use Proofing Tools

2.2Insert and Delete Columns and Rows

2.3 Move and Copy Cells

2.3 Use Paste Options

2.4Adjust Column Width and Row Height

CHECKPOINT 1

2.5Change the Font, Size, Color, and Style

2.6 Format Numeric Cells

2.6 Adjust Decimal Places

2.7Change Cell Alignment and Indentation,

Use Repeat

2.8 Add Borders and Shading

2.8 Copy Formats with Format Painter

CHECKPOINT 2

2.9 Use Cell Styles and Themes

2.10 Use Find and Replace

2.11 Freeze and Unfreeze Panes

2.11 Change the Zoom

2.12 Insert, Move, and Resize Images

CHECKPOINT 3

Skills© Paradigm Publishing, Inc. 3

Edit and Clear Cells and Cell FormatsTo edit a cell:1. Double-click in the cell.2. Press the Right or Left Arrow key

to move the insertion point to the desired location within the cell.

3. Delete or Backspace as required.To edit a cell in the Formula bar:4. Click in the cell to be edited.5. Click in the Formula bar at the

desired location.6. Delete or Backspace as required.

Formula bar


Edit and Clear Cells and Cell Formats…continuedTo clear cells and cell formats:1. Select the range.2. Click the Clear button in the

Editing group on the Home tab.3. Click Clear All at the drop-down

list.

Clear button


Use Proofing ToolsTo check the spelling:1. Click the Review tab.2. Click the Spelling button in the Proofing group.3. Click the appropriate button at the Spelling dialog box.

Spelling dialog box


Use Proofing Tools…continuedTo use the Thesaurus:1. Click the Review tab.2. Click the Thesaurus button in

the Proofing group.3. Point to word in the Thesaurus

task pane.4. Click the down-pointing arrow.5. Click Insert at the drop-down

list.

Thesaurus task pane


Insert and Delete Columns and Rows Columns are inserted left of the active cell or selected

columns and existing columns are shifted right.

To insert columns or rows:1. Select the required number of columns or rows.2. Click the Insert button arrow in the Cells group.3. Click Insert Sheet Columns or Insert Sheet Rows.


Insert and Delete Columns and Rows…continuedTo delete columns or rows:1. Select the columns or rows to

be deleted.2. Click the Delete button arrow in

the Cells group.3. Click Delete Sheet Columns or

Delete Sheet Rows.OR4. Position the cell pointer over a

column indicator.5. Right-click the mouse.6. Click Delete at the shortcut

menu.

Delete button arrow

shortcut menu


Insert and Delete Columns and Rows…continuedTo insert cells:1. Select the range of cells you need to add.2. Click the Insert button in the Cells group.3. Select option in the Insert dialog box.To delete cells:4. Select the range of cells you need to

delete.5. Click the Delete button in the Cells group.6. Select option in the Delete dialog box.

Delete dialog box


Move and Copy CellsTo move or copy cells:1. Select the source cells.2. Click the Cut or Copy

button in the Clipboard group.

3. Select the starting destination cell.

4. Click the Paste button in the Clipboard group.

Paste button


Move and Copy Cells…continuedTo move a range of cells using drag and drop:1. Select the range.2. Point at any one of the four

borders surrounding the selected range.

3. Click and hold down the left mouse button.

4. Drag the top left corner of the range to the destination.

5. Release the mouse button.

four-headed arrow

destination range


Use Paste Options The Paste Options gallery appears in

three places:1. the Paste button arrow in the Clipboard

group2. the Paste Options button that appears

after an entry has been pasted into a cell3. the right-click shortcut menu

The gallery is divided into three sections:1. Paste2. Paste Values3. Other Paste Options

Within each section, buttons are included for various paste options.

Paste Options gallery


Adjust Column Width and Row HeightTo increase or decrease the column width:1. Select the column(s).2. Click the Format button in the

Cells group.3. Click the Column Width option.4. Type width in the Column

Width dialog box.5. Click OK.

Column Width dialog box

Format button


Adjust Column Width and Row Height…continuedTo adjust the column width using the mouse:1. Position the mouse pointer on the

boundary line to the right of a column indicator until the pointer changes to a vertical line with a left- and right-pointing arrow.

2. Hold down the left mouse button.3. Click and drag the boundary line to

the right.4. Release the mouse button.

boundary line


Adjust Column Width and Row Height…continuedTo increase or decrease the row height:1. Select the row(s).2. Click the Format button in

the Cells group.3. Click the Row Height

option.4. Type height in the Row

Height dialog box.5. Click OK.

Row Height dialog box

Format button


Adjust Column Width and Row Height…continuedTo adjust the row height using the mouse:1. Position the mouse pointer on the

boundary line below the desired row until the pointer changes to a horizontal line with an up- and down-pointing arrow.

2. Click and hold down the left mouse button.

3. Drag the boundary line down until the desired height displays.

4. Release the mouse button.

boundary line


CHECKPOINT 11) The contents of a cell can be

edited directly within the cell or in this.a. row indicatorb. column indicatorc. Clipboardd. Formula bar

3) This is the default column width measurement in characters.a. 4.11b. 4.21c. 8.11d. 8.21

2) This is the name of the selected cells being cut or copied.a. sourceb. destinationc. targetd. zone

4) This feature enables you to double-click the boundary line to set the width to fit the length of the longest entry within a column.a. AutoColumnb. AutoFitc. AutoWidthd. AutoEntry

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer


Change the Font, Size, Color, and StyleTo change the font:1. Select the cells.2. Click the Font option box

arrow in the Font group on the Home tab.

3. Click font.4. Deselect the cells.

Font option box arrow


Change the Font, Size, Color, and Style…continuedTo change the font size:1. Select the cells.2. Click the Font size option box


3. Click size.4. Deselect the cells.

Font size option box arrow


Change the Font, Size, Color, and Style…continuedTo change the font color:1. Select the cells.2. Click the Font Color button


3. Click color.4. Deselect the cells.

Font Color button arrow


Change the Font, Size, Color, and Style…continuedTo use the Format Cells dialog box:1. Select the cells.2. Click the Font group dialog

box launcher in the Font group on the Home tab.

3. Click color in the Format Cells dialog box.

4. Deselect the cells.

Format Cells dialog box


Format Numeric CellsTo change the numeric format:1. Select the cells.2. Click format style button in

the Number group on the Home tab.


Number group


Adjust Decimal PlacesTo adjust decimal places:1. Select the cells.2. Click either the Increase

Decimal button or the Decrease Decimal button in the Number group on the Home tab.

3. Deselect the cells.Increase Decimal button

Decrease Decimal button


Change Cell Alignment and IndentationTo change the horizontal or vertical alignment of cells:1. Select the cells.2. Click alignment button in the

Alignment group on the Home tab.


alignment buttons


To repeat a command:1. Press Ctrl + Y.To add the Repeat button to the Quick Access Toolbar:2. Click the Customize Quick Access Toolbar button.3. Click More Commands.4. At the Excel Options dialog box with Quick Access Toolbar

selected in the left pane, scroll down the left list box.5. Click Repeat.6. Click the Add button.7. Click OK.

Change Cell Alignment and Indentation…continued


Change Cell Alignment and Indentation…continuedTo wrap text within a cell:1. Select the cells.2. Click the Wrap Text

button in the Alignment group on the Home tab.


original cells

cells with Wrap Text applied


Add Borders and ShadingTo add borders:1. Select the cells.2. Click the Borders button


3. Click border style.4. Deselect the cells.

Borders button arrow


Copy Formats with Format PainterTo copy formats with Format Painter:1. Make the cell containing the

source formats active.2. Single-click or double-click the

Format Painter button in the Clipboard group on the Home tab.

3. Click the destination cell(s).4. If necessary, click the Format

Painter button to turn the feature off.

marquee


CHECKPOINT 21) This is the default font size used

by Excel.a. 9 pointb. 10 pointc. 11 pointd. 12 point

3) Use these to underscore headings or totals or to emphasize other cells.a. bordersb. shadingc. boldd. italics

2) By default, cells are initially set to this format.a. Normalb. Standardc. Defaultd. General

4) This feature copies formats from a selected cell to another cell.a. Cut and Pasteb. Copy and Pastec. Format Painterd. Format Copier

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer


Use Cell Styles and ThemesTo apply cell styles:1. Select the cells.2. Click the Cell Styles button in the Styles group on the Home tab.3. Click style in the drop-down gallery.

Cell Styles button


Use Cell Styles and Themes…continuedTo create a new style:1. Select a cell.2. Apply all formatting to the cell that

you want saved in the style.3. Click the Cell Styles button in the

Styles group on the Home tab.4. Click New Cell Style at the drop-

down gallery.5. At the Style dialog box, type a

name for the style in the Style name text box.

6. Click OK.

Style dialog box


Use Cell Styles and Themes…continuedTo apply a theme:1. Click the Page Layout tab.2. Click the Themes button in

the Themes group.3. Click theme in the drop-

down gallery.

Themes button


Use Find and ReplaceTo find a label or a value:1. Click the Find & Select

button in the Editing group on the Home tab.

2. Click Find.3. Type a label or value in

the Find what text box.4. Click the Find Next

button.

Find and Replace dialog box with Find tab selected


Use Find and Replace…continued

To replace a label or a value:1. Click the Find & Select

button in the Editing group on the Home tab.

2. Click Replace.3. Type a label or value in the

Find what text box.4. Type the replacement

label or value in the Replace with text box.

5. Click the Find Next button the or Replace All button.

Find and Replace dialog box with Replace tab selected


Freeze and Unfreeze PanesTo freeze panes:1. Make the cell active below

and to the right of the row or column headings you want to freeze.

2. Click the View tab.3. Click the Freeze Panes

button in the Window group.

4. Click Freeze Panes.

Freeze Panes button


Freeze and Unfreeze Panes…continuedTo unfreeze panes:1. Click the View tab.2. Click the Freeze Panes

button in the Window group.

3. Click Unfreeze Panes.

Freeze Panes button


Change the ZoomTo change the Zoom setting:1. Drag the Zoom slider bar.OR2. Click the Zoom In or

Zoom Out buttons.OR3. Click the zoom

percentage value.4. Choose the magnification

option at the Zoom dialog box.

Zoom dialog box

Zoom Out button

Zoom In button

Zoom slider bar


Change the Zoom…continuedTo zoom to a selection:1. Click the View tab.2. Click the Zoom button in

the Zoom group to display the Zoom dialog box.

Zoom button


Insert, Move, and Resize ImagesTo insert images:1. Click the Insert tab.2. Click the Online Pictures button in the

Illustrations group on the Home tab.3. Search for the image by typing a keyword in

the search box and then pressing Enter.4. Double-click the desired image.5. Move and/or resize as required. Insert Pictures window


Insert, Move, and Resize Images…continuedTo insert a picture:1. Click the Insert tab.2. Click the Pictures button in

the Illustrations group.3. Navigate to the drive

and/or folder in the Insert Picture dialog box.

4. Double-click the picture file.

5. Move and/or resize as required.

Insert Picture dialog box


CHECKPOINT 31) How many sections are

predefined cell styles grouped into?a. 2b. 3c. 4d. 5

3) This option causes rows and columns to remain fixed when scrolling.a. Freeze Panesb. Unfreeze Panesc. Lock Panesd. Unlock Panes

2) Changing this will cause the fonts, colors, and effects to change for the cells in the worksheet.a. themeb. fontc. borderd. shading

4) Images and pictures can be inserted using buttons on which tab?a. Homeb. Insertc. Page Layoutd. Data

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer

Marquee16 presentation-excel s2

Technology

Transcript of Marquee16 presentation-excel s2