PPM

easseg0vas

excel_basic_commands_review_2-1.xlsx

Home >Business & Finance homework help >Management homework help >PPM

Sheet1

EXCEL BASIC COMMANDS REVIEW

To enter numbers or text:

Place cursor at cell A5 and type "Group 1", place cursor at cell B5 and type "2"

Test scores

Group 1

Group 2

Group 3

Group 4

Group 5

-3

To get the:

Type:

Result:

Mode of an array (b5-b9)

=MODE(B5:B9)

Median

=MEDIAN(B5:B9)

Average

=AVERAGE(B5:B9)

1.8

Sum

=SUM(B5:B9)

Largest valuue

=MAX(B5:B9)

Smallest value

=MIN(B5:B9)

-3

Correlation

=CORREL(B5:B9,E5:E9)

0.86

To:

Type:

Result:

Add numbers at B5 and B7:

=b5+b7

Use value (number or formula) in another cell (C13)

=c13

Divide a number (B5) by another number (B7)

=b5/b7

0.6666666667

To convert a value to its absolute value (B9)

=abs(b9)

Methodologies:

Do:

Result:

To control the decimel points in a number (C23)

Place the cursor at cell C23→right-click→left-click on "Format Cells"→left-click on "Number"→click up-arrow in "Decimel Places" box→stop at 2→ left-click the OK box

0.67

Note: the symbol "→" means then or next

To format text so that it fits in one cell

Place the cursor on the cell with the text (D27)→tight-click→left-click on "Format Cells" →left-click on "Alignment"→ left-click on "Wrap Text" box (you may need to expand the cell)

Cell with text to format

To copy a value or text from one cell (B5) to another cell (C29)

Place the cursor at the copy-from cell (B5)→right-click then left-click on "Copy"→move the cursor to the copy-to cell (C29)→right-click then left-click on the first icon under "Paste Options"

To change the format of a number (C23)

Place the cursor on the number (C23)→right-click then left-click on "Format cells"→left-click on a category ("Percentage")→select the number of decimel points (1)→left-click the OK box

66.7%

To copy an array of values from one set of cells (B5-B9) to another (C31-C35)

Place the cursor at the top left corner of the copy-from array (B5)→while holding down the left button move the cursor to the bottom right corner of the array (b9)→right-click and left-click on "copy"→place the cursor at the cell in the top-left corner of the copy-to area (C31)→right-click then left-click on the first icon under "Paste Options"

-5

Mode:

To copy a formula from one cell (C36) to another cell (D37) using the same set of reference values

Before copying, the cells in the formula need to be converted to be non-relative, that is, not dependent upon the formula's cell location which is done by inserting a "$" on both sides of the letter of the cell (i.e., "$B$5)

To copy a formula from one cell (C36) to another cell (C43) using a different set of reference values

The new reference values (C38:D42) must be in the same location relative to the copy-to cell (C43) as they are in the copy-from cell (C36)

-6

Mode:

To create charts & graphs

To create a chart (using cells

Place cursor at A5→left-click & drag the cursor to

A5-B5)

highlight A5-A9→left-click "Insert" (at top of the screen)

of page)→left-click on "Recommended Charts"→left-click to select one of the

recommended charts that are shown or left-click on the "All charts" tab to

review other possible charts.

To move a chart:

Place cursor in an open spot on the

chart→left-click and hold→drag (move

the mouse)

"Series 1" is the default legend title. Since there is only one category of data, this can be eliminated.

Place cursor on "series 1"→left-click→hit Delete key

To re-size a chart:

Place cursor at the tip of any corner→left-click

(two-pointed diagonal arrow will appear)→move

the mouse move toward the center of the chart to

reduce its size, away from the center to enlarge

To insert a chart title:

Place cursor in an open spot on the chart and left-click→left-click on "Design"

at the top of the screen under "Chart Tools"→left-click on "Add Chart Element"

on the far left side of the screen→left-click on "Chart Title"→left-click on "Above

Chart"→place cursor in the "Chart Title" box, left-click and type in the

actual chart title (in this case, "Group Results")

To insert a chart axis title:

Place cursor in an open spot on the chart and left-click→left-click on "Design"

at the top of the screen under "Chart Tools"→left-click on "Add Chart Element"

on the far left side of the screen→left-click on "Axis Titles"→select the axis by

left-clicking on either "Primary Horizontal" or "Primary Vertical"and type in the

actual axis title

To reposition a chart axis title:

Place the cursor on one of the axis title elements (e.g., "Group 1")→ left-click

on "Format Axis" in the box that appears→ left-click on "Labels" in the large box

that appears and left-click on the preferred Label Position from the drop-down

menu (in this case, "Low")

To change title font:

Left-click cursor on "Chart Title"→right-click→left-click on

"Font..."→left-click on down-arrow in Latin Text Font box→

left-click on new font→left-click on OK button

To edit title:

Left-click on title→left-click again (to imbed the cursor in

title)→type in changes

To change the fill:

Left-click on one of the bars→right-click then left-click on "Format Data Series"

→left-click on the pouring bucket icon→left-click on the "Color" menu arrow→

left-click on black (top box second column)→left-click on "Pattern Fill" and select

a pattern

To copy a graph to Word:

Place the cursor inside the graph near the edge and left-click→right-click and

then left-click on "Copy"→open or create the Word file, hit the Enter key once

or twice to move the graph away from the top margin (or the preceding graph

or text)→right-click and then left-click on the first "Paste Options" icon.