FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is a range in Excel?
A
An individual space
B
A group of cells
C
data inputs
D
pages
Explanation: 

Detailed explanation-1: -A cell range in Ms Excel is a collection of chosen cells. It can be referred to in a formula. This is defined in a spreadsheet with the reference of the upper-left cell as the minimum value of the range and the reference of the lower-right cell as the maximum value of the range.

Detailed explanation-2: -A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well.

Detailed explanation-3: -RANGE. A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent. Commands executed by Excel will affect the entire range. A range is identified by the cell references of the cells in the upper left and lower right corners of the range.

Detailed explanation-4: -The range is the difference between the highest and lowest values in a set of numbers.

Detailed explanation-5: -Data ranges Data range represents a cell, a row, a column, or a selection of cells that contain one or more continuous blocks of cells. A data range is specified by the range expression. In the Excel stage, you can use a range expression to specify the data range to extract.

There is 1 question to complete.