BOBO d H H H H H H H H l ,
Z - j F LOM! ` w x H H @Rg( H H ( d h Ϡ l / d ᦐ p H / H / X d |8 a v DSET T , , , ; &k w A B l + , &
!
w x
y B C
D l m
n
+ ,
-
& * ,
X Some more formula information
The following statement will leave your feedback cell blank if an answer has not been entered in the answer column.
There is no space between the quotes.
This statement is interpreted as:
If cell D5 (the answer cell) is blank, the feedback cell is blank, otherwise if D5 is equal to A5 times C5, feedback cell is Great, otherwise Try Again is placed in the cell but only if an attempt to answer the question has been made.
=IF(D5="","",IF(D5=A5*C5,"Great","Try Again"))
I used the following formula to not give a final score unless an answer had been placed in cells d2 through d6.
I used F14 as the sum of the i ndividual points in column F.
=IF(D2="","",(IF(D3="","",(IF(D4="","",(IF(D5="","",(IF(D6="","",F14)))))))))
To clean up the appearance of your spreadsheet (Excel):
Under View, deselect formatting palette
Under View, deselect all toolbars
In preferences deselect
o Formula bar
o Status Bar
o Formulas
o Gridlines
o Row & Column Headers
o Sheet tabs (unless you are doing more than one sheet)
Suggestion: create your drill and practice interactive spreadsheet on the first sheet and then rename the sheet practice.
Copy this sheet to another sheet and then hide columns and rows as necessary to create your quiz and then rename this sheet quiz.
Z N DSET 2 H L 6 * DSET 2 H @ T 6 * DSUM HDNI STYL T J STYL 8 @ H P 0 g
]
\
j HASH
$ .
. .& . .
. . L:Q h ja zo }Bod h
CHAR "
X HASH
R
CELL ( " HASH
GRPH < ( HASH l
RULR D
( HASH @
KSEN L " HASH 2 LKUP
0 $ NAME Default
Default SS
Default TB Header Body Footer Footnote Footnote Index D FNTM Helvetica Geneva
Comic Sans MS Symbol Arial Courier New Wingdings MCRO MCRO oBlN MARK MRKS MOBJWMBT SNAP H H
H H @ C o{Ns^RZZ^ZZo{^NsZZVNsc{VZF1ZV^^NsRZ{ C kZ^VRV{VZ^g9kZkZ^g9cVRVw^^Z^g9^Ro{R^{ wc^o{Zco{sso{o{w{g9sco{3kZg9{ssZco{so{sswo{kZg9o{o{Nsssg9o{s^kZcwkZg9cwo{kZ{kZsso{o{scso{{o{so{ sg9ZkZg9scJRkZkZ^o{kZkZg9Zg9Vg9g9Nssg9Vc^Zc$o{wcZg9ZcZcwcg9kZsckZZcg9Zg9sccZV^sZZwkZkZw { {ީ Cg9ZZ^wZ^Zg9VZg9sZ{NsZsc RVc{kZkZg9VZs E wo{kZw{o{swswo{s{wwo{{o{sskZs{o{wo{kZws I kZkZww{{w{s{{wkZwo{{w{w{cw{{o{{{ M"ws^Nsg9Nssg9{Z^o{RVRNs{VZcJRNsVZZVsNsVco{NsZ־ { { C wc^sw{g9sco{kZg9sw{kZg9sg9o{kZo{g9o{kZo{o{ A wkZwkZso{o{kZcg9^kZkZo{swo{kZkZ^g9o{scg9sg9c G s{{{s{{{w {{w {{{ Js{kZcwcZo{kZkZZs^ZRwZg9^ZZcwc^kZo{kZo{ccZRo{R^g9g9^VkZNsccV{g9Vo{skZg9o{ZZRsV^Rg9ZccZVcZso{g9 s{o{s{so{o{{o{kZ{s
{{o{w{sw{s{kZw{w${wsskZso{wo{s{{w{wssww{w{o{{wwss{ss{{w sw{wo{w{ kZg9o{kZwsw{w{o{o{g9 s{{ w w w JZRJRNsV{RkZcRcg9VRBZkZwNs^BF1=VJRJRo{^Bg9o{g9ZkZVRJRVcs^JRJRRRVRB{o{^ZwVF1VNskZRkZF1^F1NsNscZg9c^9{ {ws w v{kZco{g9wc{kZsc{scwco{g9kZ!o{s{o{g9o{g9g9kZVkZswo{co{g9skZsco{kZkZo{g9g9so{o{kZ^w {9sco{{kZg9o{{g9wc{wwo{g9{kZwkZkZo{V{wswg9o{kZZg9wo{kZso{ZZkZwsg9{wcg9skZcc{kZkZc^w c-wcR-kB^9g9JRNsg9JRwBBNsBJR^o{V9F1Ns9wNsF1^g9kZVJRwF1F1cg9^kZkZZg9=Z c-w^V^JRVRg9wsJRg9ZF1c^^VRRVkZBVF1NsRskZ^BR5F1JRJRg9F1 { {
{g9wsso{kZco{cg9swswg9sso{wkZskZ{sskZwwo{sco{ss{s o{wwg9wso{s{o{swcsg9sso{o{{ {g9wcV^ssg9Zg9cs^Rg94skZkZg9cc^g9o{sZww^cZZkZg9^o{o{ckZkZZwZsVcg9{Vso{^cZVcg9^ZsZZ^w { { ;scg9sc^wg9kZkZ^kZwcg9g9Zg9g9o{kZV{^^ 9kZo{kZg9{s{o{o{so{{kZww{so{g9Vo{{o{s E kZwo{kZw{ws{ssww w{s q4s{^o{VF1JRg9ccZwJRZg9^9{RBRwZg9cZ9{RNsRcVJRNsRo{Ns^RRZwVkZVRZRVNskZs { {wswwww{wwwsw{ww{wwwsw ww{wwso{{sww{wwso{{{ww{ws{w{ Eo{RJR19JR5R^^sZ{JRJR19JR5R^^sZ{JRJR19JR1JR^^sZ{JRNs15JR1RZ^s^sJRNs15JR1RZ^s^s9=Z15F15F11 {w{cwo{ss^s{cw{ss^s{cw{ss^s{g9w{sw^s{g9w{ sw{o{^NsZNsVV oo{=^o{NsNs^RVVw=JRVwVZVRRZcNsZ9scRZg9g9VZZBVJRVVF1{%)JRc^V9w q4g9co{^NsVVV=g9ZVsJR=JRVVo{Ns^ZNs^g9ccVRo{=g9ZZVZ^ZRVo{wF1^cZVJRw MwscsZo{wg9wkZsco{so{g9o{kZ{Zso{o{scg9sg9o{g9g9s M kZo{cVskZkZcc{c^kZ^cco{wg9wg9cg9{kZg9^g9^{kZkZ {{{ w G s{kZVcF1g9wZg9Z^VZg9ZZcc{ckZs^ccZc^g9w 9s{o{o{wwwss{so{wo{ssw{s w # kZ{{ww{ 3s{^Vg9NsRNsRRJRRNsBVo{BNsJRVZֲ w {co{o{swo{so{wo{{ި sg9sccg9Zs^c wwg9^o{^scJRg9kZ {wo{{so{kZo{w o{ {ޣ so{c^^V^^V^ {{ww {o{w{kZkZww{ޥ so{^ckZR^cNsZ֥ 3wwVcg9{NsZkZco{kZco{ccg9^g9co{ 3{sskZc{g9{kZkZo{g9kZo{wwg9cckZso{ {w{{ި i wsg9ZRV^ZRkZ$g9ZVg9g9sg9ccs^ZsVg9^^o{cc^ZwcR^ZsZVskZRVZg9kZ c{wswo{w{sswwsw{sw{w{{so{{{s{ww{ww{w Q{kZ { {wkZ w { { {wwws Ho{wZ^RNsNs^g9ZVkZccNsRcJR{VVZwR^sco{NsZkZJRcR^g9^Vg9cg9V^RRkZVg9Ns{JRVZRRVRJRNsZZVo{^Nso{kZ^cco{ ss { Q$wVg9c^g9cckZZcg9{g9^kZcg9g9{Nsg9skZZcg9co{RZVc1g9Ns Q$wkZ^cwckZkZ{wcsww^o{^o{g9o{g9wkZkZckZwZRo{Vo{VcNs C o{{{ w{w wwsww w w Ho{kZkZF1V^g9^ZRsNsBF1Ns^RkZJRRNsZB^wRF1F1RccJRNskZRRBcc^F1F1o{VVRNsRNswF1JRVkZZF1Rc^F1o{RJRJRRRNsNs^o{^Z {w { [#{o{g9kZckZo{kZ{kZwso{swg9o{kZo{Zg9kZwg9g9o{g9kZskZ^ssw^g9ZZV ]so{kZ&g9ckZkZwo{Zo{kZwg9kZswkZg9kZ{kZo{g9cg9wwo{wo{wo{ZcwBNsVw TNAM 218B45710356D25142B61B0D42DFE6CPRT /
com.apple.print.DocumentTicket.PMSpoolFormat
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.DocumentTicket.PMSpoolFormat
application/pdf
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMColorSyncSystemProfilePath
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMColorSyncSystemProfilePath
/System/Library/ColorSync/Profiles/Generic RGB Profile.icc
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMCopies
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMCopies
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMCopyCollate
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMCopyCollate
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMFirstPage
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMFirstPage
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMLastPage
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMLastPage
2147483647
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PrintSettings.PMPageRange
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PrintSettings.PMPageRange
1
2147483647
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PrintSettingsTicket
com.apple.print.PageFormat.PMHorizontalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMHorizontalRes
72
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMOrientation
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMOrientation
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalRes
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalRes
72
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMVerticalScaling
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMVerticalScaling
1
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.subTicket.paper_info_ticket
com.apple.print.PageFormat.PMAdjustedPageRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PageFormat.PMAdjustedPaperRect
com.apple.print.ticket.creator
com.apple.printingmanager
com.apple.print.ticket.itemArray
com.apple.print.PageFormat.PMAdjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMPaperName
na-letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2000-07-28T22:57:04Z
com.apple.print.ticket.stateFlag
1
com.apple.print.PaperInfo.PMUnadjustedPageRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPageRect
0.0
0.0
734
576
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.PMUnadjustedPaperRect
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.PMUnadjustedPaperRect
-18
-18
774
594
com.apple.print.ticket.client
com.apple.printingmanager
com.apple.print.ticket.modDate
2003-11-18T18:16:01Z
com.apple.print.ticket.stateFlag
0
com.apple.print.PaperInfo.ppd.PMPaperName
com.apple.print.ticket.creator
com.apple.print.pm.PostScript
com.apple.print.ticket.itemArray
com.apple.print.PaperInfo.ppd.PMPaperName
Letter
com.apple.print.ticket.client
com.apple.print.pm.PostScript
com.apple.print.ticket.modDate
2000-07-28T22:57:04Z
com.apple.print.ticket.stateFlag
1
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PaperInfoTicket
com.apple.print.ticket.APIVersion
00.20
com.apple.print.ticket.privateLock
com.apple.print.ticket.type
com.apple.print.PageFormatTicket
ETBL hDSUM HDNI ;STYL EMCRO oBlN MARK WMBT ! SNAP !)TNAM 74CPRT 7[ETBL g/4*Az