MS Excel | MCQs

Explanation

=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.

The colon : denotes a continuous range of cells.

Explanation

Let's calculate:

F7 = 12

H12 = 30

Formula: F7 * H12 = 12 * 30 = 360

Explanation

Explanation

In MS Excel, the SQRT(number) function is used to calculate the square root of a given number.

Example: =SQRT(25) will return 5.

Explanation

In Microsoft Excel, the divide symbol is a forward slash (/).

Explanation

 To insert the current date into an Excel cell, use the TODAY() function.

Simply type =TODAY() in the cell and press Enter. 

Explanation

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

Formula palette is used to create and edit formula.

It is also possible to type a function directly into a cell.