Question

5.
is a rectangular block consisting o
column or the whole worksheet.
III. Write the format of the functions used in MS F
tasks:
1. To calculate the average of 82, 67, 80, 74 and 9
= AVERAGE (82,67.8.0.2
2. To find the highest value of the cell references f
= MAX. CD3: K3
3. To calculate the​

Answer 1

Explanation:

Home

Class 8 - APC Understanding Computer Studies with BlueJ

Spreadsheet: Functions and Charts

Chapter 2

Spreadsheet: Functions and Charts

Class 8 - APC Understanding Computer Studies with BlueJ

State whether the following statements are True/False

Question 1

A range of cells is a group of cells that have been selected and which form a shape of a rectangular box.

True

Question 2

A spreadsheet can only contain numeric data.

False

Question 3

You can insert a chart but not clipart in a worksheet.

False

Question 4

The cell in which the cell pointer is located in a worksheet is the active cell.

True

Question 5

You can select a range of data as per your choice in a spreadsheet.

True

Fill in the blanks

Question 1

Charts are the pictorial representation of data values stored in the worksheet.

Question 2

When the corresponding cell address changes with reference to a new cell address, it is known as relative reference.

Question 3

By default, MS Excel provides three worksheets in a workbook.

Question 4

The built-in formulae for specific numeric/non-numeric processing are called functions.

Question 5

A range of cells is a rectangular block consisting of a few cells, an entire row, an entire column or the whole worksheet.

Write the format of the functions used in MS Excel to perform the following tasks

Question 1

To calculate the average of 82, 67, 80, 74 and 95.

Answer

=AVERAGE(82,67,80,74,95).

To find the highest value of the cell references from D3 to K3.

Answer

=MAX(D3:K3)

I HOPE YOU LINKED

TEG ME A BRILLIANT

Answer 2

Answer:

first answer is

range cell is a rectangular block consisting o

column or the whole worksheet.