DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Label
|
|
|
Value
|
|
|
Formula
|
|
|
Text string
|
Detailed explanation-1: -In Excel Date format is considered as value.
Detailed explanation-2: -In B$2, you lock the row coordinate to tell Excel always to pick the multiplier in row 2. The column coordinate is relative because the multipliers are in 3 different columns and the formula should adjust accordingly.
Detailed explanation-3: -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-4: -To display an individual comment, right-click on the cell right-click the cell and select Show/Hide Comments. To display all comments in the worksheet, go to the Review tab > Show all Comments.
Detailed explanation-5: -An Excel cell accepts only maximum 32767 characters.