BCA FINAL EXAM STUDY GUIDE QUESTIONS AND CORRECT ANSWERS GRADED A+

BCA FINAL EXAM STUDY
GUIDE QUESTIONS AND
CORRECT ANSWERS
GRADED A+ 2025-2026
Merge & Center - ANS-button used to center a label across several columns in Excel


range - ANS-a block of cells in an Excel worksheet


Relative cell reference - ANS-A1


Mixed cell reference - ANS-$A1


Absolute cell reference - ANS-$A$1


Format Painter - ANS-allows you to copy formatting from one cell to another


wrap text - ANS-allows you to wrap text in an Excel cell to multiple lines


Order of Operations - ANS-parentheses, exponents, multiplication, division, addition,
subtraction


header - ANS-repeats the same information at the top of each printed page


General - ANS-The default cell format in Excel

, SUM function - ANS-adds values in specified cells or a range together


label/text - ANS-If you enter an alphabetical character or a symbol as the first
character in a cell


relative cell reference - ANS-a cell address in a formula that can change when you copy
the formula to another location


cells - ANS-where rows and columns intersect


equal sign - ANS-symbol that starts an Excel formula or function


cell and formula bar - ANS-where formulas appear in an Excel cell as they are typed in
before hitting enter


pound signs (#######) - ANS-display in Excel when a column is too narrow


multiplication - ANS-*


division - ANS-/


addition - ANS-+


subtraction - ANS--


exponents - ANS-^


The purpose of Excel - ANS-to analyze business, personal, or financial data