1|Page
SMARTSHEET CORE PRODUCT CERTIFICATION EXAM NEWEST
2025/2026 ACTUAL EXAM WITH COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
You can modify the name of the primary column - ANSWER-
Which statement about modifying reports is correct?
Row reports show rows from the grid, sheet summary reports
show fields from the sheet summary - ANSWER-"Which
describes the difference between a row report and a sheet
summary report?
Owner, Admin - ANSWER-Create, edit, share, and publish a
dashboard. View activity log
Viewer is needed on the source sheet - ANSWER-To add data in
a metric widget on a dashboard, you need to have at least which
permission level on the source sheet?
Which function can you use to add up numerical values? -
ANSWER-=SUM()
, 2|Page
Tricia has a task sheet where she is tracking both % Complete
and Status. Which function can she use to change the symbol in
the Status column based on the value in the % Complete column?
- ANSWER-=IF()
Jennifer is building a sheet to calculate commissions for her sales
team. They earn a fixed percentage of each sale they make. She
has entered the commission rate in a cell on her sheet. Which
formula can Jennifer copy and paste into each row to correctly
calculate her team's commissions? - ANSWER-
=SUM([Opportunity Value]@row * [Commission Rate]$1)
What symbols must you use when referencing another sheet? -
ANSWER-{} Braces
How do you reference the red ball in a symbol column in a
formula? - ANSWER-"Red"
Reginald is managing requests for his IT team using a sheet with
a form. Employees can request the completion date in the "Date
SMARTSHEET CORE PRODUCT CERTIFICATION EXAM NEWEST
2025/2026 ACTUAL EXAM WITH COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
You can modify the name of the primary column - ANSWER-
Which statement about modifying reports is correct?
Row reports show rows from the grid, sheet summary reports
show fields from the sheet summary - ANSWER-"Which
describes the difference between a row report and a sheet
summary report?
Owner, Admin - ANSWER-Create, edit, share, and publish a
dashboard. View activity log
Viewer is needed on the source sheet - ANSWER-To add data in
a metric widget on a dashboard, you need to have at least which
permission level on the source sheet?
Which function can you use to add up numerical values? -
ANSWER-=SUM()
, 2|Page
Tricia has a task sheet where she is tracking both % Complete
and Status. Which function can she use to change the symbol in
the Status column based on the value in the % Complete column?
- ANSWER-=IF()
Jennifer is building a sheet to calculate commissions for her sales
team. They earn a fixed percentage of each sale they make. She
has entered the commission rate in a cell on her sheet. Which
formula can Jennifer copy and paste into each row to correctly
calculate her team's commissions? - ANSWER-
=SUM([Opportunity Value]@row * [Commission Rate]$1)
What symbols must you use when referencing another sheet? -
ANSWER-{} Braces
How do you reference the red ball in a symbol column in a
formula? - ANSWER-"Red"
Reginald is managing requests for his IT team using a sheet with
a form. Employees can request the completion date in the "Date
