Smartsheet General 2024 Exam Questions and Answers with All Correct Answers

Smartsheet General 2024 Exam Questions and Answers with All Correct Answers Formulas: T/F When adding a row above or below a cell with a formula, the cells automatically inherit a cell formula - Answer-TRUE - When adding a row above or below a cell with a formula, the cells automatically inherit a cell formula Cell References can be added by clicking directly on the cell - Answer-TRUE -Cell References can be added by clicking directly on the cell How do you separate cell references by using a cell range (same sheet) - Answer-Use a colon separating the beginning and ending cell references and add another range by separating with a comma (eg. =[weighted Value]2:[Weighted Value]6, [weighted Value]10:[Weighted Value]19 ) Formulas: T/F When adding a new child row, the new data is not added to an existing formula - Answer-False - All children added to a parent with a formula are automatically included in that data Formula: What is a "range"? - Answer-Range from which we'll find data we want to pull in or populate If I have a "Contact List", can I add a formula to that column? - Answer-Yes! Formulas can be placed in contact list fields What does mean in a formula? - Answer-Not Equal To Can a field contain a formula if it is a contact list that is also being used in resource management? - Answer-No. Contact list fields that are being used in resource management cannot contain a formula