BCA FINAL EXAM STUDY GUIDE
QUESTIONS AND VERIFIED CORRECT
ANSWERS
button used to center a label across several columns in Excel - correct answer ✔✔Merge &
Center
a block of cells in an Excel worksheet - correct answer ✔✔range
A1 - correct answer ✔✔Relative cell reference
$A1 - correct answer ✔✔Mixed cell reference
$A$1 - correct answer ✔✔Absolute cell reference
allows you to copy formatting from one cell to another - correct answer ✔✔Format Painter
allows you to wrap text in an Excel cell to multiple lines - correct answer ✔✔wrap text
parentheses, exponents, multiplication, division, addition, subtraction - correct answer
✔✔Order of Operations
repeats the same information at the top of each printed page - correct answer ✔✔header
The default cell format in Excel - correct answer ✔✔General
, adds values in specified cells or a range together - correct answer ✔✔SUM function
If you enter an alphabetical character or a symbol as the first character in a cell - correct answer
✔✔label/text
a cell address in a formula that can change when you copy the formula to another location -
correct answer ✔✔relative cell reference
where rows and columns intersect - correct answer ✔✔cells
symbol that starts an Excel formula or function - correct answer ✔✔equal sign
where formulas appear in an Excel cell as they are typed in before hitting enter - correct answer
✔✔cell and formula bar
display in Excel when a column is too narrow - correct answer ✔✔pound signs (#######)
* - correct answer ✔✔multiplication
/ - correct answer ✔✔division
+ - correct answer ✔✔addition
- - correct answer ✔✔subtraction
^ - correct answer ✔✔exponents
QUESTIONS AND VERIFIED CORRECT
ANSWERS
button used to center a label across several columns in Excel - correct answer ✔✔Merge &
Center
a block of cells in an Excel worksheet - correct answer ✔✔range
A1 - correct answer ✔✔Relative cell reference
$A1 - correct answer ✔✔Mixed cell reference
$A$1 - correct answer ✔✔Absolute cell reference
allows you to copy formatting from one cell to another - correct answer ✔✔Format Painter
allows you to wrap text in an Excel cell to multiple lines - correct answer ✔✔wrap text
parentheses, exponents, multiplication, division, addition, subtraction - correct answer
✔✔Order of Operations
repeats the same information at the top of each printed page - correct answer ✔✔header
The default cell format in Excel - correct answer ✔✔General
, adds values in specified cells or a range together - correct answer ✔✔SUM function
If you enter an alphabetical character or a symbol as the first character in a cell - correct answer
✔✔label/text
a cell address in a formula that can change when you copy the formula to another location -
correct answer ✔✔relative cell reference
where rows and columns intersect - correct answer ✔✔cells
symbol that starts an Excel formula or function - correct answer ✔✔equal sign
where formulas appear in an Excel cell as they are typed in before hitting enter - correct answer
✔✔cell and formula bar
display in Excel when a column is too narrow - correct answer ✔✔pound signs (#######)
* - correct answer ✔✔multiplication
/ - correct answer ✔✔division
+ - correct answer ✔✔addition
- - correct answer ✔✔subtraction
^ - correct answer ✔✔exponents
