DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you see a range address of A1:B3, the range would include ____ ?
|
|
6 cells on 3 rows and in 2 columns.
|
|
|
6 cells on 2 rows and in 3 columns
|
|
|
4 cells on 6 rows and in 3 columns
|
|
|
4 cells on 3 rows and in 6 columns
|
Explanation:
Detailed explanation-1: -A cell range can also be referenced in a formula. A cell range is specified in a spreadsheet by the reference of the upper left cell (minimum value) and the reference of the lower right cell (highest value). The excel range notation A1:D6 denotes from upper left cell A1 to bottom right cell D6.
Detailed explanation-2: -Answer: To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.
Detailed explanation-3: -answer are. 1. =ADD (A1, A10) 2.
There is 1 question to complete.