Question

enter the formula in the excel to determine he highest price of the book purchased by you in cell c10​

Answer 1

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