COM 113 EXAM 1 FINAL STUDY PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
●● Spreadsheet. Answer: an electronic file of columns and rows that is
used to:organize related data and perform calculations
●● Worksheet. Answer: single spreadsheet
●● Workbook. Answer: file containing multiple related worksheets
●● Columns. Answer: letters
●● Rows. Answer: numbers
●● Excel supports 4 types of data. Answer: text, values (numbers),
dates, formulas (calculations using values in other cells)
●● Values. Answer: numbers that represent quantities
◦ Can be used in a calculation
●● Text. Answer: can contain numeric digits, but does not represent a
quantity
, ◦ Examples: phone number, social security number
●● Formulas. Answer: calculations using values in other cells (can
contain a function)
●● Order of Order of Precedence (operations). Answer: controls the
sequence in which math operators are computed
◦ Parentheses
◦ Exponentiation
◦ Multiplication and Division
◦ Addition and Subtraction
●● Range. Answer: rectangular group of cells
●● Nonadjacent Range. Answer: contains a group of more than one
selected ranges
●● Formatting. Answer: accentuates and draws attention to meaningful
portions of a worksheet
◦ Use colors, borders, alignments, etc. to accentuate
◦ Numeric formats give numbers meaning
●● Chapter 2. Answer: Formulas and Functions
QUESTIONS WITH ANSWERS GRADED A+
●● Spreadsheet. Answer: an electronic file of columns and rows that is
used to:organize related data and perform calculations
●● Worksheet. Answer: single spreadsheet
●● Workbook. Answer: file containing multiple related worksheets
●● Columns. Answer: letters
●● Rows. Answer: numbers
●● Excel supports 4 types of data. Answer: text, values (numbers),
dates, formulas (calculations using values in other cells)
●● Values. Answer: numbers that represent quantities
◦ Can be used in a calculation
●● Text. Answer: can contain numeric digits, but does not represent a
quantity
, ◦ Examples: phone number, social security number
●● Formulas. Answer: calculations using values in other cells (can
contain a function)
●● Order of Order of Precedence (operations). Answer: controls the
sequence in which math operators are computed
◦ Parentheses
◦ Exponentiation
◦ Multiplication and Division
◦ Addition and Subtraction
●● Range. Answer: rectangular group of cells
●● Nonadjacent Range. Answer: contains a group of more than one
selected ranges
●● Formatting. Answer: accentuates and draws attention to meaningful
portions of a worksheet
◦ Use colors, borders, alignments, etc. to accentuate
◦ Numeric formats give numbers meaning
●● Chapter 2. Answer: Formulas and Functions