2024 Excel Crash Certification Exam With Answers (150 Solved Questions)

Preview (11 of 36 Pages)

100%

Purchase to unlock

Loading page image...

SMARTSHEET 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

Loading page image...

Which 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

Loading page image...

Marketing 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

Loading page image...

The "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.

Loading page image...

It 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

Loading page image...

Auto-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?

Loading page image...

Conditional 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

Loading page image...

Grid-...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

Loading page image...

Which 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

Loading page image...

Resource 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!

Report

Study Now!

Document Details

Related Documents

SAP S/4HANA Sales Certification Guide: Application Associate Exam (2021)

SAP S/4HANA Business Process Integration Certification Guide: Application Associate Exam (2021)

SAP HANA 2.0 Certification Guide: Technology Associate Exam (2021)

SAP S/4HANA Production Planning and Manufacturing Certification Guide: Application Associate Exam (2022)

2024 Ornamental And Turf Pesticide Applicator Practice Exam With Answers (78 Solved Questions)

State of Colorado Question and Verified Answers with Answers (40 Solved Questions)

LETRS Unit 4 Assessment with Answers (15 Solved Questions)

COG170 Cogito Epic Training Fundamentals Practice Exam with Answers (220 Solved Questions)

2023 AVID Media Composer 101 Certification Practice Exam with Answers (233 Solved Questions)

Prophecy General ICU RN A v2 with Answers (55 Solved Questions)

Company

Explore

Study Tools