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
...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LectDan. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.49. You're not tied to anything after your purchase.
