Domain One: Sheets - Smartsheet Certification Questions
& Answers
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
& Answers
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
