DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If D3=30 and D4=20, what is the result of the function =IF(D4
|
|
10
|
|
|
Pick the other one
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -For example, ordering a set of numbers from greatest to smallest value means that you’re arranging them in descending order.
Detailed explanation-2: -By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
There is 1 question to complete.