Domain One: Sheets - Smartsheet Certification Questions with correct Answers 2023

Domain One: Sheets - Smartsheet Certification Questions with correct Answers 2023 Primary Column - is mandatory - required to use #s or text - cannot be deleted Configurable Columns text/number, contact list, date, dropdown, symbols System generated columns who did what and when it was done Image rules - one image per cell - formats allowed: PNG, GIF, JPJ - maximum file size: 30 MB Changing Language Date Format 1. Click Account > Personal Settings 2. Click settings in left pane 3. Under regional preferences, select the desired value from drop down list Who can add columns? Admin and owners Sheet Summary provides a standard location to define, organize, and report on custom project, business, and summary level information Summary Field Types text/number, contact list, date, dropdown list, checkbox, symbols Who can create conditional formatting rule? only owner or admin Conditional formatting allows you to create rules on your sheet, whereby the formatting of one cell of entire rows will update when certain criteria is met Steps to creating conditional format rule 1. Click set condition 2. Define custom criteria 3. To display formatting on rows that fall outside of the condition, select the check box to apply format when condition is not met Freezing a column freeze a column to keep it visible while the rest of the sheet scrolls left or right Who can hide/unhide columns? owner or admin Hide/unhide columns - hide columns so it isn't visible - unhide to make hidden column visible hierarchy shows how rows are related Parent rows are created from indenting the row below it and are derived from the child row Remove a parent row outdent Import files into sheets Navigation bar > solution center > import rules to importing files into sheets - files cannot exceed 50MB - up to 20,000 rows, 500,000 cells who can lock or unlock rows? owner or admin Locking rows protect key data from being changed or deleted by others who are shared to the sheet attachment and comment columns cannot be locked Publishing a smartsheet item publishing a sheet, report, or dashboard generates a unique URL that anyone can access without logging into smartsheet Rules of Publishing a smartsheet item - displays current data - you can stop publishing data at anytime - available to anyone with the link Card View organize tasks, work items, or ideas into actionable groups requires one dropdown column specified columns become lanes people could be lanes and cards could be tasks