QUIZ 4: WRITING FORMULAS IN SMARTSHEET EXAM
GRADED A+
1. What blevel bof bhierarchy bshould bthe bCHILDREN() bfunction bbe
bplaced bon?
A. Parent brow
B. All bchild brows
1 b/
b8
, C. Last b child b row
D. First bchild brow: bParent brow
2. Which bfield btype bis bavailable bin ba bsheet bsummary?
A. Contact bList
B. System
C. Dropdown b (Multi b Select)
D. Auto-Number: b Contact bList
3. Marcos b wrote b a b formula b to b check b the b box b in b a b Complete
b checkbox b column bwhen b the b % b Complete b is b 100%. b What b is
b the b recommended b way b to b apply b his bformula bto bthe brest bof
bthe bcolumn?
A. Copy b and b paste b the b formula
B. Convert b it b to b a b column b formula
C. Rewrite b it b in b each b new b cell
D. Use b auto-fill b when b new b rows b are b added: b Convert bit bto ba bcolumn bformula
4. Guillermo bowns ba bproject btracking bsheet. bHis bsheet buses ba
bhierarchy bwith ball btasks bbeing bchildren bof ba bphase. bHe
bcreated ba bfilter bto bhelp bhis bteam bsee
only btheir btasks. bThey bare breporting bthat bit bis bdifficult bto
bunderstand bthe bphase bas bthere bare btasks bwith bthe bsame bname
bin bmultiple bphases. bTo bhelp bthem bunderstand bthe bphase, bhe
bhas badded ba bcolumn btitled b"Phase." bWhat bfunction bcan bhe
bcombine bwith bJOIN() bto bshow bthis binformation?
A. JOIN()
B. CHILDREN()
C. PARENT()
D. ANCESTORS(): bANCESTORS()
5. What b symbols b must b you b use b when b referencing b another b sheet
2 b/
b8
GRADED A+
1. What blevel bof bhierarchy bshould bthe bCHILDREN() bfunction bbe
bplaced bon?
A. Parent brow
B. All bchild brows
1 b/
b8
, C. Last b child b row
D. First bchild brow: bParent brow
2. Which bfield btype bis bavailable bin ba bsheet bsummary?
A. Contact bList
B. System
C. Dropdown b (Multi b Select)
D. Auto-Number: b Contact bList
3. Marcos b wrote b a b formula b to b check b the b box b in b a b Complete
b checkbox b column bwhen b the b % b Complete b is b 100%. b What b is
b the b recommended b way b to b apply b his bformula bto bthe brest bof
bthe bcolumn?
A. Copy b and b paste b the b formula
B. Convert b it b to b a b column b formula
C. Rewrite b it b in b each b new b cell
D. Use b auto-fill b when b new b rows b are b added: b Convert bit bto ba bcolumn bformula
4. Guillermo bowns ba bproject btracking bsheet. bHis bsheet buses ba
bhierarchy bwith ball btasks bbeing bchildren bof ba bphase. bHe
bcreated ba bfilter bto bhelp bhis bteam bsee
only btheir btasks. bThey bare breporting bthat bit bis bdifficult bto
bunderstand bthe bphase bas bthere bare btasks bwith bthe bsame bname
bin bmultiple bphases. bTo bhelp bthem bunderstand bthe bphase, bhe
bhas badded ba bcolumn btitled b"Phase." bWhat bfunction bcan bhe
bcombine bwith bJOIN() bto bshow bthis binformation?
A. JOIN()
B. CHILDREN()
C. PARENT()
D. ANCESTORS(): bANCESTORS()
5. What b symbols b must b you b use b when b referencing b another b sheet
2 b/
b8
