STUDY GUIDE4th Grade

January-February 2018Teacher: Miss Isela Gzz

Technology and Application: Monday February 12th , 2018.

4th Grade 3rd Period

Topic Definitions / Resources

Microsoft Excel Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.

ADD INFORMATION

IN CELLS

If you want to add information in the cells don’t forget to check the correct cell in which you are going to introduce the information. Example: type “HELLO” in the cell B2

SELECT THE CORRECT RANGE

OF CELLS

Use the left button to select the range of cells that you want.

ADD A BORDER TO ONE

SPECIFYC RANGE OF

CELLS

Select the range of cells that you want, click on the right button and select the option that says FORMAT CELLS

In the following window that its going to appear select BORDER and choose the type of line that you want and in which cell you want the border. At the end click in OK

ADD A GRAPHIC BAR

To add a graphic bar select the range of cells and the numbers that you want to graph, click on INSERT then in CHARTS select the option that says COLUMN and click in one 2-D column chart.

Using the SUM Function

There are different ways to use a SUM FUCTION

Option # 1

AUTOSUM

Select the range of entries that are to be totaled (including the cell in which the subtotal is to appear).

Click on the AutoSum button.

Option # 2

Type the formula by Yourself, Don’t Forget that each formula is going to start with an equal (=)

EXAMPLE:

=SUM(A1:A5)

Change the font of the text

To change the font and position of the text, select the text you want to edit, and in home you will find a lot of options in font and alignment.

Bold, Underline, and Italicize

You can bold, underline, or italicize when you are using Word.

STEPS: First highlight the text you wish to format and then click the formatting button on the format toolbar.

- Bold button

- Italicize button

- Underline

Changing Font Color

• Select the text you want to change the color of.

• Click the Text button on the Formatting toolbar.

• Select the desired color by clicking on the arrow on the right hand side.

• When completed, click once on the Text button to deactivate it.