*SP9010
C2,0
rüüÉ Apps  Disk  Create  Edit  Locate  Frames  Words  Numbers  Graph  Print 
r╔üé11:00 am
rüéÉ ╨░
rüâÉ ╞░<Library>░
rüäÉ[Q3] ├═╗ ê░
rüàÉ║
réàÇ ê 
rèàÉA 
rîàÇ ç 
rôàÉ 
röà╕ 
ròàÉB
rûàÇ à 
r¢à╕  
r¥àÉ ä C
róàÇ   
rÑàÉ ê D Ü ║░░░<A:>░
rüåÉ║1
râåé██
ràåÉ è July ë August å September ù ║░░░>C:<░
rüçÉ║2
râçÇ   
råçÉNorth
rïçÇ  
rìçÉ 
rÄ╟É 
rÅçÉ$2,345.50 ä $2,556.50 ä $2,885.30 û ║ ê░
rüêÉ║3
râêÇ   
råêÉEast
rèêÇ ä 
rÄêÉ $4,321.10 ä $4,316.90 ä $4,902.20 
r│ê╕ ò 
r╚êÉ║ ê░
rüëÉ║4
râëÇ   
råëÉSouth
rïëÇ   
rÄëÉ $5,123.10 ä $4,412.00 ä $5,513.00 
r│ë╕ ò 
r╚ëÉ║ ê░
rüèÉ║5
râèÇ   
råèÉWest
rèèÇ   
rì╩É 
rÄèÉ $4,989.00 ä $5,019.90 ä $6,215.50 
r│è╕ ò 
r╚èÉ║ ê░
rüïÉ║6   Total
rïïÇ  
rì╦É█
rÄïé$16,778.70 
rÖï╕ » 
r╚ïÉ║ ê░
rüîÉ║
réîÇ ú 
rÑîÉ ú ║ ê░
rüìÉ║
réìÇ £ 
r₧ìÉ ¬ ║ ê░
rüÄÉ║
réÄÇ ¢ 
r¥ÄÉ ½ ║ ê░
rüÅÉ╚ ╞═╝ ê░
rüÉÉ░░░
räɱ ê ┌ ä─┐ ö 
rªÉÉ ½░
rüæÉ░░░
räæ±  Press │ F8 │ Copy to copy this  
rªæ≡ 
rºæÉ ¬░
rüÆÉ░░░
räƱ ê └ ä─┘ ö 
rªÆ≡ 
rºÆÉ ¬░
rüôÉ░░░
räô±  formula to columns C and D. à 
rªô≡ 
rºôÉ ¬░
rüöÉ░░░
räö± ó 
rªö≡ 
rºöÉ ¬░
rüòÉ ä░
ràò≡ ó 
rºòÉ ƒ░[Q3 å ]░
rüûé@sum(B2:B5) æ ║ î Q3.B6 è ║SS: è 2/6 ç 
rüÿ╕ 
r╧ÿÇ 
q╧ÿÇS,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0042,,
a8,C,MAIN,,,&H003F,,
*SP9020
C2,0
rüÉÉ ƒ░
ráɱ ê ┌───┐ ò 
räæÉ £░
ráæ±  Press │  │ to move the cursor  
r┬æ≡ 
räÆÉ £░
ráƱ ê └───┘ ò 
r┬Æ≡ 
räôÉ £░
ráô±  to column C. ö 
r┬ô≡ 
räöÉ £░
ráö± ó 
r┬ö≡ 
räòÉ ¥░
ríò≡ ó 
rìÿÉCOPY:  cursor to the copy destination; RETURN finishes
q╧ÿÉS,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H004D,,
a8,C,MAIN,,,&H003F,,
*SP9030
C7,0
rîï╕  
rÄïÉ$16,778.70 
r¢╦É█
r£ïÆ è 
r¼É±─┐
r¬æ±F6 │ to extend the ä 
r¼Æ±─┘
róô±selection. î 
r╟ûé3
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0040,,
a8,C,MAIN,,,&H003F,,
*SP9040
C18,0
r¢╦É█
rªïÆ 
r¿ï╕ ï 
ráÉÉ ú░
ráæÉ ú░
ráÆÉ ú░
ráôÉ ú░
ráöÉ ú░
ríòÉ ó░
rèÿÉSELECT:  extend selection with cursor keys; RETURN finishes
q╧ÿÉP,1,,,,,
a1,P,,,,,,
*SP9045
C14,1
rûɱ ê ┌───┐ æ 
rûæ±  Press │  │ to extend the   
r┤æ≡ 
rûƱ ê └───┘ æ 
r┤Æ≡ 
rûô±  selection to column D. å 
r┤ô≡ 
rûö± ₧ 
r┤ö≡ 
rùò≡ ₧ 
q╧ÿ≡S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H004D,,
a8,C,MAIN,,,&H003F,,
*SP9050
C7,2
r¢ï║ 
rº╦É█
r¿╦Æ ï 
räɱ ê ┌ à─┐ î 
rƒÉÉ ò░
räæ±  Press │──┘ │ to finish  
rƒæ≡ 
ráæÉ ò░
räƱ ê └ à─┘ î 
rƒÆ≡ 
ráÆÉ ò░
räô±  the selection. ï 
rƒô≡ 
ráôÉ ò░
räö± ¢ 
rƒö≡ 
ráöÉ ò░
ràò≡ ¢ 
ráòÉ ò░
q╧ÿÉS,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0D,,
a8,C,MAIN,,,&H003F,,
*SP060
C14,1
råô±copying the formula.
rèÿÉ à COPY:  cursor to the copy destination; RETURN finishes
q╧ÿÉS,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0D,,
a8,C,MAIN,,,&H003F,,
*SP9070
C18,0
rÜ╦É█
r¢ïé$16,305.30
rºïé $19,516.00
räÉÉ ¢░
räæÉ £░
räÆÉ £░
räôÉ £░
räöÉ £░
ràòÉ ¢░
råûéC
rëûéC
rÅÿÉ ╢ 
q╧ÿÉP,1,,,,,
a1,P,,,,,,
*SP9080
C14,1
rêı í 
rêű  The spreadsheet is complete.   
r⌐Å≡ 
rêɱ í 
r⌐É≡ 
rêæ±  You will now use these numbers 
r⌐æ≡ 
rêƱ í 
r⌐Æ≡ 
rêô±  to create a bar graph. ë 
r⌐ô≡ 
rêö± í 
r⌐ö≡ 
rëò≡ í 
q╧ÿ≡P,4,,,,,
a1,P,,,,,,
*SP9090
C14,1
r¼ì± ú 
r¼Ä±  You first need to select the à 
r╧Ä≡ 
r¼Å± ú 
r╧Å≡ 
r¼É±  numbers from the spreadsheet à 
r╧É≡ 
r¼æ± ú 
r╧æ≡ 
r¼Æ±  to be used to create the graph.  
r╧Æ≡ 
r¼ô± ú 
r╧ô≡ 
r¡ö≡ ú 
q╧ÿ≡P,5,,,,,
a1,P,,,,,,
*SP9100
C2,0
rêÄÉ í 
rêÅÉ ó═
rêÉÉ ó░
rêæÉ ó░
rêÆÉ ó░
rçôÉ ú░
rçöÉ ú░
rëòÉ í░
q╧ÿÉP,3,,,,,
a1,P,,,,,,
*SP9110
C14,1
réɱ ª 
réæ±  You will use the sales figures but  
r¿æ≡ 
réƱ ª 
r¿Æ≡ 
réô±  not the totals for the bar graph.   
r¿ô≡ 
réö± ª 
r¿ö≡ 
râò≡ ª 
q╧ÿ≡P,5,,,,,
a1,P,,,,,,
*SP9120
C2,0
r¼ìÉ £ ║ å░
r¼ÄÉ £ ║ ç░
r¼ÅÉ £═╝ ç░
r½ÉÉ Ñ░
r¼æÉ ñ░
r¼ÆÉ ñ░
r¼ôÉ ñ░
r¡öÉ ú░
q╧ÿÉP,3,,,,,
a1,P,,,,,,
*SP9130
C14,1
r½É± ê ┌───┐ Ä 
r½æ±  Press │  │ to move the  
r╞æ≡ 
r½Æ± ê └───┘ Ä 
r╞Æ≡ 
r½ô±  cursor to row 5. ë 
r╞ô≡ 
r½ö± ¢ 
r╞ö≡ 
r¼ò≡ ¢ 
q╧ÿ≡S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0048,,
a8,C,MAIN,,,&H003F,,
*SP9140
C18,0
rÜ╩É█
r¢èé $5,019.90 ä $6,215.50 
rÜïÉ $16,305.30   $19,516.00 
rüÉÉ ┼░
rüæÉ ╞░
rüÆÉ ╞░
rüôÉ ╟░
rüöÉ ╞░
rüòÉ ┼░[
rüûé5019.90 à 
r╔ûé5
q╧ÿéP,1,,,,,
a1,C,SP10,,,,,