# Excel Spreadsheet Practice Exercises

|**Excel Spreadsheet Practice Exercises** – In Practice your basic level of Excel: formats, keyboard shortcuts, autofill …, you will find five exercises to perform your basic level of Excel.

The first and second exercises to practice the formats, the third to practice the formulas, the fourth series and the fifth self-completion.

You can help with the exercises with the different articles related to this site.

**Excel spreadsheet practices (basic level)**

**1. Department of Technology 3º ESOExcelPractica 1Activity**

1: “SCALES” spreadsheet 1. Open Excel: Start / programs / Excel. Save the file with the name of computer nº- name and surname-practice1 in your folder: My PC / Disk D / 3º ….

2. In the sheet 1 write and complete the data that appear in the image (the operations to be carried out of indicate in the own imageActivity 2: Spreadsheet “Relative formulas”

3. On sheet 2, do the same with the data that appears in the image. 3: “Absolute formulas” spreadsheet

4. In sheet 3 do the same with the data that appears in the image Note that we put the signs $ so that when the fill controller is activated, the value that appears in A1 is always fixed in the formula

**2. Technology Department 3º ESOPráctica 2Activity**

1: “Office budget” worksheet Write and complete the data that appears in the image The formula in D3 will be: = b3 * c3 The formula in D13 will be: = SUM (D3: D11) The formula in D14 will be: = D13 * 0.16 The formula in D15 will be: = D13 + D145. You must retouch the format of the cells by putting borders and shading (lines on edge and fill color) Activity

2: “Bath budget” worksheet 6. Create a new sheet In this new sheet write and complete the data that appears in the image. You must put the necessary formulas yourself and change the format of the cells where necessary (Format, cell, currency) 2

**3. Technology Department 3 º ESOPráctica 3: **

Sheet 1: “ELECTRICAL CONSUMPTION DATA” • Complete with data, borders, fills and formats. • Establishes the necessary formulas to calculate the average

Sheet 2: GRAPHIC ELECTRICAL CONSUMPTION “3

4. **Department of Technology 3º ESOPráctica 4: **

Sheet 1: Generation and consumption of electricity in Spain Years 2000-20085 Annual evolution of the coverage of electricity demand (Gwh) Energies not Energies GenerationYear% Non-renewable% Renewable renewable renewables neta2000 168,845 26,6412001 176,038 30,2782002 177,744 35,402,003 187,560 41,4052004 205,563 45,8682005 203,917 49,996,7006 211,969 50,0172007 215,070 56,5652008 212,003 66,298Formulas: Net generation: the sum of non-renewable energies and renewable energies% Non-renewable: Non-renewable energies / Net generation %% Renewable: Renewable energies / Generation net% Graphs to be prepared: Sheet 2: Electricity consumption in Spain: Years-Net generation Electricity consumption in Spain (GWh) 300,000 250,000 200,000 GWh 150,000 100,000 50,000 0 2000 2001 2002 2003 2004 2005 2006 2007 2008 Years 3 and following.Realizes 9 pie charts comparing% Non-renewable -% Renewable. One p Every year. Change the name of the sheet and write the corresponding year. Year 2000: Generation of electricity in Spain in the year 2000 14% 86%% Non-renewable% Renewable 4

**5. Technology Department 3º ESOPráctica 5: **

Activity 1. “Functions” Sheet

1.- Using functions build and complete the following table:

2.- Save the sheet with the name Functions ABC A + B + C 2A- (B + C ) AxB / C AxA + BC 1 6 41 2 9 23 3 5 36 4 12 15 5 4 17 6 21 60

ACTIVITY 2: Sheet “AVERAGE / COUNT ONLY”

1. Copy the data table

2. You must insert some formulas: a. In cell D26: = AVERAGE (D9: D25) b. In cell B27: = COUNTIF (D9: D25; “<5”) c. In cell B28: = COUNTIF (D9: D25; “> = 5”)

Activity 3: Sheets “Invoice and Graphs”

Make the following spreadsheet and insert different types of graphs from the data in the table. Pen Pencil Notebook Invoice Dictionary Invoice 12 € Dictionary 10 € 8 € Notebook Article Price 6 € Pencil 4 € 2 € Pen 0 € 2 € 4 € 6 € 8 € 10 € 12 € 0 € Pen Price Pen Notebook Dictionary Article 5

I hope you find it useful, remember that you can write your doubts to the email.