DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Groups from worksheets
|
|
|
A group of several cells
|
|
|
Meeting between rows and columns
|
|
|
Worksheet in excel
|
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: -The range is the difference between the highest and lowest values in a set of numbers.
Detailed explanation-3: -Select the data (including any summary rows or columns). On the Data tab, in the Outline group, click Group > Group Rows or Group Columns. Optionally, if you want to outline an inner, nested group-select the rows or columns within the outlined data range, and repeat step 3.
Detailed explanation-4: -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.