KEMBAR78
Exercises No. 1: ST ND RD TH | PDF | Science Software | Spreadsheet Software
Scribd
Upload
64 views1 page

Exercises No. 1: ST ND RD TH

1. The document provides instructions for completing 3 exercises in Microsoft Excel involving creating worksheets, entering data, using formulas, and inserting a chart. 2. The first exercise has students enter student data and scores in a worksheet and use formulas to calculate totals. 3. The second exercise adds another worksheet to calculate student averages from their grades. 4. The third exercise inserts a pie chart to show the breakdown of daily expenses.

Uploaded by

MeAnnLarrosa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
64 views1 page

Exercises No. 1: ST ND RD TH

1. The document provides instructions for completing 3 exercises in Microsoft Excel involving creating worksheets, entering data, using formulas, and inserting a chart. 2. The first exercise has students enter student data and scores in a worksheet and use formulas to calculate totals. 3. The second exercise adds another worksheet to calculate student averages from their grades. 4. The third exercise inserts a pie chart to show the breakdown of daily expenses.

Uploaded by

MeAnnLarrosa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

NAME: ___________________________________________ SCORE 1: ______ SCORE 2: ______ SCORE 3: ______

GRADE & SECTION: _________________________________ DATE: ______________

Exercises No. 1

1. Open MS Excel 2016 > Blank Workbook


2. Enter the information in the spreadsheet below. Be sure that the information is entered in the same cells as
given, or the formulas below will not work.

A B C D E F G H
1 STUDENT NAME LRN QUIZ 1 QUIZ 2 QUIZ 3 QUIZ 4 TOTAL
2 50 20 50 30
3 1 BERNARDO, KATHRYN 99228811 45 17 38 30
4 2 CHIU, KIM 52764729 40 18 48 29
5 3 CURTIS, ANNE 82562098 46 15 46 28
6 4 DELA TORRE, MOIRA 15715787 39 19 44 29
7 5 SOBERANO, LIZA 25872656 45 20 48 28

3. Enter the formula into cell H2 and copy it into cells H3 to H7 using AUTOFILL SERIES, adding cells QUIZ 1 to
QUIZ 4 to get the TOTAL.

Exercises No. 2

1. Add another WORKSHEET in the same workbook, name it GRADES.


2. Enter the information in the spreadsheet below.

A B C D E F G H
1 STUDENT NAME LRN 1st 2nd 3rd 4th AVERAGE
2 1 BERNARDO, KATHRYN 99228811 90 98 89 93
3 2 CHIU, KIM 52764729 98 97 90 95
4 3 CURTIS, ANNE 82562098 97 99 95 96
5 4 DELA TORRE, MOIRA 15715787 98 95 94 90
6 5 SOBERANO, LIZA 25872656 90 98 91 97

3. In cell h2, type the formula to add the grades in 1st to 4th and divide them into 4.

EXERCISES NO. 3

1. Add another WORKSHEET in the same workbook, name it CHART.


2. Enter the information in the spreadsheet below.

A B
1 MY DAILY ALLOWANCE
2 TRANSPORTATION 20%
3 LUNCH 40%
4 SNACK 25%
5 0THER EXPENSES 15%
6 TOTAL 100%

3. Select the cells. Click INSERT > CHARTS GROUP > choose PIE CHART.

You might also like