Functions: Exercise-1

Exercise-1
Functions
The most used functions in Excel are the functions that count and sum. You can count and sum based on one
criteria or multiple criteria
Count
To count the number of cells that contain numbers, use the COUNT function.

Countif
To count cells based on one criteria (for example, higher than 9), use the following COUNTIF function.

Sum
To sum a range of cells, use the SUM function.

Sum if
To sum cells based on one criteria (for example, higher than 9), use the following SUMIF function (two
arguments).

Exercise-2
A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
Create a Chart
To create a line chart, execute the following steps.
1. Select the range A1:D7.
2. On the Insert tab, in the Charts group, choose Line, and select Line with Markers.

Result:

Change Chart Type
You can easily change to a different type of chart at any time.
1. Select the chart.
2. On the Insert tab, in the Charts group, choose Column, and select Clustered Column.

Result:

Switch Row/Column
If you want the animals, displayed on the vertical axis, to be displayed on the horizontal axis instead, execute the
following steps.
1. Select the chart. The Chart Tools contextual tab activates.
2. On the Design tab, click Switch Row/Column.

Chart Title
To add a chart title, execute the following steps.
2. On the Layout tab, click Chart Title, Above Chart.

3. Enter a title. For example, Population.
Result:

Legend Position
By default, the legend appears to the right of the chart. To move the legend to the bottom of the chart, execute
the following steps.
2. On the Layout tab, click Legend, Show Legend at Bottom.

Result:

Data Labels
You can use data labels to focus your readers' attention on a single data series or data point.
2. Click an orange bar to select the Jun data series. Click again on an orange bar to select a single data point.
3. On the Layout tab, click Data Labels, Outside End.

Result:

Exercise-3
Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
Highlight Cells Rules
To highlight cells that are greater than a value, execute the following steps.
1. Select the range A1:A10.
2. On the Home tab, click Conditional Formatting, Highlight Cells Rules,
Greater Than...

3. Enter the value 80 and select a formatting style.

4. Click OK.
Result. Excel highlights the cells that are greater than 80.

5. Change the value of cell A1 to 81.
Result. Excel changes the format of cell A1 automatically.

Note: you can also highlight cells that are less than a value, between a low and high value, etc.
Clear Rules
To clear a conditional formatting rule, execute the following steps.

2. On the Home tab, click Conditional Formatting, Clear Rules, Clear Rules from Selected Cells.

Top/Bottom Rules
To highlight cells that are above the average of the cells, execute the following steps.

2. On the Home tab, click Conditional Formatting, Top/Bottom Rules, Above Average...

3. Select a formatting style.

4. Click OK.
Result. Excel calculates the average (42.5) and formats the cells that are above this average.

Exercise-4
Pie Chart
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one
data series.
To create a pie chart of the 2009 data series, execute the following steps.
1. Select the range A1:D2.
2. On the Insert tab, in the Charts group, choose Pie, and select Pie.

Result:

3. Click on the pie to select the whole pie. Click on a slice to drag it away from the center.
Result:

Note: only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not
recognize the numbers in column A as a data series and automatically creates the correct chart. After creating
the chart, you can enter the text Year into cell A1 if you like.

Note: only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not
recognize the numbers in column A as a data series and automatically creates the correct chart. After creating
the chart, you can enter the text Year into cell A1 if you like.

Functions: Exercise-1

Uploaded by

Copyright:

Available Formats

Functions: Exercise-1

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Functions: Exercise-1

Uploaded by

Copyright:

Available Formats

Exercise-1

You might also like