Intro to Business Analytics Exam 2
Questions & Answers
Verifiability - ANSWERSMakes spreadsheet easy to understand and minimizes
erroneous data entry
Data validation - ANSWERSDefine rules to limit data entry to reasonable values
Worksheet protection - ANSWERSRestricts entry into cells containing headings and
calculations
Unlock data entry cells - ANSWERSWhat is the first step in creating worksheet
protection
Turn worksheet protection on - ANSWERSWhat is the second step in creating
worksheet protection
Dollar sign - ANSWERSWhat do you put in front on an entry if you want it to remain
static
B1 - ANSWERSWhat is the value when you copy A1 horizontally
A2 - ANSWERSWhat is the value when you copy A1 vertically
Relative - ANSWERSThe type of referencing where there are no dollar signs/constant
values
Absolute - ANSWERSThe type of referencing where there are dollar signs to keep
specific values constant
$A1 - ANSWERSWhat is the value when you copy $A1 horizontally
$A2 - ANSWERSWhat is the value when you copy $A1 vertically
B$1 - ANSWERSWhat is the value when you copy A$1 horizontally
A$1 - ANSWERSWhat is the value when you copy A$1 vertically
$A$1 - ANSWERSWhat is the value when you copy $A$1 horizontally
$A$1 - ANSWERSWhat is the value when you copy $A$1 vertically
Questions & Answers
Verifiability - ANSWERSMakes spreadsheet easy to understand and minimizes
erroneous data entry
Data validation - ANSWERSDefine rules to limit data entry to reasonable values
Worksheet protection - ANSWERSRestricts entry into cells containing headings and
calculations
Unlock data entry cells - ANSWERSWhat is the first step in creating worksheet
protection
Turn worksheet protection on - ANSWERSWhat is the second step in creating
worksheet protection
Dollar sign - ANSWERSWhat do you put in front on an entry if you want it to remain
static
B1 - ANSWERSWhat is the value when you copy A1 horizontally
A2 - ANSWERSWhat is the value when you copy A1 vertically
Relative - ANSWERSThe type of referencing where there are no dollar signs/constant
values
Absolute - ANSWERSThe type of referencing where there are dollar signs to keep
specific values constant
$A1 - ANSWERSWhat is the value when you copy $A1 horizontally
$A2 - ANSWERSWhat is the value when you copy $A1 vertically
B$1 - ANSWERSWhat is the value when you copy A$1 horizontally
A$1 - ANSWERSWhat is the value when you copy A$1 vertically
$A$1 - ANSWERSWhat is the value when you copy $A$1 horizontally
$A$1 - ANSWERSWhat is the value when you copy $A$1 vertically
