SMARTSHEET CORE PRODUCT CERTIFICATION EXAM 380
ACTUAL QUESTIONS AND VERIFIED ANSWERS WITH
RATIONALE ALREADY GRADED A+
The Smartsheet Core Product Certification Exam validates a candidate's
foundational skills in using the Smartsheet work execution platform to build,
manage, and collaborate on projects. The exam covers key areas including
sheet creation and management, working with various views like Grid, Gantt,
Card, and Calendar, and utilizing reports and dashboards for data
aggregation and visualization. Candidates are tested on their ability to use
formulas, conditional formatting, and automation workflows to streamline
processes. The exam also assesses knowledge of sharing and permissions,
forms for data collection, and workspace organization. Passing this
certification demonstrates a user's proficiency in core Smartsheet
functionality
.
1. What can you customize when you insert a hyperlink into a cell?
A) The font size
B) The display text
C) The background color
D) The column width
Answer: B) The display text
Rationale: When inserting a hyperlink into a cell, you can customize the display
text that users will see and click on, making it more descriptive than the raw URL .
2. Which takes priority when a sheet has two conditional formatting rules that
conflict?
A) The rule with the oldest creation date
B) The rule at the top of the list
C) The rule at the bottom of the list
D) The rule with the most specific criteria
,Answer: B) The rule at the top of the list
Rationale: Conditional formatting rules are applied in order of priority from top to
bottom. The rule positioned highest in the list takes precedence over rules below it
.
3. Which type of user can create or own a sheet in Smartsheet?
A) Free user
B) Viewer
C) Editor
D) Licensed user
Answer: D) Licensed user
Rationale: Only licensed users have the permissions necessary to create new sheets
or own existing sheets in Smartsheet .
4. What permission level is required to hide and unhide columns in a sheet?
A) Editor
B) Viewer
C) Admin
D) Owner only
Answer: C) Admin
Rationale: The Admin permission level is required to hide and unhide columns, as
this affects the sheet's structure and how data is displayed to all collaborators .
5. Which view must include two date columns to be displayed?
A) Card View
B) Grid View
C) Gantt View
D) Calendar View
Answer: C) Gantt View
Rationale: Gantt View requires both a Start Date and an End Date column to
properly display the timeline and duration of tasks .
6. Which file type can you insert directly into a cell in Smartsheet?
A) .exe
B) .docx
C) .gif
D) .zip
Answer: C) .gif
Rationale: Smartsheet supports inserting image files like .gif directly into cells as
attachments or embedded content .
,7. Vivian uses a sheet to track a project. Several cells are cell-linked to a sheet that
the IT director uses. When Vivian updates her sheet, when do the linked cells on
the director's sheet update?
A) Immediately
B) When the director opens the sheet
C) When Vivian's sheet is saved
D) Once per hour
Answer: C) When Vivian's sheet is saved
Rationale: Cell links update when the source sheet is saved, ensuring the
destination sheet reflects the most current data from the source .
8. Which column type automatically tracks when a row was added to a sheet?
A) Modified (Date) column
B) Created (Date) column
C) System column
D) Auto-Number column
Answer: B) Created (Date) column
Rationale: The Created (Date) column type automatically records the date and time
when each row is added to the sheet .
9. Which three column types can enable Card View?
A) Contact List, Dropdown (Single Select), and Symbol
B) Text/Number, Date, and Dropdown
C) Contact List, Date, and Checkbox
D) Symbol, Text/Number, and Contact List
Answer: A) Contact List, Dropdown (Single Select), and Symbol
Rationale: Card View requires columns that can categorize rows into groups.
Contact List, Dropdown (Single Select), and Symbol columns can serve as the
grouping field .
10. Tyrone added the first task to his project plan, then moved to the next row.
What will automatically be copied down to the new row?
A) All column values
B) Formulas only
C) Formatting
D) Comments
Answer: C) Formatting
Rationale: When you add a new row immediately below an existing row, the
formatting from the row above is automatically copied down to the new row .
, 11. Alex must perform the same set of tasks for each webpage in a project. What is
the fastest way to add the tasks to the remaining webpages?
A) Manually type the tasks for each webpage
B) Copy the rows with tasks, then paste them under each webpage
C) Use a formula to copy the tasks
D) Create a separate sheet for each webpage
Answer: B) Copy the rows with tasks, then paste them under each webpage
Rationale: Copying and pasting entire rows is the most efficient method for
duplicating a standard set of tasks across multiple categories or projects .
12. Jason has a project charter as a PDF document. What is the recommended way
to include it in Smartsheet?
A) Copy and paste the text into a cell
B) Attach the file to the sheet
C) Convert it to an image and insert it
D) Link to the file on a network drive
Answer: B) Attach the file to the sheet
Rationale: Attaching files directly to the sheet keeps all relevant documentation
associated with the project in one accessible location .
13. How can you ensure a specific collaborator receives a notification about a
comment you make?
A) Send them an email separately
B) Mention them with the @ symbol in the comment
C) Assign them a task
D) Share the sheet with them
Answer: B) Mention them with the @ symbol in the comment
Rationale: Using the @mention feature in a comment notifies the specified
collaborator directly about the comment, regardless of their notification settings .
14. Shawn has sensitive budget data he does not want a subcontractor to view.
How can the subcontractor make updates to the project sheet?
A) Share the sheet with Viewer permission
B) Send an update request
C) Create a separate sheet for the subcontractor
D) Share the sheet and hide the budget columns
Answer: B) Send an update request
ACTUAL QUESTIONS AND VERIFIED ANSWERS WITH
RATIONALE ALREADY GRADED A+
The Smartsheet Core Product Certification Exam validates a candidate's
foundational skills in using the Smartsheet work execution platform to build,
manage, and collaborate on projects. The exam covers key areas including
sheet creation and management, working with various views like Grid, Gantt,
Card, and Calendar, and utilizing reports and dashboards for data
aggregation and visualization. Candidates are tested on their ability to use
formulas, conditional formatting, and automation workflows to streamline
processes. The exam also assesses knowledge of sharing and permissions,
forms for data collection, and workspace organization. Passing this
certification demonstrates a user's proficiency in core Smartsheet
functionality
.
1. What can you customize when you insert a hyperlink into a cell?
A) The font size
B) The display text
C) The background color
D) The column width
Answer: B) The display text
Rationale: When inserting a hyperlink into a cell, you can customize the display
text that users will see and click on, making it more descriptive than the raw URL .
2. Which takes priority when a sheet has two conditional formatting rules that
conflict?
A) The rule with the oldest creation date
B) The rule at the top of the list
C) The rule at the bottom of the list
D) The rule with the most specific criteria
,Answer: B) The rule at the top of the list
Rationale: Conditional formatting rules are applied in order of priority from top to
bottom. The rule positioned highest in the list takes precedence over rules below it
.
3. Which type of user can create or own a sheet in Smartsheet?
A) Free user
B) Viewer
C) Editor
D) Licensed user
Answer: D) Licensed user
Rationale: Only licensed users have the permissions necessary to create new sheets
or own existing sheets in Smartsheet .
4. What permission level is required to hide and unhide columns in a sheet?
A) Editor
B) Viewer
C) Admin
D) Owner only
Answer: C) Admin
Rationale: The Admin permission level is required to hide and unhide columns, as
this affects the sheet's structure and how data is displayed to all collaborators .
5. Which view must include two date columns to be displayed?
A) Card View
B) Grid View
C) Gantt View
D) Calendar View
Answer: C) Gantt View
Rationale: Gantt View requires both a Start Date and an End Date column to
properly display the timeline and duration of tasks .
6. Which file type can you insert directly into a cell in Smartsheet?
A) .exe
B) .docx
C) .gif
D) .zip
Answer: C) .gif
Rationale: Smartsheet supports inserting image files like .gif directly into cells as
attachments or embedded content .
,7. Vivian uses a sheet to track a project. Several cells are cell-linked to a sheet that
the IT director uses. When Vivian updates her sheet, when do the linked cells on
the director's sheet update?
A) Immediately
B) When the director opens the sheet
C) When Vivian's sheet is saved
D) Once per hour
Answer: C) When Vivian's sheet is saved
Rationale: Cell links update when the source sheet is saved, ensuring the
destination sheet reflects the most current data from the source .
8. Which column type automatically tracks when a row was added to a sheet?
A) Modified (Date) column
B) Created (Date) column
C) System column
D) Auto-Number column
Answer: B) Created (Date) column
Rationale: The Created (Date) column type automatically records the date and time
when each row is added to the sheet .
9. Which three column types can enable Card View?
A) Contact List, Dropdown (Single Select), and Symbol
B) Text/Number, Date, and Dropdown
C) Contact List, Date, and Checkbox
D) Symbol, Text/Number, and Contact List
Answer: A) Contact List, Dropdown (Single Select), and Symbol
Rationale: Card View requires columns that can categorize rows into groups.
Contact List, Dropdown (Single Select), and Symbol columns can serve as the
grouping field .
10. Tyrone added the first task to his project plan, then moved to the next row.
What will automatically be copied down to the new row?
A) All column values
B) Formulas only
C) Formatting
D) Comments
Answer: C) Formatting
Rationale: When you add a new row immediately below an existing row, the
formatting from the row above is automatically copied down to the new row .
, 11. Alex must perform the same set of tasks for each webpage in a project. What is
the fastest way to add the tasks to the remaining webpages?
A) Manually type the tasks for each webpage
B) Copy the rows with tasks, then paste them under each webpage
C) Use a formula to copy the tasks
D) Create a separate sheet for each webpage
Answer: B) Copy the rows with tasks, then paste them under each webpage
Rationale: Copying and pasting entire rows is the most efficient method for
duplicating a standard set of tasks across multiple categories or projects .
12. Jason has a project charter as a PDF document. What is the recommended way
to include it in Smartsheet?
A) Copy and paste the text into a cell
B) Attach the file to the sheet
C) Convert it to an image and insert it
D) Link to the file on a network drive
Answer: B) Attach the file to the sheet
Rationale: Attaching files directly to the sheet keeps all relevant documentation
associated with the project in one accessible location .
13. How can you ensure a specific collaborator receives a notification about a
comment you make?
A) Send them an email separately
B) Mention them with the @ symbol in the comment
C) Assign them a task
D) Share the sheet with them
Answer: B) Mention them with the @ symbol in the comment
Rationale: Using the @mention feature in a comment notifies the specified
collaborator directly about the comment, regardless of their notification settings .
14. Shawn has sensitive budget data he does not want a subcontractor to view.
How can the subcontractor make updates to the project sheet?
A) Share the sheet with Viewer permission
B) Send an update request
C) Create a separate sheet for the subcontractor
D) Share the sheet and hide the budget columns
Answer: B) Send an update request
