Marquee16 presentation-excel s1

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 1 SKILLSAnalyzing Data Using Excel

1.1 The Excel Screen

1.1 Save a Workbook

1.1 Print a Workbook

1.2 Enter Labels and Values

1.3 Navigate a Worksheet

1.4 Use Fill Options

1.5Perform Calculations Using Formulas

CHECKPOINT 1

1.6 Use the SUM Function

1.7 Copy Formulas

1.8 Use Undo and Redo

1.9 Improve the Worksheet Appearance

1.9 Display Formulas

CHECKPOINT 2

1.10 Use the Tell Me Feature

1.10 Use the Help Feature

1.11 Preview a Worksheet

1.11 Change Page Orientation

1.11 Print a Worksheet

CHECKPOINT 3

Skills© Paradigm Publishing, Inc. 3

The Excel ScreenQuick Access Toolbar

ribbon

Name box

worksheet area

Status barsheet tab

row

active cell

tabs

Formula bardialog box launcher

Title bar

column

group

Collapse the Ribbon button

scroll box

cell pointer

horizontal scroll bar

vertical scroll bar


Excel Screen Features

Feature Description

active cell location in the worksheet that will display typed data or that will be affected by a command

cell pointer select cells when you see this icon by clicking or dragging the mouse

Collapse the Ribbon button

click to remove the ribbon; double-click a tab to redisplay the ribbon

dialog box or task pane launcher

click the downward-pointing diagonal arrow at the bottom right in a group to open a dialog box or task pane with more options for that group

File tab displays the backstage area that contains options for working with and managing files


Excel Screen Features…continued

Feature Description

Formula bar displays the contents stored in the active cellName box displays the active cell address or name assigned to

active cellNew sheet button click the button to insert a new worksheet in the

workbookQuick Access Toolbar contains buttons for commonly used commands that

can be executed with a single mouse clickribbon area containing the tabs with commands and buttons

divided into groups


Excel Screen Features…continued

Feature Description

sheet tab identifies the worksheets in the workbookStatus bar displays current mode, action messages, view buttons,

and Zoom slider bartabs contains commands and buttons organized into groupsTitle bar displays workbook name followed by Microsoft Excelvertical and horizontal scroll bars

used to view various parts of the worksheet beyond the current screen

worksheet area contains cells used to create the worksheet


Save a WorkbookTo save a workbook with a new name:1. Click the File tab.2. Click the Save As option.3. Click folder in the Save As

backstage area.4. Type the new workbook

name.5. Click Save or press Enter.

Save As dialog box


Print a WorkbookTo print a workbook:1. Click the File tab.2. Click the Print option.3. Click the Print button.

Print button


Enter Labels and Values A label is an entry in a cell that helps the reader relate to the

values in the corresponding column or row. A value is a number, formula, or function that can be used to

perform calculations in the worksheet.

Take a few moments to plan or sketch out the layout of a new worksheet before entering labels and values. Decide the calculations you will need to execute and how to display the data so that it will be easily understood and interpreted.


Enter Labels and Values…continued

Cancel buttonEnter button

Entry appears in the Formula bar and in the active cell.


Enter Labels and Values…continued

long label


Navigate a WorksheetTo go to a specific cell:1. Click the Find &

Select button.2. Click Go To.3. Type the cell address

at the Go To dialog box.

4. Click OK.

Find & Select button

Go To dialog box


Navigate a Worksheet…continued

Press To move to

Arrow keys one cell up, down, left, or rightCtrl + Home cell A1Ctrl + End last cell in worksheetHome beginning of rowPage Down down one screenPage Up up one screenAlt + Page Down one screen to the rightAlt + Page Up one screen to the left


Use Fill OptionsTo use the fill handle:1. Click in cell to make the cell

active.2. Point at the fill handle. The

cell pointer changes from the large white cross to a thin black cross.

3. Click and hold down the left mouse button.

4. Drag the pointer into last cell in range.

5. Release the left mouse button.

fill handle


Use Fill Options…continued

Auto Fill Options button


Use Fill Options…continued

Auto Fill Options button


Perform Calculations Using Formulas A formula is entered into a cell to perform mathematical

calculations in a worksheet. All formulas in Excel begin with the equals sign (=) as the first

character. After the equals sign, the cell addresses that contain the values

you want to calculate are entered between mathematical operators.

The mathematical operators are: + (addition) – (subtraction) * (multiplication) / (division) ^ (exponentiation)


Perform Calculations Using Formulas…continuedTo enter a formula:1. Activate the cell in which

you want the result placed.2. Type =.3. Type the first cell address.4. Type the operator symbol.

formula

5. Type the second cell address.

6. Continue Steps 3-5 until finished.

7. Press the Enter key or click the Enter button.


Perform Calculations Using Formulas…continuedTo enter a formula using the pointing method:1. Activate the cell in which

you want the result placed.2. Type =.3. Click in the first cell.4. Type the operator symbol.5. Click in the second cell.6. Continue Steps 3-5 until

finished.7. Press the Enter key or click

the Enter button.

marquee


CHECKPOINT 11) This is what the intersection of a

column with a row is called.a. fill handleb. pointerc. insertion pointd. cell

3) This is the name of the small green square that displays at the bottom right corner of the active cell.a. fill handleb. pointerc. insertion pointd. cell

2) By default, values are aligned at what edge of the column?a. leftb. rightc. topd. bottom

4) Always type this symbol before entering a formula.a. asterisk (*)b. plus sign (+)c. equals sign (=)d. minus sign (-)

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer


Use the SUM FunctionTo enter the SUM function:1. Activate the cell in which you

want the result placed.2. Click the AutoSum button in the

Editing group on the Home tab.3. Press Enter, or drag to select the

correct range and press then Enter.

OR4. Drag to select the range of cells

to be summed, including the result cell.

5. Click the AutoSum button.

SUM function

SUM function


Copy Formulas

To copy a formula:1. Activate the source cell.2. Click the Copy button.3. Select the destination

cell(s).4. Click the Paste button.

marquee

Paste Options button


Copy Formulas…continued

fill handle


Use Undo and Redo Use the Undo button on the Quick Access Toolbar to reverse

the last action. Use the Redo button to restore an action that was reversed

using the Undo button. Excel stores up to 100 actions that can be undone or redone,

and you can repeat actions as many times as you need. Some actions (such as Save) cannot be reversed with Undo.


Improve the Worksheet Appearance

Decimal places are not consistent.

Labels do not align directly over values.


Improve the Worksheet Appearance…continuedTo format a range to the accounting number format:1. Select the range.2. Click the Accounting

Number Format button in the Number group on the Home tab.

Accounting Number Format button


Improve the Worksheet Appearance…continuedTo align labels at the right:1. Select the range.2. Click the Align Right button in

the Alignment group on the Home tab.

3. Click in any cell to deselect the range. Align Right button


Improve the Worksheet Appearance…continuedTo rotate text in cells:1. Select the range.2. Click the Orientation button in the

Alignment group on the Home tab.3. Select option.

Orientation button


Display FormulasTo display formulas:1. Click the Formulas tab.2. Click the Show Formulas button in

the Formula Auditing group.

Show Formulas button


CHECKPOINT 21) Use this built-in function to add a

range of values.a. ADD functionb. SUM functionc. TOTAL functiond. RANGE function

3) Excel uses up to how many decimal places when calculating values?a. 1b. 5c. 10d. 15

2) This is a temporary storage location used when copying.a. Clipboardb. Copyboardc. Storageboardd. Tempboard

4) This button is used to rotate text within cells.a. Orientationb. Rotatec. Angled. Text

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer


Use the Tell Me Feature

To use Tell Me feature:1. Click in the Tell Me text box.2. Type search text in the Tell

Me text box.3. Point to option in the drop-

down list.

Tell Me text box


Use the Help FeatureTo use Help with F1:1. Point to a button.2. Press the F1 function key.3. Scroll down the Help

window and click the subtitles to read the information available.

4. Close the Excel Help window.

Help subtitles


Use the Help Feature…continued

Home

Back

Forward

Print

Keep Help on Top

Use Large Text


Preview a WorksheetTo preview a worksheet:1. Click the File tab.2. Click the Print option.

Pages indicator


Change Page OrientationTo change the page orientation:1. Click the File tab.2. Click the Print option.3. Click the orientation gallery

in the Settings category.4. Click the orientation option.

Page Orientation gallery


Print a WorksheetTo print a worksheet:1. Click the File tab.2. Click the Print option.3. Click the Print button.

Print button


CHECKPOINT 31) Pressing this function key is one

way to access the Help window.a. F1b. F2c. F3d. F4

3) To display formulas, click the Show Formulas button on this tab.a. Formulasb. Homec. Insertd. View

2) In this orientation, the page is printed on paper taller than it is wide.a. scenicb. landscapec. portraitd. design

4) Pressing these keys will move the insertion point to cell A1.a. Alt + Page Downb. Alt + Page Upc. Ctrl + Endd. Ctrl + Home

Next Question

Next Question

Next Question

Next Slide

Answer

Answer

Answer

Answer

Technology

Marquee16 presentation-excel s1