1|Page
Smartsheet Core Product Certification Exam 1||
QUESTIONS AND CORRECT DETAILED ANSWERS||
VERIFIED EXAM!!!(VERIFIED ANSWERS) |ALREADY
GRADED A+||NEWEST EXAM!!!
Reference an entire Workspace for a Report - ANSWER-
"When you reference a workspace, the report will
automatically include any new sheets subsequently added
to the workspace.
Up to how many groups can I have in a report? -
ANSWER-You can choose up to 3 groups for a report
In a report, up to how many levels of sorting can you sort
by? - ANSWER-Up to 3 levels of sorting
TRUE - ANSWER-To change a column name in a report,
first change the column name in the underlying sheet
TRUE - ANSWER-Row hierarchies from underlying sheets
aren't displayed in reports"
, 2|Page
TRUE - ANSWER-Report formatting (font color,
background color, bold text, etc.) is based on the
formatting in the source sheet
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()
Smartsheet Core Product Certification Exam 1||
QUESTIONS AND CORRECT DETAILED ANSWERS||
VERIFIED EXAM!!!(VERIFIED ANSWERS) |ALREADY
GRADED A+||NEWEST EXAM!!!
Reference an entire Workspace for a Report - ANSWER-
"When you reference a workspace, the report will
automatically include any new sheets subsequently added
to the workspace.
Up to how many groups can I have in a report? -
ANSWER-You can choose up to 3 groups for a report
In a report, up to how many levels of sorting can you sort
by? - ANSWER-Up to 3 levels of sorting
TRUE - ANSWER-To change a column name in a report,
first change the column name in the underlying sheet
TRUE - ANSWER-Row hierarchies from underlying sheets
aren't displayed in reports"
, 2|Page
TRUE - ANSWER-Report formatting (font color,
background color, bold text, etc.) is based on the
formatting in the source sheet
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()
