CPSC Exam 1 UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest
integer. Which of the following formulas should he use?
a. =ROUND(AVERAGE(C3:C50),0)
b. =AVERAGE((C3:C50), ROUND, 0))
c. AVERAGE(ROUND(C3:C50),0)
d. =ROUND(C3:C50) - CORRECT ANSWER a. =ROUND(AVERAGE(C3:C50),0)
To create a workbook containing text, formulas, macros, and formatting that you use
repeatedly, you create a _____.
a. standard
b. template
c. master
d. model - CORRECT ANSWER b. template
An Excel table contains columns named Salary and Commission. Which of the following
formulas uses a structural reference to sum the values in the Salary through Commission
fields?
a. =SUM(Salary!Commission)
b. =SUM("Salary":"Commission")
c. =SUM([Salary]:[Commission])
d. =SUM(Salary:Commission) - CORRECT ANSWER c.
=SUM([Salary]:[Commission])
If the VLOOKUP function cannot find a match in the lookup table, what does it return?
, a. #N/A error value
b. #NAME error value
c. FALSE
d. "Match not found" message - CORRECT ANSWER a. #N/A error value
Bree added data labels to a pie chart, where they appear on each slice. She wants the data
labels to appear outside of the pie chart but close to each slice. Which Label Position option
should she select for the data labels?
a. Outside End
b. Overlay
c. Inside End
d. Center - CORRECT ANSWER a. Outside End
How can you hide the filter buttons in a table?
a. Clear the filters from the table.
b. Right-click a filter button and then click Remove.
c. Click the Filter Button check box in the Table Styles Options group.
d. Click a filter button and then click Hide. - CORRECT ANSWER c. Click the Filter
Button check box in the Table Styles Options group
In the formula =[SalesPrice]*.05, what do you call [SalesPrice]?
a. structural reference
b. 3-D reference
c. external reference
d. absolute reference - CORRECT ANSWER a. structural reference
QUESTIONS AND CORRECT ANSWERS
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest
integer. Which of the following formulas should he use?
a. =ROUND(AVERAGE(C3:C50),0)
b. =AVERAGE((C3:C50), ROUND, 0))
c. AVERAGE(ROUND(C3:C50),0)
d. =ROUND(C3:C50) - CORRECT ANSWER a. =ROUND(AVERAGE(C3:C50),0)
To create a workbook containing text, formulas, macros, and formatting that you use
repeatedly, you create a _____.
a. standard
b. template
c. master
d. model - CORRECT ANSWER b. template
An Excel table contains columns named Salary and Commission. Which of the following
formulas uses a structural reference to sum the values in the Salary through Commission
fields?
a. =SUM(Salary!Commission)
b. =SUM("Salary":"Commission")
c. =SUM([Salary]:[Commission])
d. =SUM(Salary:Commission) - CORRECT ANSWER c.
=SUM([Salary]:[Commission])
If the VLOOKUP function cannot find a match in the lookup table, what does it return?
, a. #N/A error value
b. #NAME error value
c. FALSE
d. "Match not found" message - CORRECT ANSWER a. #N/A error value
Bree added data labels to a pie chart, where they appear on each slice. She wants the data
labels to appear outside of the pie chart but close to each slice. Which Label Position option
should she select for the data labels?
a. Outside End
b. Overlay
c. Inside End
d. Center - CORRECT ANSWER a. Outside End
How can you hide the filter buttons in a table?
a. Clear the filters from the table.
b. Right-click a filter button and then click Remove.
c. Click the Filter Button check box in the Table Styles Options group.
d. Click a filter button and then click Hide. - CORRECT ANSWER c. Click the Filter
Button check box in the Table Styles Options group
In the formula =[SalesPrice]*.05, what do you call [SalesPrice]?
a. structural reference
b. 3-D reference
c. external reference
d. absolute reference - CORRECT ANSWER a. structural reference
