Core Product Certification Practice Exam
1. Taryn created a report to view the tasks she's A: =JOIN(PARENT([Task Name]@row), " -
assigned to across multiple project plans. ")
However, she cannot see which projects or
The ANCESTORS() function returns an ar-
phases the tasks are associated with. Taryn
ray of all ancestor
wants to add a column to the sheets with a
rows of the current task row, which would
formula that automatically displays the pro-
include both the project name and the
ject name and phase name next to each task,
then add that column to her report. What phase name if they are organized
formula should Taryn use? hierarchically above the task. The JOIN()
function then concatenates these ances-
A: =JOIN(PARENT([Task Name]@row), " - ") tor values into a single string,
B: =PARENT([Task Name]@row) separated by " - ". This provides a com-
C: =ANCESTORS([Task Name]@row) plete reference to the project and phase
D: =JOIN(ANCESTORS([Task Name]@row), " - for each task.
")
2. Benjamin is creating an IF formula to display D: The cell reference of the % Complete in
specific Health symbols based on conditions the formula does not have square brack-
in his sheet. When a task has a value of 100% ets.
in the % Complete column, he wants to show
the green symbol. He is sure he typed in the All cell references in formulas must have
correct formula but gets an #UNPARSEABLE square brackets if the column name con-
error message. sists of more than 1 word or includes
What is the most likely cause for the error special characters.
message?
A: The % Complete column is locked.
B: The Health column is a symbol column,
which does not allow formulas.
C: The Health column is locked.
D: The cell reference of the % Complete in the
formula does not have square brackets.
, Core Product Certification Practice Exam
3. Priya is calculating profits for her small busi- B: Make the formula a column formula
ness. In her tracking sheet for sales, she uses
this formula to calculate the profit for each To ensure any new rows added to the
sale: sheet have this formula applied, Priya
should right-click a cell containing this
=[Quoted Amount]@row - [Actual formula, then choose Convert to Column
Cost]@row Formula from the menu options.
She wants to ensure that all future sales ap-
ply this formula automatically.
What is the most efficient way for her to ac-
complish this?
A: Create a conditional formatting rule
B: Make the formula a column formula
C: Copy the previous row and update the data
for each new sale
D: Create an automation
4. Amy is a project manager who is looking at A: The end dates in the underlying sheets
a report of the current status for all of her are based on dependencies
department's project schedules. She wants
to update the projected completion date in If dependencies are enabled in a sheet,
the report for one of the projects but she is users have to manually update the start
unable to edit that field in the report. What date or duration in the sheet. It is not
would cause Amy to be unable to edit the possible to update the end date in a
date in the report? sheet or report built on dependencies.
A: The end dates in the underlying sheets are
based on dependencies
B: The underlying sheets contain row hierar-
chies.
, Core Product Certification Practice Exam
C: Amy has Editor permissions on the under-
lying sheets.
D: The underlying sheets contain conditional
formatting
5. Benjy wants his associates to be able to up- B: Grant all associates Editor or higher
date the status of their tasks on a report he permissions on the report and the un-
has built. He also wants this updated infor- derlying sheets
mation to appear on the underlying sheets.
What does Benjy need to do to ensure his Users must have at least Editor permis-
associates can update both the report and sions on both the report and the source
the underlying sheets? sheet(s) to edit info in a report, which will
then populate back to the source sheets.
A: Create a Current User filter in the report
for each associate
B: Grant all associates Editor or higher per-
missions on the report and the underlying
sheets
C: Create a Sheet Summary report for all the
underlying sheets and share all associates to
it
D: Grant all associates Admin or higher
permissions on the report and underlying
sheets
6. Martha is an administrative clerk at Ajax Sys- C: Martha has surpassed the quantity of
tems. She manages a sheet tracking pur- files that can be uploaded at once.
chase requests. Each purchase request lives
on its own row and a Purchase Order must The maximum upload quantity is 100 files
be attached as documentation. Smartsheet at a time.
is not allowing her to attach 150 purchase
order documents to her sheet at once. What
1. Taryn created a report to view the tasks she's A: =JOIN(PARENT([Task Name]@row), " -
assigned to across multiple project plans. ")
However, she cannot see which projects or
The ANCESTORS() function returns an ar-
phases the tasks are associated with. Taryn
ray of all ancestor
wants to add a column to the sheets with a
rows of the current task row, which would
formula that automatically displays the pro-
include both the project name and the
ject name and phase name next to each task,
then add that column to her report. What phase name if they are organized
formula should Taryn use? hierarchically above the task. The JOIN()
function then concatenates these ances-
A: =JOIN(PARENT([Task Name]@row), " - ") tor values into a single string,
B: =PARENT([Task Name]@row) separated by " - ". This provides a com-
C: =ANCESTORS([Task Name]@row) plete reference to the project and phase
D: =JOIN(ANCESTORS([Task Name]@row), " - for each task.
")
2. Benjamin is creating an IF formula to display D: The cell reference of the % Complete in
specific Health symbols based on conditions the formula does not have square brack-
in his sheet. When a task has a value of 100% ets.
in the % Complete column, he wants to show
the green symbol. He is sure he typed in the All cell references in formulas must have
correct formula but gets an #UNPARSEABLE square brackets if the column name con-
error message. sists of more than 1 word or includes
What is the most likely cause for the error special characters.
message?
A: The % Complete column is locked.
B: The Health column is a symbol column,
which does not allow formulas.
C: The Health column is locked.
D: The cell reference of the % Complete in the
formula does not have square brackets.
, Core Product Certification Practice Exam
3. Priya is calculating profits for her small busi- B: Make the formula a column formula
ness. In her tracking sheet for sales, she uses
this formula to calculate the profit for each To ensure any new rows added to the
sale: sheet have this formula applied, Priya
should right-click a cell containing this
=[Quoted Amount]@row - [Actual formula, then choose Convert to Column
Cost]@row Formula from the menu options.
She wants to ensure that all future sales ap-
ply this formula automatically.
What is the most efficient way for her to ac-
complish this?
A: Create a conditional formatting rule
B: Make the formula a column formula
C: Copy the previous row and update the data
for each new sale
D: Create an automation
4. Amy is a project manager who is looking at A: The end dates in the underlying sheets
a report of the current status for all of her are based on dependencies
department's project schedules. She wants
to update the projected completion date in If dependencies are enabled in a sheet,
the report for one of the projects but she is users have to manually update the start
unable to edit that field in the report. What date or duration in the sheet. It is not
would cause Amy to be unable to edit the possible to update the end date in a
date in the report? sheet or report built on dependencies.
A: The end dates in the underlying sheets are
based on dependencies
B: The underlying sheets contain row hierar-
chies.
, Core Product Certification Practice Exam
C: Amy has Editor permissions on the under-
lying sheets.
D: The underlying sheets contain conditional
formatting
5. Benjy wants his associates to be able to up- B: Grant all associates Editor or higher
date the status of their tasks on a report he permissions on the report and the un-
has built. He also wants this updated infor- derlying sheets
mation to appear on the underlying sheets.
What does Benjy need to do to ensure his Users must have at least Editor permis-
associates can update both the report and sions on both the report and the source
the underlying sheets? sheet(s) to edit info in a report, which will
then populate back to the source sheets.
A: Create a Current User filter in the report
for each associate
B: Grant all associates Editor or higher per-
missions on the report and the underlying
sheets
C: Create a Sheet Summary report for all the
underlying sheets and share all associates to
it
D: Grant all associates Admin or higher
permissions on the report and underlying
sheets
6. Martha is an administrative clerk at Ajax Sys- C: Martha has surpassed the quantity of
tems. She manages a sheet tracking pur- files that can be uploaded at once.
chase requests. Each purchase request lives
on its own row and a Purchase Order must The maximum upload quantity is 100 files
be attached as documentation. Smartsheet at a time.
is not allowing her to attach 150 purchase
order documents to her sheet at once. What
