COM 113 EXAM 1 EXAM SCRIPT 2026
QUESTIONS WITH ANSWERS GRADED A+
●● In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
a)5/6
b)1+
c)(2-3)
d)6^2. Answer: c) (2-3)
●● In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
a)5/6
b)1+
c)(2-3)
d)6^2. Answer: d) 6^2
●● What does it mean when you see ######## in a cell?. Answer:
column isn't wide enough
●● Which Paste option would you choose if you wanted to flip the rows
and columns?
A)Transpose
B)Rotate
, C)Flip
D)Formulas. Answer: a) transpose
●● If you wanted to reference a cell in a formula and you did not want
that cell to change when copying and pasting you would use what kind
of reference?
AFixed
BRelative
CMixed
DAbsolute. Answer: d) absolute
●● If a cell containing =B$14 is copy and pasted three columns over and
two rows down, what would the resultant cell reference become?
A)E$14
B)$E$14
C)B16
D)B$16. Answer: a) E$14
●● What punctuation is used to separate the two cell references in a
range?
A)Period ( . )
B)Semi-colon ( ; )
C)Comma ( , )
QUESTIONS WITH ANSWERS GRADED A+
●● In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
a)5/6
b)1+
c)(2-3)
d)6^2. Answer: c) (2-3)
●● In the formula, =1+(2-3)+5/6-6^2, what will Excel evaluate second?
a)5/6
b)1+
c)(2-3)
d)6^2. Answer: d) 6^2
●● What does it mean when you see ######## in a cell?. Answer:
column isn't wide enough
●● Which Paste option would you choose if you wanted to flip the rows
and columns?
A)Transpose
B)Rotate
, C)Flip
D)Formulas. Answer: a) transpose
●● If you wanted to reference a cell in a formula and you did not want
that cell to change when copying and pasting you would use what kind
of reference?
AFixed
BRelative
CMixed
DAbsolute. Answer: d) absolute
●● If a cell containing =B$14 is copy and pasted three columns over and
two rows down, what would the resultant cell reference become?
A)E$14
B)$E$14
C)B16
D)B$16. Answer: a) E$14
●● What punctuation is used to separate the two cell references in a
range?
A)Period ( . )
B)Semi-colon ( ; )
C)Comma ( , )
