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
Skills© Paradigm Publishing, Inc. 4
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
Skills© Paradigm Publishing, Inc. 5
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
Skills© Paradigm Publishing, Inc. 6
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
Skills© Paradigm Publishing, Inc. 7
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.
Skills© Paradigm Publishing, Inc. 8
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
Skills© Paradigm Publishing, Inc. 9
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
Skills© Paradigm Publishing, Inc. 10
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
Skills© Paradigm Publishing, Inc. 11
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
Skills© Paradigm Publishing, Inc. 12
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
Skills© Paradigm Publishing, Inc. 13
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
Skills© Paradigm Publishing, Inc. 14
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
Skills© Paradigm Publishing, Inc. 15
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
Skills© Paradigm Publishing, Inc. 16
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
Skills© Paradigm Publishing, Inc. 17
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
Skills© Paradigm Publishing, Inc. 18
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
Skills© Paradigm Publishing, Inc. 19
Change the Font, Size, Color, and Style…continuedTo change the font size:1. Select the cells.2. Click the Font size option box
arrow in the Font group on the Home tab.
3. Click size.4. Deselect the cells.
Font size option box arrow
Skills© Paradigm Publishing, Inc. 20
Change the Font, Size, Color, and Style…continuedTo change the font color:1. Select the cells.2. Click the Font Color button
arrow in the Font group on the Home tab.
3. Click color.4. Deselect the cells.
Font Color button arrow
Skills© Paradigm Publishing, Inc. 21
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
Skills© Paradigm Publishing, Inc. 22
Format Numeric CellsTo change the numeric format:1. Select the cells.2. Click format style button in
the Number group on the Home tab.
3. Deselect the cells.
Number group
Skills© Paradigm Publishing, Inc. 23
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
Skills© Paradigm Publishing, Inc. 24
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.
3. Deselect the cells.
alignment buttons
Skills© Paradigm Publishing, Inc. 25
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
Skills© Paradigm Publishing, Inc. 26
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.
3. Deselect the cells.
original cells
cells with Wrap Text applied
Skills© Paradigm Publishing, Inc. 27
Add Borders and ShadingTo add borders:1. Select the cells.2. Click the Borders button
arrow in the Font group on the Home tab.
3. Click border style.4. Deselect the cells.
Borders button arrow
Skills© Paradigm Publishing, Inc. 28
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
Skills© Paradigm Publishing, Inc. 29
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
Skills© Paradigm Publishing, Inc. 30
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
Skills© Paradigm Publishing, Inc. 31
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
Skills© Paradigm Publishing, Inc. 32
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
Skills© Paradigm Publishing, Inc. 33
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
Skills© Paradigm Publishing, Inc. 34
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
Skills© Paradigm Publishing, Inc. 35
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
Skills© Paradigm Publishing, Inc. 36
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
Skills© Paradigm Publishing, Inc. 37
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
Skills© Paradigm Publishing, Inc. 38
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
Skills© Paradigm Publishing, Inc. 39
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
Skills© Paradigm Publishing, Inc. 40
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
Skills© Paradigm Publishing, Inc. 41
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