DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.
Detailed explanation-2: -In order to calculate how much time has elapsed since the start time to now, you simply use the NOW function to return today’s date and the current time, and then subtract the start date and time from it.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.
Detailed explanation-4: -To create a formula using the point-and-click method: Instead of typing cell addresses manually, you can point and click the cells you want to include in your formula. This method can save a lot of time and effort when creating formulas.