COM 113 EXAM 1 ACTUAL EXAM PAPER
2026 QUESTIONS WITH SOLUTIONS
GRADED A+
●● In this formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
Answer: (2-3)
PEMDAS
(Parenthesis, Exponents, Multiplication, Diviision, Addition,
Subtraction)
●● In this formula,=1+(2-3)+5/6-6^2, what will Excel evaluate second?
Answer: 6^2
PEMDAS
(Parenthesis, Exponents, Multiplication, Diviision, Addition,
Subtraction)
●● What does it mean when you see "######" in a cell? Answer: Your
column is not wide enough
●● Which Paste option would you choose if you wanted to flip the rows
and columns? Answer: Transpose
,●● What should you do if there are columns you need, but do not want
to display? Answer: Hide the columns you do not want to display, then
unhide them when finished
●● Which of the following is NOT a way to widen a column? Answer:
In the Page Layout tab, Scale to Fit group, select Automatic in the Width
drop-down box
●● What can you NOT do within the worksheet tabs shortcut menu?
Answer: Format the worksheet
●● What would NOT be a typical item to have in a header or footer?
Answer: The file size
●● 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? Answer: 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?
Answer: E$14
●● If a cell contains =$N$21 and two new columns are inserted in front
of column N and three rows are inserted above row 21, what happens to
the =$N$21? Answer: It becomes =$P$24
, ●● What punctuation is used to separate the two cell references in a
range? Answer: Colon ( : )
●● What does Excel use to indicate optional arguments in a function?
Answer: Square Brackets [ ]
●● Which of the following would not give the same result for
"=(5+32+75+8)/4"? Answer: A. =SUM(5,32,75,8)/4
B. =MEDIAN(5,32,75,8)+10
C. =AVERAGEIF(5+32+75+8,
D. =AVERAGE(5,32,75,8)
ANSWER-D
=AVERAGEIF(5+32+75+8,4)
●● IF A7=21, which of the following =IF statements would produce the
result of "Much Greater" Answer: A. =IF(A7>14, "Greater", IF(A7>20,
"Much Greater", "Not Greater than 20"))
2026 QUESTIONS WITH SOLUTIONS
GRADED A+
●● In this formula, =1+(2-3)+5/6-6^2, what will Excel evaluate first?
Answer: (2-3)
PEMDAS
(Parenthesis, Exponents, Multiplication, Diviision, Addition,
Subtraction)
●● In this formula,=1+(2-3)+5/6-6^2, what will Excel evaluate second?
Answer: 6^2
PEMDAS
(Parenthesis, Exponents, Multiplication, Diviision, Addition,
Subtraction)
●● What does it mean when you see "######" in a cell? Answer: Your
column is not wide enough
●● Which Paste option would you choose if you wanted to flip the rows
and columns? Answer: Transpose
,●● What should you do if there are columns you need, but do not want
to display? Answer: Hide the columns you do not want to display, then
unhide them when finished
●● Which of the following is NOT a way to widen a column? Answer:
In the Page Layout tab, Scale to Fit group, select Automatic in the Width
drop-down box
●● What can you NOT do within the worksheet tabs shortcut menu?
Answer: Format the worksheet
●● What would NOT be a typical item to have in a header or footer?
Answer: The file size
●● 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? Answer: 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?
Answer: E$14
●● If a cell contains =$N$21 and two new columns are inserted in front
of column N and three rows are inserted above row 21, what happens to
the =$N$21? Answer: It becomes =$P$24
, ●● What punctuation is used to separate the two cell references in a
range? Answer: Colon ( : )
●● What does Excel use to indicate optional arguments in a function?
Answer: Square Brackets [ ]
●● Which of the following would not give the same result for
"=(5+32+75+8)/4"? Answer: A. =SUM(5,32,75,8)/4
B. =MEDIAN(5,32,75,8)+10
C. =AVERAGEIF(5+32+75+8,
D. =AVERAGE(5,32,75,8)
ANSWER-D
=AVERAGEIF(5+32+75+8,4)
●● IF A7=21, which of the following =IF statements would produce the
result of "Much Greater" Answer: A. =IF(A7>14, "Greater", IF(A7>20,
"Much Greater", "Not Greater than 20"))
