CramX Logo
RegisterLog in
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Document preview page 1

2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 1

Document preview content for 2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions)

2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions)

Understand common exam pitfalls with 2024 Smartsheet Core Product Computer Science Certification Exam With Answers, a detailed past exam collection.

Lucas Taylor
Contributor
4.3
0
11 months ago
Preview (11 of 36 Pages)
100%
Log in to unlock
Page 1 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 1 preview imageSMARTSHEET CORE PRODUCTCERTIFICATION EXAM NEWEST 2024COMPLETE 150 QUESTIONS ANDCORRECT DETAILED ANSWERS(VERIFIED ANSWERS) |ALREADYGRADED A+Which column type would be best for visually representing(via color) the status of a row item? This could also beautomatically changed using a formula.Symbol columnDropdown List columnText/Number columnSystem Generated column-...ANSWER...Symbol columnWhich three of the following items can be viewed without aSmartsheet account?FormPublished dashboardReport in a workspace shared to youUpdate request-...ANSWER...Form, Published dashboard,and Update request
Page 2 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 2 preview image
Page 3 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 3 preview imageWhich three of the following file types can be uploadedusing the image widget?PDFPNGGIFJPEG-...ANSWER...PNG, GIF, JPEGHow can you add more fields to your report beyond whatfields are used as criteria?From the File menu select Add More ColumnsIn the Report Builder, click the Columns button and selectadditional columnsAdd a column to a source sheet. This new column willautomatically be displayed in the report.In the toolbar, click the Report Tool and select additionalcriteria-...ANSWER...In the Report Builder, click theColumns button and select additional columnsCell linking is done at which of the following levels?RowColumnSheetCell-...ANSWER...CellForms can be used to collect information from individualsinside or outside your organization. Which two of thefollowing use cases could a form support?Survey responses
Page 4 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 4 preview imageMarketing requestsUpdate the status of a taskResource hub-...ANSWER...Survey responses andMarketing requestsThe Notification Center: (select the two optionsthat apply)Displays a red icon when new notifications arriveAllows a user to create new alertsAllows a user to view and fulfill update requestsAllows a user to forward a notification to a different user-...ANSWER...Displays a red icon when new notificationsarrive and alloWs a user to view and fulfill update requestsA snapshot of a sheet or report can be shared via email usingthe "Send as Attachment..." action. The sheet can be sentonce or on a recurring basis. Select the two file formats theattachment can be sent as.ExcelPDFCSVPNG-...ANSWER...Excel and PDFWhen viewing a sheet, you want to have certain rows grabyour attention, if the task is at risk or past its due date. Youcan accomplish this by using which feature?Highlight changesConditional formattingAlertsFormat painter-...ANSWER...Conditional formatting
Page 5 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 5 preview imageThe "Send..." action, available from the row menu, allowsyou to provide a view-only version of one or more rows toanyone you specify. Which two of the following options canbe customized?File format of the rows (PDF or Excel)Custom message to recipientDelivery recurrence (once, every hour, every day, etc.)Columns included-...ANSWER...Custom message torecipient and columns includedWhich feature allows licensed collaborators [with at leastEditor permissions] to audit changes made to the sheet?Conditional formattingActivity logView cell historyHighlight changes-...ANSWER...Activity LogHow is tagging a shared collaborator in a comment, via theuse of @mention, an effective means of collaboration?It shares that collaborator a published view of the sheet sothey can view the comment.It instantly sends the @mentioned individual an alert withthe comment.It begins keeping track of the @mentioned individual withinactivity log.
Page 6 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 6 preview imageIt adds the @mentioned individual to your My SmartsheetContacts-...ANSWER...It instantly sends the @mentionedindividual an alert with the comment.I have a handful of tasks that are falling behind schedule andI want to quickly view which items are marked "Red" in myproject status column.To identify this informationWITHOUT having to leave the sheet, I should:Turn on highlight changesWrite a formulaCreate a filterSend an update request to my collaborators-...ANSWER...Create a filterDate based alerts help keep collaborators awareof keyproject dates. Date based alerts can be triggered on aspecific date or based off a date in any date column. Whichof the following is a possible use case for establishing a datebased alert?Samuel wants to automatically inform his boss when thestatus of a task becomes at-riskSamuel wants to notify all collaborators when a task is overbudgetSamuel wants to be sent an email five days before the startof each task so he can check in with keycollaboratorsSamuel wants to automatically let external vendors knowwhen a task is not complete-...ANSWER...Samuel wants tobe sent an email five days before the start of each task so hecan check in with key collaborators
Page 7 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 7 preview imageAuto-fill is automaticallyapplied by Smartsheet withinevery sheet. Which two of the following functions doesauto-fill perform?Copy manual update requests to generate recurring updatesContinue patterns of formattingApply formulas and adjust cell references to adjacent rowsGenerate a numeric value based on conditional formattingrules-...ANSWER...Continue patterns of formattingApply formulas and adjust cell references to adjacent rowsThe ___________ widget uses a URL or embed code tosurface interactive content on a dashboard.TitleReportImageWeb Content-...ANSWER...Web ContentIn order to enable Card View, your sheet must have a leastone of three specific column types. Two of those columnsare dropdown list and symbol. What is the third columntype?Date columnText/Number columnSystem Generated columnContact List column-...ANSWER...Text/Number columnChanges in cell formatting can be used to capture theattention of a user. Which of the following features allowscollaborators to see updates since they last viewed the sheet?
Page 8 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 8 preview imageConditional formattingFormat painterSymbol column typeHighlight changes-...ANSWER...Highlight changesWhen entering formulas in Smartsheet, cell references usethe syntax of column name and row number. What symbolmust be placed around a column name when it includes aspace, special character, or number?{ } Curly brackets[ ] Square brackets< > Angle brackets( ) Parentheses-...ANSWER...[ ] Square bracketsWhen adding a new collaborator to a sheet or workspace,what should be customized to help the new collaboratorunderstand why they are being added and how they shoulduse the information?CollaboratorsPermissionsPersonal messageDefault View-...ANSWER...Personal MessageWhich view must include two date columns in order to bedisplayed?CardGanttCalendar
Page 9 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 9 preview imageGrid-...ANSWER...GanttYou are using Smartsheet to plan, track and manage aproject. In creating your sheet, you are assigning tasks tocollaborators. You need to make a decision on whether touse multiple single contact list columns or enable multiplecontacts to be assigned within a single cell. You understandthat it best to enable multiple contacts to be assigned withina single cell when multiple people are working on the sametask. In what scenario is it best to use multiple contact listcolumns?When you want to create a filter for each individualWhen some individuals are inside your team's account andothers are notWhen you want to pull a report from a sheetWhen the individuals have different roles related to a task-...ANSWER...When the individuals have different rolesrelated to a taskDaenerys has a project sheet that includes a dropdown listcolumn. Her coworker needs to add additional options to thedropdown list column options in Jen's sheet. Whatpermission level would her coworker need for Daenerys'sheet?Editor-can't shareViewerAdminEditor-can share-...ANSWER...Admin
Page 10 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 10 preview imageWhich function leverages sheet hierarchy to reference therange of rows that are indented below another row?ANCESTORS()CHILDREN()PARENT()INDEX()-...ANSWER...Children()John is currently managing the development of a newproduct. He has a team of four individuals with whom heassigns various tasks. John wants to quickly see tasksassigned to each person and reassign tasks as needed. Whichof the options below would be the most efficient way forJohn to accomplish this?John needs to create and use a filter for each assignee andthen return to the sheet to reassign tasks.John needs to publish the sheet to his team and allow themto email suggestions on task reassignment.John needs to utilize card view to view by the assigned tocontact column. He could then view and reassignaccordingly.John needs to build a report for each person on his team.From each of the reports, Juan would reassign tasks.`-...ANSWER...John needs to utilize card view to view by theassigned to contact column. He could then view and reassignaccordingly.You can share a collaborator to which two of the following?FolderWorkspace
Page 11 of 11
2024 Smartsheet Core Product Computer Science Certification Exam With Answers (113 Solved Questions) - Page 11 preview imageResource ViewSheet-...ANSWER...Workspace and SheetWhich collaboration feature allows the recipient to make aone time change to your sheet without sharing them as acollaborator to the sheet?Share a sheetAn update requestPublishSend a row-...ANSWER...An update requestYou want to keep track of newattachments as they areadded to a sheet. Which of the following is the best way toachieve this goal?Create a conditional formatting rule to highlight rows withnew attachmentsAudit Activity Log dailyCreate an alert to notify you when an attachment is added orchangedInstruct collaborators to @mention you in the commentsafter an attachment has been uploaded-...ANSWER...Create an alert to notify you when anattachment is added or changedWhich of the following file types can be imported as a newsheet in Smartsheet? (select the four that apply)MS ProjectJIRA ProjectExcel
Preview Mode

This document has 36 pages. Sign in to access the full document!

Study Now!

X-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Subject
Information Technology

Related Documents

View all
Class Notes

DevOps and Its Importance Study Notes

Past Exams

Veeam Certified Engineer VMCE-V12

Past Exams

Modules 1 - 3 Basic Network Connectivity and Commu

Class Notes

Notes CCNA

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 20

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 22

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 36

Class Notes

Foundations of Novell Networking Section 26

Class Presentation

Modulo 7 DHCPv4

Class Notes

Build and troubleshooting Integration Challenge