DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Automatic and Manual
|
|
|
Slow, Medium, and Fast
|
|
|
Manual and Automatic Except
|
|
|
Automatic, Manual and Automatic Except
|
Detailed explanation-1: -There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
Detailed explanation-2: -Automatic Calculation means that Excel will recalculate all dependent formulas when a cell value or formula is changed. Manual Calculation means that Excel will only recalculate when you force it to. This can be with a button press or keyboard shortcut.
Detailed explanation-3: -To recalculate all dependent formulas every time you make a change to a value, formula, or name, click Automatic. This is the default setting. To recalculate all dependent formulas-except data tables-every time you make a change to a value, formula, or name, click Automatic Except for Data Tables.