DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A group of selected cells.
|
|
|
A cell that is selected.
|
|
|
A feature that enables you to repeat the same data in a column or row.
|
|
|
An Excel term for a spreadsheet.
|
Detailed explanation-1: -To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
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: -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.
Detailed explanation-5: -The range is the difference between the highest and lowest values in a set of numbers.