Download Google Docs Spreadsheet Excel425
Sign in - Google Accounts. Setting for document backups, 174–175. Category axis, charts, Excel, 425. Downloading more Microsoft clip art. Adding directly on worksheet.
- Basil Harrell
- 2 years ago
- Views:
Transcription
1 MICROSOFT EXCEL
2 41 Excel, Excel,!' (worksheet) #!!! (65536) $ (256) % & Excel,! &&!,!, #!'!!,! $!! &!!,!' (cells) %! Excel! $ '! &, &,,!! &! $, $!, o & &! &!! & $, & (, # ', $ %!!$,!',!,! &! $! $
3 ) * ' + Home +!!$ Ctrl+Home + Ctrl+End ' & Ctrl+ $ $ Ctrl+ & $ Ctrl+ $ Ctrl+ $ PgUp +! PgDn +! Ctr + PgDn Ctrl+PgUp +! Alt + PgDn )! Alt+PgUp *! F5 & Go # % (,, $!!!$ * ' *$!! %,! &,! '! &'!,!' $ & (references $ addresses) # Excel!!! $!!!$ $ # Excel ' $!!!!! #!!! $!!!!$ ( &!, $ *1,*!&, $!!$!!' -! $ * & (%!$!! &! )
4 ,& &!! &! $!!$ %!, $ Go! Edit! Reference, $! $ $ Enter * & &!!!!! $, & Go #! $ Excel,! &!!!$,!' ( ) *$!!$!! &,!!! $ $/ &!,! $ &, & '!!$ (,! View, Toolbars,! $ $ WorkGroup 42 #!!!,, &! 0, # Excel!',!' 1 Excel!! 256 *!, $!!! 2 1 (Sheet1), 2 2 (Sheet2), * &,!$!!!,! &! ( &!,! $ #!$ 1, #! 2, #! 3, #! 4!,$ (,,!, Excel! 16,! &! * &,!!$ $!!!! % + +! +! + /!,!!, Sheet1, Sheet2, %!! &$!$ &&! % &/! Excel &/! &&! 0 & & ',! &!! &$ 43!' 1 :,! % $! 255 $,
5 !! # Excel &&!! (label) # Excel &!! ( &!, $ #$, &!!!!$ $!!' -! Microst $ Word *! ) (AutoCorrect) Excel 7 *! &! $ $ $ Enter ( &,! Tools AutoCorrect 3! & AutoCorrect $ $, $ # Excel! &&!! # Excel!!! -!!!,!! ( &!, $! 1024!!,! $ - &&! (formula), Excel!!! $!!& *! &!$ 4!,!!,!$!! &! % $!$,! & $ *! (!$,! ' & *!!!:!,!!!! $ &!$! # Excel!' & &&! & 1! ' $ *!!, / &, &&! * &&!,!'!! #!, &! & 3' $ (!!) -! ' &,!,! 1!' $!! (General number %$) ( &$!!) %!! (,!$!!,!!, ) %!! *! & 1+09 $ &, ####,!!! ( &!,!!! $ $ 44 ' 1!!!!! $ ( &!,!!$!! &,!,! # Excel!! &!!!, '!! *!'!!, Excel!'!!! % $!&,!!$!!!! ( &!,!! $! # Excel! 24 5, $!&!! 1, ( `90210) Excel
6 (!!,!!!: 4/4/95 4-Apr-95 4-Apr ( ) Apr-4 ( ) (, $!!: 9:45 6% 9:45:55 6% 21:45 21:45:55 2, Enter Excel 45 % ' &&!!, &&!!!' (!!$ + (Formula Bar) (0 (!!$ + & * $ -!) #!!' (!!$ + &&!: Cancel! ' # ' ' ( ) Enter # ' $$ fx $ ' Function Wizard! &&!, $ Enter $! Enter (!!!& ) (!!$ + %! &&! 46, $! ', Excel!' 3!& & (!!$ + '!& $ $ Enter & ' 3 $ $ Esc $ # Excel!!! % $ &$ $ &! $ 47 ' %, $! (( $!,!!! $! ) ', Excel!' X!& & (!!$ 2, Ctrl+;, Ctrl+Shift+;
7 + '!& $ $ Enter & ' 3 $ $ Esc $ # Excel!!! 48 & & 1 &!!!& &&!! &! $ $!!!$ $ &!!! $! % &! &, $ (& )!' (!$ &$!; 7,! &!!$!!& $! %!$ &!!!!!& # &$!!! %!$ ( ) &! ( ) $ $,!!$ (!$ &!, % $! $ Shift! $ $ &! ( $ $ &$!,! &! $ $ $ # Excel & &!!! &$! (!),!! : $ & 1 &!!!! & &! ( &!, &! *1: 03! *1, *2, *3, 01, % &! &$!! $!!!& * &!,!!$, #! &!!' * $! &$!,!! * &! &$! $ %!$ $ Go $ &!!! ( &!$ $,! &!$! &$! ( &!, INCOME-EXPENSE $ 08:024-C8:C24 &! &$!,!!!!$ -! &$! (!! % $ '!! $ +$ Ctrl+! &$! %!!$ '! +$ Shift+! -!!$ '!,$ (Select *) (!!!!!! ) ' &$! +$ Ctrl+Shift+! &$! 49!! Excel,!!$ &! #!! $! &!$! * &!!$ )
8 '! # Excel &,,! &$!$!! Excel!! % &:! (=),! $ (!!!) ' $ $ : =(+(2 *$!$ *1 *2 %! &!!$, * $ * +! / ) % +, = 8 < % <= % $! > % >= % $! < > 9 Excel 491, $! +, +$ (=) * Excel!! )! (% $ ) #!' (!!$ + +$ $! + )!!!!, $ Enter (!!$ +, v!$ #!'!!,! &! (!,!! & : (10*3)+5=35 10*+5)= ) '! ( $!, Excel! $ & # Excel &!!! *, Excel!' $,& &!: *1 0 *2 100 *3 =*1 +*2 &! $, Excel &!' '+$ *1 ' *, &' & 0, Excel!' : '+$ &, $!$, $, $!$ &' #!$ $ /, & & & * / $ 03, = * ' &!$ & % /!!,!!, &&$ &!' ( &!, & $!!
9 ! *1 &! $, *1 )!' $,! & :! %!$!!$ %! Excel!' $ &!!$, $!'!!$ & $ (! $, $ $ $%1 % A, %$1% 1, $%$1 % %1 411 *!' +,! 0 $ 0 $! 1 0 $ * & &!! $ -!' ' ' #! & $ $ ' # Excel &!$!! $! & '! # Excel!' $! 2 0 $,& #! $! $ )!!$ $ % $!$ &$! % $, &$! $!$! $ # Excel $ & '!! $, ' &!$ $ '! $!$!,!,!$! * &, $ Enter $! ## Excel &! 412 ) + Excel # Excel!! $!! & '! & $! $ + '!,&$ $ $, excel &$!! +!!$
10 4121 % + Sum $!! $ ( & $! ) Number1, Number2,! $! ( $ ) $! -'! ' # -! 30
11 4122 % + Average $ $ $ Excel '!!!&! &! Sum, &&$: (*1+*2+ *)/, &! & 30 -! (&: [*1+*2+ *30]) : AVERAGE ( 1; 2; ),,!!!$!! $ +&!: AVERAGE (2;4;6;8),!: 5 ( +: (,, $!! ;, :!' $ ' 4123 % + Min Max - $ MIN MAX &&!!! '!!,&: MAX )!!$! $ : MAX( $ ) : * *1 *5! 2, 4, 6, 8, 10, MAX(A1:A5)! & 10!! $ $ MIN,!!$! $ : MIN( $ ) : *!!, MIN(A1:A5)! & 2
12 4124 %, + IF IF &&!!$! $ (&: *$=TRUE)!!$ & (&: :&$=FALSE) #! IF -&: Logical Test Value_if_true Value_if_false +!! $!!$ && $, &&$ TRUE!$ && $ /&$, &&$ FALSE 1: 1 '!!!$!!!!! $ bonus (&:!) $! : 1! 4 +!! $! 1 >=20000 Bonus 2, <20000, Bonus +! &! Excel : +!! &&!,!! $ $: Bonus -! Bonus, -! 1,!!!$ : =IF(D5>=20000;',%%+ (/01/ BONUS';',%%+ &1 (/01/ BONUS') &&!,!, $!!$! 7$ IF, &!! :
13 #! : $ $ IF # &!! $ && *$-, +!! + $ 4 & bonus $ 20000,!!! &&! $ $ bonus Excel!! && $!! *! & &! &$ $ * 4! % $ Excel : /1((+ (: ( %(/1 +31(0%+1 EXCEL +31(0%+/+ 4%%+% - 0(+/( +31(0%+1 =ABS(A1) *+-7# #% #-*6%- *1 =COS(A1) ;%#-;- #-*6%- *1 =EXP(A1) )%*% e^a1 -,',#' ;*6# =FACT(A1) *1 +*6*(-;#'- =INT(A1) *',6*- %,6- #-*1
14 =LN(A1) ;,+,6,- 7-(*6%- #-*1 =LOG10(A1) ),'*)'- 7-(*6%- #-*1 =SIN(A1) %#-;- #-*1 =TAN(A1),2*+#-%,; #-*1 =SQRT(A1) #,#6*(<;' 6=* #-*1 =SUMSQ(A1;A2;A3) *1^2+*2^2+*3^2 - *6-%* #,#6*(<;<; =PRODUCT(A1:A10) (;-%,;- #<;*6%<; #- *1:*10 =POWER(A1;A2) *1^*2 *1 # );*% *2 =MOD(A1;A2) )*6, *1/*2 =PI() *6%- += ( 14 :2* ),'*)'*) /1((+ *: +31(0%+1 *(+1 &&11 +31(0%+/+ 4%%+%,/30/( +31(0%+1 =DSUM(A5:F35; MONEY ;A1:A2) *6-%* -7<; #<;,((6*2<; #- +,)- MONEY %, '6#6- #- *1:*2 =DAVERAGE(A5:F35; MONEY ; - %,- -6- # ),,((6*2, A1:A2) =DCOUNT(A5:F35; MONEY ;A1:A2) +7-,((6*2<; %, *6%- =DCOUNT(A5:F35; MONEY ;A1:A2) +7-,((6*2<; M, +,6,3-%,;- =DMAX(A5:F35; MONEY ;A1:A2),((6*2 %, #-;%,(*7#,6- *6%- =DMIN(A4:F35; MONEY ;A1:A2),((6*2 %, #-;%'6-#,6- *6%-,&! : COUNT %! & &! $ : COUNT(:) +&!: COUNT(E5:E19),!: 8 ( 8!) COUNTIF %!,! $ : COUNTIF( $ ; $) : COUNTIF(A5:A10; >5 ),!:! 2, 4, 6, 7, 1, 3,!! 2 &!! 5 ROUND ABS!$!! / : ROUND(!;! / ) +&!: ROUND(4,569;2 ),! 4,57 )!$!
15 : ABS(!) +&!: ABS(-5),! 5 SUMIF '!! $! $ : SUMIF( $ ; $; $, $) : $ *1:*5! 30, 31, 33, 34, 35, $ 01:05! &! 150, 200, 215, 225, SUMIF(A1:A5; >33 ; B1:B5)! & 455! # SUMIF $! &! #!!!! ( = ), $! *>!,! $ Excel!, $, &!&,!! &! $ Excel!!!$ $!,! &! ' $!!! 413 ', +$ (=), $ $ & $ $ *, $ F4 # Excel &!! $!!!$ '! $ +$ Enter # Excel &!!!!, Excel &! 414 '! (!; -!!!!!&! ( $ &!,!! ( tsum!!$!, Excel '! # Excel &' ' &!!,! * &!, Excel ' &!!, Excel!,! &!/,!!$ &$! +$ Enter!! &! Excel!' : =SUM((1:*5) (-!! &! ') *$!! (function),!!, SUM 3, Excel! 150 & $!!! # Excel!, AutoCalculate! ' &!!'!!!$ ( & &, $ &! &&! * & $,!!$! 3 Alt+= SUM
16 * &!!$,!! &!! $!!$! 415 ) AutoSum,! '! AutoSum # Excel!, '!! $!!$ (!!$ +, &! * &!,! $! *, &! +$ Enter,!,!$ (!!$ &'! - 0! ;,!!$; &$,! -!,!,!!, #!!, Excel! %!!$ & Excel! ) '! % Excel,! & % &!!$ +,, F2 $!!$ +, $ Enter ',! $ ( & $)! %!$ $ &! $,!$! $ : ( ' + $ & +$ + $ +$ + $!!$ +$ Home +!!$ +$ End +! & +$ Ctrl+ +! +$ Ctrl+ )/ $ +$ Backspace! $ )/ $ +$ Delete! $ )/! $ +$ Ctrl+Del!!$ )/!!!$! $ Del &!, &/ &' & + ; 5&/! &&! # Excel!! $ &&!, &!, $ Copy *! 4! &!$ *,! /! (%! &&!!! $ )
17 * &!!,!!$ %!$, &! ( / $!$,! Cut, Copy Paste * & &!$!$! Windows Clipboard $, Clipboard %!!$ $ Paste $ &, $!!!$ +$! $!, - ' &! #!! $, # Excel!'! & *!$ $ / &!!! $ $& &&!, Excel!! */ $ / &!,,!! &$ $ * $ Paste! Edit,! Insert! $ Cut Cells (!) $ $ Copied Cells ( $) 4171 % - '! (Drug & Drop) *!$ $ /! &!!$,! $ (!$ $!&, & $,! & % &! % $,!! $! &! 4172 & ' ', $ &!!$ $ / %$ & $ - & ( / &!, $! $ Ctrl (!$ &!, & ' $ $ ',!!! &&! &&!!, $ & ( &!$ $, Excel &!! $ &&! %!!$ $!!!!, $ Autill &!,,!' v & $!!-!!$! %!$ Autill!!!$ ( January, February, March),!! ( 1, 2, 3),!!! Monday, Tuesday, Wednesday) $!, * &!$ $ Excel *!!!!, $!!! $ *!!, & &!! $!$ &' &!! *!!!! Excel '! $!!, Excel!'!!!! * $!! $!$!!, Excel $!$ (!!!, &! & Excel! ( &!,!!!! 1,2,3, & 1 2!! (!! $ 10 (10, 20, 30 ), &!!
18 *!!,!, Excel $!!! ( &!, trim 1!! &!, Excel trim 2, trim ) AutoComplete + $ &!! &&!, $ & # Excel : AutoComplete # Excel $ *! &!!! $&!$! %!, % $ AutoComplete! *!!!, AutoComplete!!!! * & $!, AutoComplete 4182! AutoComplete +$ $! &, &!!,,$ 7 '!!! &,! $ 419 *,! $!!, $, / &!! # ', & *,!!$ $ Find Excel $ & Find Replace % $ $,!! $!!$ ( &!,!? Widget Wadget, / $! * Excel &!,!$! % &! $, / % Excel,! $!, $ $ 4, )&! *! Edit $ Find 0 & Find! Find What, $, /,!'! Search! 0y Rows $ 0y Columns,,!'! Look in : Formulas, Values $ Notes * Excel / -', Match Case *! (! ), Find Entire Cells *!, &$ '$,! Find Next ' # Excel! ' ' Find Next! %! Close & 4 Ctrl+F,! Find Ctrl+Shift+F,! Find Next, Ctrl+Shift+,! Find Previous Ctrl+, Replace
19 420 % ' *! Edit $ Replace 0 & Replace! Find What, $! Replace With, $!$, /,!'! Search! 0y Rows $ 0y Columns * Excel / -', Match Case *! (! ), Find Entire Cells *,! Find Next ' # Excel! ' # & Replace! ' : ' Replace, $ $ /! ' Find Next, $ $ /! ' Replace *, $ $/,! Close & 421 ' ' Excel,! &/!! $ $ ( &/!!!$ $ $,!!$ $ $,!!!$ $!! $ % &/!! $ $!$ ( $! $!! )!!!!$ $ $, &&!!!$ 0 *,! &$ *!,!!!!$ $ $ Excel!$!! $ $ & % &!! &&!! &$,!!$ $ $ *!!! $ $,! 1!!!!!$ $ $,!!$ $ $ &!! (,!!! )!!!! $ $!'!!$!$!!$ $ $ 422 % ' Excel & &! &&!, $!! * &&!,! &&! 3' &!- &; 3'!; *,!,!! $ &&! % &&!,!! $ $! %!!! (!!,!& $, &!), & - &! $ &&! $ '!; # &&! & $ '! $!; *,!
20 4221 -, #!!,!! $!! &!!$ $ &' &&! ( &,, $!!! $! %!$!! &! &&! ( &!! & & $!! & &&! # Excel $!$!!!$!!$ % Excel &!!!!$ % Word, $ (!$, &$!,!! %!! & %$ Cells *! Cells & %! &&!, &, &!$, $ *tfrmat Excel &!$ $ * &&!!$ ($ ) %! Aut'ormat ' &!! &! ' Table!!$ &! & ' -' Excel! &&! # Excel 15 &!!$ -!$!!,,!!,!,,,! /!! * Excel!!' 4222 ( Painter &! & $ ( &!!!! *! &!,!!!$ $ &$! 3' & $!!; % Excel! /!!! %$ Painter!!$ ' & & Painter ' ( $ ' ) ( ) $ *, Excel ) 423 ( &! &&!, Excel!!!!!!! (Arial,! 10) % $! &&! &!!' &, $!!!$ $
21 !! &$!!!, ( &!!!$!!, &!$!! %!$!! % Excel!!! $!! $ &! -!!!!!$! % $!&!!! $ &! &! $, & ( &!!!,!$ &!!$ ),!!$ & %$ Cells,! $! &,!! $ Edit Undo, & v $!,!! $ &! *! Edit $ Clear s # Excel!$! 4231 (!, &!!!,! '!! &! $!!!! '!!!, Excel!$!!,!$ % Tools Options # General + General Options # ' Standard Font # # ' $ Size # # (# * 424 ( - -,!, Excel! ' &&!! &&! # Excel '!! &,!!!! *,! '!! ( &!,! $!!,! &,&$ &!!,! & & $,! &! % $, $! $ Excel - &$,!$!!!$ %! & %$ Cells Alignment & %$ Cells ' $ $ &$ : ( Horizontal ( )) / & Center across selection
22 ( Vertical () ' ' ' ( Orientation ( ) ' ' ( ) Wrap Text ( ' ) Excel # Excel ) 425 (!'! Excel,! - 25 &! *!!! &! ( &! 25! 25 &!, 0,25, $ 25%;! &,!! ' '!!!!! $!!!' Excel &! # &!!!!$ (!!,!! ) %!$ $ Cells &! &!& *!!!$ &! &!$ &$!,!!! & '! &$! &!$ (!! &$! &$!,! Number Custom Category - &!!' $ ' ( ',! $ Cells $ &!, & - & & &! &, $ &!$ & &,!!!! %!!!: %!!,!!!,!!!&!!! '! '! %!, & / - /! : 5 ' (######),! #
23 #,& /, /!$!!!&, &!' 0,& / #!&!' (( &!, 9,5!$ #,00! 9,50)?,& / 3! &!!!!&, )&! ) $ & %! # Excel '! 100 ; 5 '!$!!$!!! +! $ 3!!!!' 427!' %!$! Underline!!$!!,!! '!$ *!$!!; % $!! &$ $!!!! &!! ( &!,!! &$!! $! &!! &! %!! Border!!$ *!!,! &/ &$!$ (!! &! '! Border $ None # Excel!!!!!! $ & $, &!!! $, &!!, $!'!!,! Border &!!!$,!!$! &$!&!!: 3!$ Border & %$ Cells Border!!!! 4271 $ - 1 &&!! $! %! $! ;! &&!!'!!!! $, &! $ & &!! 3!! &&! &&! &'! $!, &&!!!,! $!! &&!!!! Excel 4272 (! ' ' $ &! ' &&!! & &/ ( &!,!! %! &!! (!! Excel (!! &! #####! $ &&!
24 !,!!!!$ $! & $ $! / $ )! '!!!!!: & ' & ) Excel ', $ $ & & Column Width (# & ' ' #' ' ' ' ', & Column Standard Width # (# Excel ) 4273 ', Excel ' &!,,! &! & % ' & & $! & ' Excel & $! & ( &!,! $!$!!!$!! $ &!!! $ $ & (! $ & $ & $ & %! Inset $ Remove Page Break 4274 '!,! Excel!! & 0,75 - & & 0,5 (!!$! $! $! &$! & Page Setup,! &!,! +, # & Page Setup &!!' & 4275 % ' ' Page Setup *! File $ Page Setup 0 & Page Setup ' Margins '! : Top, Bottom, Left, Right )/ $ &, & $ &,! Header $ Footer $ From Edge )/ $ & 0! & ' -' # Excel & $,! $ &
25 428 &' '! &,! & Page Setup # Excel &! & & &:,, & & & + &; % &!!,!! & (! $;,&! :, ) ( 8,5!11 ) ' ' Fit Page (1!1 ) Excel ', Adjust ', 80% ' ' &, 100, - & First Page Number & ' 4281 % ' *! File $ Page Setup 0 & Page Setup ' Page '!: Portrait $ Landscape,! &, $ Adjust # &!, $ Fit # Page & & & ( &! 131),! &,!! Paper Size!,,!! Print Quality,! &! &!, &!!$! First Page Number ' -' ) $! $ ( &,! +, # Excel & &! &!,& &! 4282 &', Excel ' & &!&,!! &$ & Page Setup Sheet! (!!!,!, &!! ),&! &!! :
26 ( ' ' Excel) auditing ( ), ' ' & $ ') ', ' / $ ', 2 & $ ' 2 $ $ ' Sheet 429 E,!! o! &!'! *! & & %!$ &,!!, $! $!!!$ & $ & %!$!! & $ &, $ & $ & $ &!$! &$ & $ & + &!$! & & $ &,! Excel # Excel & &! &&! &!:!,! &,!,!,!,!! *!! & $ & & ',! &!$ & # Excel &!! $ &,! & & *'!!,! &,! & ( &!,! & 1 12!!!!),!!,,!,! Header / Footer
27 4291! *! * $ )! & 3!$ & Page Setup ' '&/& ( &!! &, &! Header &!! & '! # Excel!' &! &,!! &, $! 6, &, &! Footer %! & # Excel!'! & & ' -', & & &!' ( &,! +, # Excel!'!! & & 430 & ' Excel 1! &&!!'!! &&! % $ $!! &! &&! ( &!,! $!$!! &!!!!$! $, &!$!! &,! &!!!!! &,! &! / &&!! (! &&!, Excel! Chart Wizard *$ & $! $!! && &! $! %! $, &!$! &! &&!, Excel -! &&!, &!$!,! ' & $! &! &&!, &&!, Excel!!! # Excel! '! &!! ( 15!!!) * &&!!, Excel $! &!$ + &!! '! % $! &!$! # Excel & 14!! & & $! ' &! &!,&!! $ & $ $!:
28 Data Series ( ) ),, ' - $ ( ) ' ' Axis () & Excel ), ) X 0 Legend ( ) 1 )! ( ) '
29 Area ( $) Bar (&) Column ($) Line (!!$) Pie () Doughnut (&) Radar ( &) 3!!, & $ $ * o $!!!!!!$,! $ &! $ % && $ & & $!, $!, &! -!!' ' (!! $,!!' e) % & $ &&! % &!$! &! (!! ) 100%! (!$ ), $!, &! -!!' ' (!! $,!!' e) % & $ &&! % &!$! &! (!! ) 100%! (!$ ) 3! $! & $ &! % &!$ && $ &!!! % high-low-close-open! $!!!! 3!! &!, && $ & $! 3!! &! &&! &! 3!! &!! 3 Scatter (&) * $! $!!! &&! &! & &&!
30 3-D Surface 3- & ) +!!, * $! $!! $ & & Combination % &&!! (&!)! & $! ( &!,!! $!!!!$ Excel & ', &!! (;! &&!!!'! ),!,! -& (! (!, $ Insert Chart % As New Sheet,!, $! 3 - &!'!,!!!!$! $ $ Excel $! $!, -& (! 0$! 1 5,&! &!,! &!,! Next, $ & &!! Next 0 -& (! - 0$! 2 5!'! $! ' $!!$! Next 0 -& (! - 0$! 3 5!' & $!$! $! '!!$ $!! Next 0 -& (! - 0$! 4 5!'! $! 3'!' &&! (!! $ $),!!$ / $!$ 3!!$ / $!$!! ' Next 0 -& (! - 0$! 5 5 $!!!!, $!,! # ($! # $!! Category Value ' Finish# Excel &!! 4301!! -!! - %!$! &! $! $! $! &/!!$,! $ &/!,!!! $! ( &!,!! $ ),! *!,! &$ $! &$ $! #! &! $!! $,! & ( &!,! &!! $!!!!!! $!$! -!!!
31 ,!,! &/!!' (! (Chart) 1 (%!!!! &,! Enter) #! $!$ +- Data Point ( &&! ) Data series ( &&! ) Legend (!!) Axis () Plot area ( $ $!) ' $!$ $! ( &!,! $? 3,! &&! $?! &&! #! &&!!&!! ( &!!! $? 3!,!!!!$! $ &&! (! ) # &! ( $! (! )!! $! &! 1 &&!!$ & # : () 3 (') 1 &! 3, : = - $!!& #!! &!,! & &&! $! Title () %!! $ 3 : 4302 &'!!!!$!!!,! $!!$ $!!!! &!$ #! &&! &&! % & $ &&! ' % e:!!!$ + &! %! &&!!! &&!!,!'! $!$!! $ - & e!'! &! &&! $ # Excel! &&! %! &!! '!,!!! &&! $! $ 4303 ( ' &! $! Excel,!! $! &&! &!!,!', * &,! $! - &!$! - $!!$!!$ Chart (!!!$ Chart,!$ &! $ $ &$r!! Excel &!!! & &!!!,
32 !!$ Chart!! $!!$ Chart!!$!'!!$ $!,!!$! $ $! # % ' #! - $ : 2-D 3-D Excel ) # & $% 4304 ' # Excel!&! &&!!!!!!! ( &!,!! $!$!, $!$! 1!,!$! 2!,!, Excel &!!!!! # Excel!'!!' % &$ ( &!, &!,! &! $! $! &!'!! #! $ &!! % &$ $!, %! '! $!! (, (!!)! %!%$ (%$) $ )&! (Selected Series) #!!!! - : $!'!,! &!! $! - 3!' $!!!! & &!! e! &&!,! Excel!,! $!!! ( &!,!! &! $ # $!!! &'!!!!! 4305 '! 3!!, & &&! $! #! $;,$ $; + $?; ( $ &&!,!!! - : ($!)! 3 ($ o )!! % ( &!,!! ' &' $ '!& $ '!$ :! % $!$ 3 % -& (! &!!
33 ,,! %!$ ( &!,!!$!!,!! $! $! %! & %$ Titles
34 431 ( Excel (%0/( ( 1 % $ TODAY()!! $!! +! 3 2 % $ $ CODE CHAR! ASCII Codes 24!!,$ *$ 26!! *$ *$ 2 $ 3 A1! NOW, *2 DAY(80), A3 MONTH(34), 01 INDEX *2, 02 CHAR(75), B3 CODE $ * A5! COUNT B5 COUNTA range A1:B3 4 )! 45, 456, 2000, 3000, 400, 582, 541, 6523, 1000, 2500 ; 10! $ : SUM, AVERAGE,VAR,STDEV,MEDIAN,MAX,MIN 5 $ A1:A10 10! $ C1:C10!' & *, 0, (, ),,! &!!!! : '*#(-6* (X *6%-),;),5 ;!$ 0<3<20 * IF 20<3< <3<60 ( 60<3<80 ) 80<3<100, 6 % 4 $ *,0,(,) *!& 25%,20%,35% 20%!!! & * 10%! 7 # &! 1!$ $ # 2!$! 15%,!$ $ 15%, 4!$! 5% 5!$ $ 10% ; &! - $!!!!$ 8 (! 10,20,30! && $: ABS, COS,EXP, FACT, INT, LN, LOG10, SIN, TAN, SQRT ( 3!! $ : SUMSQ, PRODUCT N (%0/( * 1 #!! 5!$ : * 1& ( !!$ 1 / 4 -!!$! *,& & ( !!$ 90%!!$ ; & 1&-1&-'& 5!$!!!$ &! ;!! & -& - &, &! & ; & -& -&!! V ; & 2 Excel 1BXLS 2 #! &&!! & : %1+ +&( 4&( 0&%
35 *;-* ,06-* %*6# *+67- # & & * ;! 0 ; $ Color ( ;! - $ (,-)* -,5-)*- ',6) ) N 2 Excel 2BXLS 3 H!&! 4 $ : *: 790, 0: 680, (: 756, ): 710 ' $ Bonus!!!! & 4 $ ; &!'! bonus bonus! 1200 ; & 2 Excel 3BXLS 4,!: A1=55, A2=69, A3=98, A4=87, A5=66, A6=81,A7=72, A8=90,A9=52, A10=90 M $ IF! $ C1:C10! & A,B,C,D,F # $ $ : * *! & * 0 *! & 0 ( *! & C ) *! & D E *! < 55 1& F! &&! 3 s!$,& ; & 2 Excel 4BXLS 5 ;!$!! 12!$ (A1-A12) $ B1:B12! 0-100! : C1=B11+B2-B3*5,C2=(B1^3+B8^3)/(B6*B5), C3=(B8-B9)/(B4*10*B7) C4! & 06/08, C5!! s B4,B10,B12 C6!!$! $ B1:B12 ; & 2 Excel 5BXLS 6 1!! +$! &&!: %1+ +&( 4&( 0&% *;-* ,06-* %*6# * * % 5 0$!s Chart Wizard $ &&! &!! 3 & 3 '!$ =! &&! 3 $ (,-)*-,5-)*-',6)) 0 ; $ Titles, Legend, Labels ( ; &!! & / &!! ) ;! &!!!! 1&! ( ) ; $!$ &!!, ; & 2 Excel 6BXLS 4311 EXCEL: -
36 1 1 *1=100, *2=200, *3 =300 A4! & '!! 2 % &!!!!'! '!! 3 ' $ Excel & 2 passwords 4 % $ +,!' & & 5 % &!$ &$ 1 && /!! 6 1 A1= *2=*1+10%**1 *3=*2-5%**2! A3! $! *1 5 %; 7 % $ ' menu %$!' & &!!! 8 menu *!'! 9 * 9 $ menu *! $ selection!! $ ctrl 10 1 A1 $ 1/1/2000! $! A31!'!!!! 31/1/ # &!! &! 2 $ 12 &!! 2 &!! 13 &!' $ & 14 % =TODAY()!'!! 15 1 A1 $ 6/12/1999 A2 25/11/1999! = A1-A2 A3 $!! 2!! 16 *! &!! ' 17 % INDEX!'!
37 18!!'! $ AND & OR 19! Database! &!! 3 $ 20! database!'!! & 21 # & Page Numbers -Total Pages Header /Footer 22 &!! 3 &! $ &!! 23 % $ #!!'! &!! 24! Database!!!'! & 25 % $ MODE!'!!! 26 A 3 $ &&!! $ F11 &! &!! 2D ' &&! 27 &! &!! 3 &!!!/ 28 * $ A1:D10 &!!! =SUMIF(A1:D1;10;A1:D1)/10!' / 10 $ A1:D10 29,!!!' $!! $ $ Ctrl 30 * : ( )/(300*3) $ =! 1! 31 * $ : =AVERAGE(A1;A5) *7!!!$! *1,*2,*3,*4,*5 32 % && OLE &&!!$!!! / 33!! &&! 1!!!'! 2 && /
38 34!!!$ $! $ $ & 35 &!!$!' I (! ) , 16 2, XLS * 37!!$ &!!!' 2 && /!!'!!!! 38 &! & &! & &&! 39! 2 $ $ &&!! $! &!!: * 2 #! 40 - $ VAR - MEDIAN - RAND -POWER &!! Excel 41!! 2 && $ 42!!! $ English, 43 % COUNT!' $!!!! 44 # * $!! custom! database 45 % IF!'!! $ 46 # & $!' $ Microst Excel 47 -! -' $ 48 &!! 2 & &!$ Overlap &! 3 49 =*2/$*$9 &!! =A2/A9 $ A1:A9 $! 50 * $ A1:D5 $!! &&!! $!!$!'!
39 =SUM(A1:D5) $ 4312 (+%+% DATABASE- EXCEL ) 0 )&! -Database! 8 +& 15, FIRST LAST DIVISION DEPT HIRE HRS RATE PAY Sara Kling Germany Water Rides 24-) Sean Willis Great Britain Water Rides Colleen Abel Canada Water Rides Teri Binga Australia Water Rides Frank Culbert Great Britain Children's Rides Kirsten DeVinney Great Britain Shows Theresa Califano Canada Water Rides Barry Bally Germany Children's 15-* Rides Cheryl Halal Canada Adult Rides Harry Swayne Germany Children's 30-) Rides Shing Chen Great Children's 08-* Britain Rides Seth Rose Canada Children's Rides 05-* Bob Ambrose Germany Water Rides Chris Hume Great Shows 12-%? Britain Robert Murray Great Britain Water Rides ; $ &&! Database DATABASE TESTXLS 2 ; fields 3 ; &! : (DIVISION =GREAT BRITAIN ) AND (HRS >= 350) 4 ;! 5 ; records (! $ Custom )! HIRE (&!! ) ; & DEPT 1 WATER PAY >400 7 % $ field LAST!! records 8!! & Pay!& & Dept 432 ( 2 1 1!' 5!$ 1998! &&!: ;-7'*,-)* = : 1& = ' '& = : 1& =10% & 1& =90 % & ' 3!$ 9 & $! 10%!$!!!$ # & 10%
40 %,! 10% * (! %) %? $ &! & 1!$ * ;!! 4 $( %;,-,-)*-,5-)*- ',6)) 5!! (*;-*6- - 2,06-*6-- %*6#- - *+67-- %*A-)!! 0 ;!,&,& -'& ( ;!!, &, &!! ) Color ( s & $ ) Borders E ; $!! *$, 1 & :!$! 2 2 ; & &! $ Excel : CHAR, NOW, TODAY, TIME, DAY, MONTH, MODE, CODE, INDEX, AND, OR, NOT, COUNT, COUNTA ; $!! *$, %! 4? *,0,(,) +$ $ *!$,, * '!! $ 3 & : +,6- * 0 ( ),6< *%,6' ** * ; $? $ (,6<+ - *%,6' -**)? * $ !!,? 0: !!,? (: !!? ): !! 0 ; &! &!! 3D-! & *,0,(,) $!! 0-max? $ ( ; $!, #, 7' Labels )!! ) ; &!$ 3D- +! $?,, ;!$ +,, &! ', & & Center Header & Center Footer! Gridlines 0, &!$ # ; $!! *$, &/(0(((-3,/+/ 2 1 % 5 *,0,(,),,? 5 - $!!!$ $ : +-7, * 0 ( ), 0-7* (72*)* '*77,* )*2; *7% * ;! 0 ; &!$ &!! 3D-+ '! $ $!! $,
41 ( ; &!$ &!! 3D-$ 3!, =!! max!! $ $!$ 3 5 & & $ $ $ ) ; &!$ 3D-$ 3! & '! $ $, &!! $!!, max Overlap 3D-Column, $ Gridlines (!)!! & # ; & $ 9 )!!1XLS 2 2! # $ $, &! *,0,(,),! : %*%*#* * 0 ( ), 3$ $ %! %!$ ) $, * ;!, & &$!! 0 ; 2D-$!$!!!! ; &!! 3D-$! 3D- $ ( ;!$ &!! $! 2 0, ) ; 2!& &$!! $ ;! $, ; Header-Center : *#, '$ Footer-Center: %$! & ; Orientation: Landscape Gridlines ; Workbook # ; & $ 9 )!!2XLS 2 3 * $ A1:A20 &!$! 1-20 % $ 01:020! $!$!! 1/1/ /1/1997 $ C1:C20!! $ TODAY!$! 0 $ D1:D20! $ &!$!!! ( ; & 9 )!!3XLS $ 4 & 4!!$ & : +-7, * 0 ( ) *;* ,*7-;' *#6* ,6** * ; &!$ 2 3D-$ ' &&! 1 3! 2 3! & ; / &, Gridlines (!) 2 &!! #! B ; &!! 3D-(!!$! &! $ &
42 ( ;! $ &! $ 4 ) ; & $ 9 )!!4XLS 4322 &/(#0+,31+ 0(+%0/(+ (+%+/+ EXCEL 2 1,!: *1 : 100, *2 : 200, *3 : 300, *4 : 400, *5 : 500 ;! : =*1+*2+*3+*5 =3*(*2-*1)+5*(*5-*4+*3) =(*2/*1)+(*4/*3) =(*5/*4)^3+3*(*3-*2+*1) =SUM(A1:A5) 2 2 )!!! $ * ;!!!$ $ 0 ;! $: MODE, INDEX, AVERAGE, VAR, STDEV, MEDIAN, MAX,MIN ( ; /! 1,2,3,4,5,7,3+% * 1 + $ A1:G7 2 ' A9: icon, Enter 3 Mouse & A9!! G9 $! 4 -!!!!$ 0 1 =MODE (A1:G7):!! $ / $ A1:G7 2 =INDEX(A1:G7;3;4): $ A1:G7! 3!!$ 4 $ 3 =AVERAGE(A1:A7): -!! $ *1:A7 4 =VAR(A1:A7): &! $ A1:A7 5 =STDEV(A1:A7): $! $ *1:*7 6 =MEDIAN(A1:A7): &!!$! $ A1:A7! $ 7 =MAX(A1:A7): -!! $ A1:A7 8 =MIN(A1:A7): -! $ A1:A7 ( =SUMIF(A1:G7;1;A1:G7)/1: / 1 $ A1:G7 =SUMIF(A1:G7;2;A1:G7)/2, =SUMIF(A1:G7;3;A1:G7)/3 =SUMIF(A1:G7;5;A1:G7)/5, =SUMIF(A1:G7;7;A1:G7)/7 2 3 % 4 $: *,0, (, ) & 3000! * : 25%, 0 : 28%, ( :23%, ) :24%, & bonus 10% ;! & ; &!!$ &! &!,3+% +* #* %- BONUS *+-)-3,
43 * 25% =B2*C6 =10%*C2 =C2+D2 0 28% =B3*C6 =10%*C3 =C3+D3 ( 23% =B4*C6 =10%*C4 =C4+D4 ) 24% =B5*C6 =10%*C5 =C5+D5 ;-7* 3000 =10%*C6 =SUM(E2:E5) 1, $ B2:E6 icon Currency style ( #########! ) 2, A1:E6 & 3!! '! 3! 3$! $ 2 4 ; & 2 &!! 1 $,3+% $ A1:A10 &!: 50, 80, 90, 130, 225, 40, 95, 35, 57, 8 $ C1:C10 &!!! : WORD, EXCEL, ACCESS, POWERPOINT, OUTLOOK, INTERNET EXPLORER, PAINT, WORDPAD, CALCULATOR, NOTEPAD, A1:A10 2 #!!, C1:C10 icon * #!! 2 5 ;! && OLE! Excel,3+% 1 OLE = Object Linking Embedding = -, *! 2 )& $ &&! &! &! &!!! $!! 3 '!$!! 4 A1:A5 & 100, 200, 300, 400, 500 5, A1:A5 6 *$ 7 B1 8,,-,&$, 9,, & 10 A1 & 1000 B1 ' 1000 &! &! 2 6,!!,-)*-,5-)*-',6) 4!$ : ',6) =,-)*,5-)*,-)* =,5-)* + ',6),5-)* =,-)* ',6)! %;,,-)*,5-)* ',6) *;-* ,06-* %*6# *+67- ;-7* ,3+% %;,,-)*,5-)* ',6) *;-* =B2-D ,06-*6- =C3+D %*6# =B4-C4 *+67- =B6-SUM(B2:B4) =C6-SUM(C2:C4) =D6-SUM(D2:D4) ;-7* =B6-D
44 : *1=100, *2=200, *3 =300, *4=400, *5=500, *6=600 1 =SUM(A1:A6) *6-%* #- +,6-3 A1:A6 2 =AVERAGE(A1:A6) %,- -6- #- +,6-3 A1:A6 3 =VAR(A1:A6) )*+-6* #- +,6-3 A1:A6 4 =STDEV(A1:A6) # *+-'7 #- +,6-3 A1:A6 5 =MEDIAN(A1:A6) )*%,- -6- #- +,6-3 A1:A6 6 =MAX(A1:A6) %,(#- #- +,6-3 A1:A6 7 =MIN(A1:A6),7*3#- #- +,6-3 A1:A6 434 & Excel 1 A1: 1/1/96, A2 : 30/8/96, A4=A2-A1: $!! *1 *2 2 =NOW():!! (3' $!' ######! ) 3 =TODAY():!! 4 =CHAR(75): $ ASCII code 75 5 =CODE( - ): ASCII code $ 6 =DAY(80 ): 80!!$ (1-31) 7 =MONTH(95):!$ (1,2,3,,12) 95! 8 =TIME(14;25;20):!!! $!! 9 =INDEX(A1:B9;5;2):! $ A1:B9!!!$ 5 $ 2 10 =MODE(A1:A10):!! $ A1:A10 11 =RAND():! 0-1 &&! /1((+ +31(0%+1 *(+1 &&11 ;*6#, 7,#-6(* ;*6#,<; =DSUM(A5:F35; MONEY ;A1:A2) *6-%* -7<; #<;,((6*2<; #- +,)- MONEY %, '6#6- #- *1:*2 =DAVERAGE(A5:F35; MONEY ; A1:A2) - %,- -6- #, ),,((6*2, =DCOUNT(A5:F35; MONEY ;A1:A2) +7-,((6*2<; %, *6%- =DCOUNT(A5:F35; MONEY ;A1:A2) +7-,((6*2<; M, +,6,3-%,;- =DMAX(A5:F35; MONEY ;A1:A2),((6*2 %, #-; %,(*7#,6- *6%- =DMIN(A4:F35; MONEY ;A1:A2) #- RECORD %, #- %'6-#,6- *6%-
MS EXCEL. Electronic spreadsheet Database management Generation of Charts.
MS EXCEL A spreadsheet is essentially a matrix of rows and columns. Consider a sheet of paper on which horizontal and vertical lines are drawn to yield a rectangular grid. The grid namely a cell, is the
More informationMicrosoft Excel 2010 Prepared by Computing Services at the Eastman School of Music July 2010
Microsoft Excel 2010 Prepared by Computing Services at the Eastman School of Music July 2010 Contents Microsoft Office Interface... 4 File Ribbon Tab... 5 Microsoft Office Quick Access Toolbar... 6 Appearance
More informationIntroduction to Microsoft Excel 2007
Introduction to Microsoft Excel 2007 Class learning objectives 1. What is Excel? Spreadsheet uses & samples Touring the Excel window Learning important definitions Navigating around the workbook 2. The
More informationMicrosoft Excel 2010 Part 3: Advanced Excel
CALIFORNIA STATE UNIVERSITY, LOS ANGELES INFORMATION TECHNOLOGY SERVICES Microsoft Excel 2010 Part 3: Advanced Excel Winter 2015, Version 1.0 Table of Contents Introduction...2 Sorting Data...2 Sorting
More informationMicrosoft Excel Training - Course Topic Selections
Microsoft Excel Training - Course Topic Selections The Basics Creating a New Workbook Navigating in Excel Moving the Cell Pointer Using Excel Menus Using Excel Toolbars: Hiding, Displaying, and Moving
More informationExcel 2003 Tutorial I
This tutorial was adapted from a tutorial by see its complete version at http://www.fgcu.edu/support/office2000/excel/index.html Excel 2003 Tutorial I Spreadsheet Basics Screen Layout Title bar Menu bar
More informationExcel 2007 Tutorials - Video File Attributes
Get Familiar with Excel 2007 42.40 3.02 The Excel 2007 Environment 4.10 0.19 Office Button 3.10 0.31 Quick Access Toolbar 3.10 0.33 Excel 2007 Ribbon 3.10 0.26 Home Tab 5.10 0.19 Insert Tab 3.10 0.19 Page
More informationMicrosoft Excel 2007 Module 1
Microsoft Excel 007 Module http://pds.hccfl.edu/pds Microsoft Excel 007: Module August 007 007 Hillsborough Community College - Professional Development and Web Services Hillsborough Community College
More informationMicrosoft Excel 2007 Basics For Windows
Microsoft Excel 2007 Basics For Windows Copyright 2009 by Massachusetts Institute of Technology All Rights Reserved Printed on 12/8/09 Table of Contents Table of Contents... 2 Module 1 Getting Started...
More informationBasic Microsoft Excel 2007
Basic Microsoft Excel 2007 The biggest difference between Excel 2007 and its predecessors is the new layout. All of the old functions are still there (with some new additions), but they are now located
More informationECDL. European Computer Driving Licence. Spreadsheet Software BCS ITQ Level 1. Syllabus Version 1.0
ECDL European Computer Driving Licence BCS ITQ Level 1 Using Microsoft Excel 2010 Syllabus Version 1.0 This training, which has been approved by BCS, includes exercise items intended to assist learners
More informationExcel 2013 Tutorials - Video File Attributes
Get Familiar with Excel 2013 46.30 2.96 The Excel 2013 Environment 4.10 0.17 Quick Access Toolbar 3.10 0.26 Excel 2013 Ribbon 3.10 0.26 File Tab 3.10 0.32 Home Tab 5.10 0.16 Insert Tab 3.10 0.16 Page Layout
More informationMicrosoft Excel 2010: Create a Chart from Start to Finish. Learn about charts
Microsoft Excel no longer provides the chart wizard. Instead, you can create a basic chart by clicking the chart type that you want on the Insert tab in the Charts group. To create a chart that displays
More informationBasic Excel Handbook
2 5 2 7 1 1 0 4 3 9 8 1 Basic Excel Handbook Version 3.6 May 6, 2008 Contents Contents... 1 Part I: Background Information...3 About This Handbook... 4 Excel Terminology... 5 Excel Terminology (cont.)...
More informationCommon Curriculum Map. Discipline: Computer Science/Business Course: Microsoft Excel
Common Curriculum Map Discipline: Computer Science/Business Course: Microsoft Excel January: Standards: NETS 1: Basic operations and concepts: Students demonstrate a sound understanding of the nature and
More informationMS Excel Tutorial Project 1
Page 1 of 28 Table of Contents Microsoft Excel Interface... 3 Menu Bar... 3 Standard Toolbar and Formatting Toolbar... 3 Formula Bar... 4 Status Bar... 4 Selecting a Cell... 5 Entering Text... 5 To Enter
More informationIntroduction to Microsoft Excel 2010
Introduction to Microsoft Excel 2010 Screen Elements Quick Access Toolbar The Ribbon Formula Bar Expand Formula Bar Button File Menu Vertical Scroll Worksheet Navigation Tabs Horizontal Scroll Bar Zoom
More informationMicrosoft Office Excel 2013
Microsoft Office Excel 2013 Navigating the Excel Interface The Components of the Excel 2013 Interface Component Quick Access Toolbar The ribbon Ribbon tabs Task pane Formula Bar Status bar Description
More informationExcel 2007. Getting Started The Excel Window u v w. Microsoft QUICK Source
Microsoft QUICK Source Excel 2007 Getting Started The Excel Window u v w x y z { u Quick Access Toolbar contains shortcuts for the most commonly used tools. v Microsoft Office Button contains common file
More informationDesigning a Worksheet with Excel
Designing a Worksheet with Excel Introduction Microsoft Office Excel 00 offers several tools that make your worksheets look attractive and professional. Without formatting, a worksheet can look confusing
More informationExcel Functions (fx) Click the Paste Function button. In the Function Category select All. Scroll down the Function Name list And select SUM.
Excel Functions (fx) Excel has prewritten formulas called functions to help simplify making complicated calculations. A function takes a value or values, performs an operation, and returns a result to
More informationMicrosoft Excel III Advanced
Microsoft Excel III Advanced Massey University Semester One 2012 Aidan Wood & Robert Hallam IT Assistant Information Commons Massey University Library Te Putanga ki te Ao Matauranga Private Bag 11222 Massey
More informationIntro to Excel spreadsheets
Intro to Excel spreadsheets What are the objectives of this document? The objectives of document are: 1. Familiarize you with what a spreadsheet is, how it works, and what its capabilities are; 2. Using
More informationExcel 2007 A Beginners Guide
Excel 2007 A Beginners Guide Beginner Introduction The aim of this document is to introduce some basic techniques for using Excel to enter data, perform calculations and produce simple charts based on
More informationMicrosoft Excel 2010 Tutorial
1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and
More informationComputer Training Centre University College Cork. Excel 2013 Level 1
Computer Training Centre University College Cork Excel 2013 Level 1 Table of Contents Introduction... 1 Opening Excel... 1 Using Windows 7... 1 Using Windows 8... 1 Getting Started with Excel 2013... 2
More informationIntermediate Microsoft Excel 2007
Intermediate Microsoft Excel 2007 Table of Contents ADVANCED FORMATTING... 2 FORMATTING NUMBERS... 2 WRAPPING TEXT... 3 EXPANDING THE FORMULA BAR... 3 THE MERGE AND CENTER FUNCTION... 4 INSERTING COMMENTS...
More informationExcel 2003 Tutorials - Video File Attributes
Using Excel Files 18.00 2.73 The Excel Environment 3.20 0.14 Opening Microsoft Excel 2.00 0.12 Opening a new workbook 1.40 0.26 Opening an existing workbook 1.50 0.37 Save a workbook 1.40 0.28 Copy a workbook
More informationExcel. Microsoft Office s spreadsheet application can be used to track. and analyze numerical data for display on screen or in printed
Excel Microsoft Office s spreadsheet application can be used to track and analyze numerical data for display on screen or in printed format. Excel is designed to help you record and calculate data, and
More informationExcel Lesson 1: Microsoft Excel Basics
Excel Lesson 1: Microsoft Excel Basics 1. Active cell: The cell in the worksheet in which you can type data. 2. Active worksheet: The worksheet that is displayed in the work area. 3. Adjacent range: All
More informationExcel 2003 A Beginners Guide
Excel 2003 A Beginners Guide Beginner Introduction The aim of this document is to introduce some basic techniques for using Excel to enter data, perform calculations and produce simple charts based on
More informationSTC: Descriptive Statistics in Excel 2013. Running Descriptive and Correlational Analysis in Excel 2013
Running Descriptive and Correlational Analysis in Excel 2013 Tips for coding a survey Use short phrases for your data table headers to keep your worksheet neat, you can always edit the labels in tables
More informationMICROSOFT EXCEL TUTORIAL HANDOUT
MICROSOFT EXCEL TUTIAL HANDOUT Opening Microsoft Excel 1. Click on the START button. 2. Click on PROGRAMS. 3. Click on MICROSOFT EXCEL. The Excel Screen Formula Bar Minimize Buttons Restore Buttons Close
More informationIf you are comfortable working with Excel, you will be comfortable working with FAST and other provided Excel workbooks.
Excel is a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional reports, etc. Unlike a paper spreadsheet, you can set up an Excel
More informationMove between open workbooks. Display the print menu. Select whole spreadsheet. Microsoft Excel Keyboard Keys. General
Microsoft Excel Keyboard Keys Source: http://allhotkeys.com/microsoft_excel_hotkeys.html General New file Ctrl + N Open file Ctrl + O Save file Ctrl + S Move between open workbooks Ctrl + F6 Close file
More informationINTRODUCTION TO MICROSOFT EXCEL 2010 Creating a Basic Spreadsheet
INTRODUCTION TO MICROSOFT EXCEL 2010 Creating a Basic Spreadsheet Documented by Vincent J. Yanusauskas Computer Training Coordinator Table of Contents Introduction... 1 Backstage View... 1 Quick access
More informationSOAL-SOAL MICROSOFT EXCEL 1. The box on the chart that contains the name of each individual record is called the. A. cell B. title C. axis D.
SOAL-SOAL MICROSOFT EXCEL 1. The box on the chart that contains the name of each individual record is called the. A. cell B. title C. axis D. legend 2. If you want all of the white cats grouped together
More informationMicrosoft Excel 2003
THE COMPLETE Microsoft E X E R C I S E P A C K CompleteVISUAL TM Step-by-step Series Computer Training Material www.computertrainingmaterial.com M O D U L E 1 4 Copyright Notice Copyright 2003 EBook Publishing.
More informationMicrosoft Office Excel 2003
Microsoft Office Excel 2003 Tutorial 3 Developing a Professional- Looking Worksheet 1 Open the Format Cells dialog box Formatting is the process of changing the appearance of your workbook. A properly
More informationExcel 2007 Basic knowledge
Ribbon menu The Ribbon menu system with tabs for various Excel commands. This Ribbon system replaces the traditional menus used with Excel 2003. Above the Ribbon in the upper-left corner is the Microsoft
More informationMicrosoft Excel 2010. Understanding the Basics
Microsoft Excel 2010 Understanding the Basics Table of Contents Opening Excel 2010 2 Components of Excel 2 The Ribbon 3 o Contextual Tabs 3 o Dialog Box Launcher 4 o Quick Access Toolbar 4 Key Tips 5 The
More informationIntermediate Microsoft Excel Charts and Formulas
John W. Jacobs Technology Center 450 Exton Square Parkway Exton, PA 19341 610.280.2666 ccljtc@ccls.org www.ccls.org Facebook.com/ChesterCountyLibrary Intermediate Microsoft Excel 2010- Workshop Topics:
More informationECDL / ICDL Spreadsheets Syllabus Version 5.0
ECDL / ICDL Spreadsheets Syllabus Version 5.0 Purpose This document details the syllabus for ECDL / ICDL Spreadsheets. The syllabus describes, through learning outcomes, the knowledge and skills that a
More informationQ&As: Microsoft Excel 2013: Chapter 2
Q&As: Microsoft Excel 2013: Chapter 2 In Step 5, why did the date that was entered change from 4/5/10 to 4/5/2010? When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats
More informationThe Basics of Microsoft Excel
The Basics of Microsoft Excel Theresa A Scott, MS Biostatistician III Department of Biostatistics Vanderbilt University theresa.scott@vanderbilt.edu Table of Contents 1 Introduction 1 1.1 Spreadsheet Basics..........................................
More informationOX Spreadsheet Product Guide
OX Spreadsheet Product Guide Open-Xchange February 2014 2014 Copyright Open-Xchange Inc. OX Spreadsheet Product Guide This document is the intellectual property of Open-Xchange Inc. The document may be
More informationExcel 2007: Basics Learning Guide
Excel 2007: Basics Learning Guide Exploring Excel At first glance, the new Excel 2007 interface may seem a bit unsettling, with fat bands called Ribbons replacing cascading text menus and task bars. This
More information1 Spreadsheet Processing
Page 0 German University in Cairo Media Engineering and Technology Prof. Dr. Slim Abdennadher Introduction to Computer Science, Winter 2015 Microsoft Excel 2013 1 Spreadsheet Processing 1.1 Spreadsheet
More informationMigrating to Excel 2010 from Excel 2003 - Excel - Microsoft Office 1 of 1
Migrating to Excel 2010 - Excel - Microsoft Office 1 of 1 In This Guide Microsoft Excel 2010 looks very different, so we created this guide to help you minimize the learning curve. Read on to learn key
More informationMicrosoft Excel Basics
COMMUNITY TECHNICAL SUPPORT Microsoft Excel Basics Introduction to Excel Click on the program icon in Launcher or the Microsoft Office Shortcut Bar. A worksheet is a grid, made up of columns, which are
More informationExcel Introduction
Excel 2013 - Introduction Table of Contents Introduction... 1 Starting Excel... 1 Layout... 1 Ribbon... 3 Quick Access Toolbar... 3 Mini Toolbar... 4 File tab... 4 Formula Bar... 4 Overview of Workbooks...
More informationExcel 2007 Introduction to Formulae and Functions
Excel 2007 Introduction to Formulae and Functions Page 1 of 19 Contents Creating Simple Formulae... 4 Some common formulae 4 The order of precedence 5 Editing a formula 5 Copying formulae 6 Functions...
More informationComputer Literacy Syllabus Class time: Mondays 5:00 7:00 p.m. Class location: 955 W. Main Street, Mt. Vernon, KY 40456
Computer Literacy Syllabus Class time: Mondays 5:00 7:00 p.m. Class location: 955 W. Main Street, Mt. Vernon, KY 40456 INSTRUCTOR: Jamie A. McFerron OFFICE: 245 Richmond Street Mt. Vernon, KY 40456 PHONE:
More informationDIGITAL DESIGN APPLICATIONS Word Exam REVIEW
DIGITAL DESIGN APPLICATIONS Word Exam REVIEW Directions: Complete the following word processing document, and know how to use proper formatting techniques on it. 1. Before keying in the text in the box
More informationExcel Project Creating a Stock Portfolio Simulation
Background Vocabulary Excel Project Creating a Stock Portfolio Simulation 1. What is a stock? A stock is a share in the ownership of a corporation, a large business organization. A stock, also, represents
More informationName Ranges and LookUp Functions
PMI Online Education Name Ranges and LookUp Functions Microcomputer Applications Table of Contents Objective 5: Create Range Names... 3 Naming a Range... 3 Modifying a Name Range... 4 Using Row and Column
More informationFigure 1. An embedded chart on a worksheet.
8. Excel Charts and Analysis ToolPak Charts, also known as graphs, have been an integral part of spreadsheets since the early days of Lotus 1-2-3. Charting features have improved significantly over the
More informationCape Cod Community College
Cape Cod Community College Departmental Syllabus Prepared by the Department of Business Date of Departmental Approval: March 27, 2014 Date approved by Curriculum and Programs: April 2, 2014 Effective:
More informationSS: Spreadsheet software
This is the ability to use a software application designed to record data in rows and columns, perform calculations with numerical data and present using charts and graphs. A. A foundation user can use
More informationFormulas, Functions and Charts
Formulas, Functions and Charts :: 167 8 Formulas, Functions and Charts 8.1 INTRODUCTION In this leson you can enter formula and functions and perform mathematical calcualtions. You will also be able to
More informationEssential Skills for Spreadsheets Microsoft Excel 2007. TR Leger Adult Literacy and Employment Preparation Program
Essential Skills for Spreadsheets Microsoft Excel 2007 TR Leger Adult Literacy and Employment Preparation Program Table of Contents Computer Course Pre-Evaluation...5 Introduction to Microsoft Excel 2007...6
More informationExcel Exam Review Questions 65-100
65. How often does Excel 2010 automatically recalculate formulas in a worksheet? A. Every 5 minutes B. Each time you click on a cell C. Each time you enter a value into a cell D. Each time the worksheet
More informationMicrosoft Excel 2010 Charts and Graphs
Microsoft Excel 2010 Charts and Graphs Email: training@health.ufl.edu Web Page: http://training.health.ufl.edu Microsoft Excel 2010: Charts and Graphs 2.0 hours Topics include data groupings; creating
More informationGetting Started with Excel 2008. Table of Contents
Table of Contents Elements of An Excel Document... 2 Resizing and Hiding Columns and Rows... 3 Using Panes to Create Spreadsheet Headers... 3 Using the AutoFill Command... 4 Using AutoFill for Sequences...
More informationECDL Module 4 Notes. Module 4: Spreadsheet. 4.1 Using the Application Working with Spreadsheets
ECDL Module 4 Notes Module 4: Spreadsheet 4.1 Using the Application 4.1.1 Working with Spreadsheets 4.1.1.1 Open, close spreadsheet application. Open, close spreadsheets Opening the Microsoft Excel Application
More informationScientific Graphing in Excel 2010
Scientific Graphing in Excel 2010 When you start Excel, you will see the screen below. Various parts of the display are labelled in red, with arrows, to define the terms used in the remainder of this overview.
More informationThe Center for Teaching, Learning, & Technology
The Center for Teaching, Learning, & Technology Instructional Technology Workshops Microsoft Excel 2010 Formulas and Charts Albert Robinson / Delwar Sayeed Faculty and Staff Development Programs Colston
More informationLab 11: Budgeting with Excel
Lab 11: Budgeting with Excel This lab exercise will have you track credit card bills over a period of three months. You will determine those months in which a budget was met for various categories. You
More informationHow to make a bar graph with error bars in Excel
How to make a bar graph with error bars in Excel This document provides instructions for how to use Excel to produce a bar graph. Use these instructions for graphing when your underlying independent variable
More informationExcel Math Project for 8th Grade Identifying Patterns
There are several terms that we will use to describe your spreadsheet: Workbook, worksheet, row, column, cell, cursor, name box, formula bar. Today you are going to create a spreadsheet to investigate
More informationMICROSOFT EXCEL...3 TYPES OF ENTRIES...3. EDITING...4 Clearing an Entry... 4 Moving and Entry... 4 Editing an Entry... 4
TABLE OF CONTENTS MICROSOFT EXCEL...3 Introduction...3 TYPES OF ENTRIES...3 Entering Data:...4 EDITING...4 Clearing an Entry... 4 Moving and Entry... 4 Editing an Entry... 4 ADJUSTING COLUMN WIDTHS...5
More informationCREATING FORMAL REPORT. using MICROSOFT WORD. and EXCEL
CREATING a FORMAL REPORT using MICROSOFT WORD and EXCEL TABLE OF CONTENTS TABLE OF CONTENTS... 2 1 INTRODUCTION... 4 1.1 Aim... 4 1.2 Authorisation... 4 1.3 Sources of Information... 4 2 FINDINGS... 4
More informationUsing Microsoft Excel
Using Microsoft Excel Key skill [Where it is introduced] To open MS Excel. To open an existing spreadsheet. How to do it! Start > All Programs > Microsost Office > Microsoft Office Excel 2003 File > Open
More informationBeginning Excel. Revised 5/01
Beginning Excel Objectives: The Learner will: Become familiar with terminology used in Microsoft Excel Create a simple workbook Write a simple formula Create a simple chart Sort a simple text chart Formatting
More informationExcel 2010 Cheat Sheet
Excel 2010 Cheat Sheet April 20, 2012 Toolbar customize click on arrow and then check the ones you want a shortcut for File Tab (has new, open save, print, and shows recent documents) Save, Open, New,
More informationHandout: How to Use Excel 2010
How to Use Excel 2010 Table of Contents THE EXCEL ENVIRONMENT... 4 MOVE OR SCROLL THROUGH A WORKSHEET... 5 USE THE SCROLL BARS TO MOVE THROUGH A WORKSHEET... 5 USE THE ARROW KEYS TO MOVE THROUGH A WORKSHEET...
More informationINTRODUCTION TO EXCEL
INTRODUCTION TO EXCEL 1 INTRODUCTION Anyone who has used a computer for more than just playing games will be aware of spreadsheets A spreadsheet is a versatile computer program (package) that enables you
More informationDownload Google Docs Spreadsheet Excel425 Excel
Microsoft Excel 2013: Headers and Footers
Microsoft Excel 2013: Headers and Footers You can add headers or footers at the top or bottom of a printed worksheet. For example, you might create a footer that has page numbers, along with the date and
More informationRows & Columns. Workbooks & Worksheets
+ O + N + P + S F12 + W + Q Esc + C + X + V + Z + Y + A + F Ctrl + H + Tab +, + Y The Fundamentals + Option + R Open File New File Print Save File Save File As Close File Close Excel Exit Dialog Copy Cut
More informationMicrosoft Excel 2013 Part 1: Introduction to Excel
CALIFORNIA STATE UNIVERSITY, LOS ANGELES INFORMATION TECHNOLOGY SERVICES Microsoft Excel 2013 Part 1: Introduction to Excel Summer 2014, Version 1.0 Table of Contents Introduction...3 Starting Excel...3
More informationIOWA STATE UNIVERSITY Department of Community and Regional Planning
IOWA STATE UNIVERSITY Department of Community and Regional Planning CRP274 PLANNING ANALYSIS AND TECHNIQUES II INTRODUCTION TO EXCEL FOR WINDOWS 1 Basic Components of Spreadsheet 1.1 Worksheet An Excel
Google Docs Excel Spreadsheet Sharing
More informationI ntermediate Excel. Using Auto Fill
I ntermediate Excel Using Auto Fill The Auto Fill tool allows you to copy the data in a single cell or block of cells and place that data into one or more neighboring cells via click and drag with the
More informationHow to Use Excel 2007
How to Use Excel 2007 Table of Contents THE EXCEL ENVIRONMENT... 4 MOVE OR SCROLL THROUGH A WORKSHEET... 5 USE THE SCROLL BARS TO MOVE THROUGH A WORKSHEET... 5 USE THE ARROW KEYS TO MOVE THROUGH A WORKSHEET...
More informationPopular Keyboard Shortcuts for Excel
Basic File Operations Ctrl + N Ctrl + O Ctrl + W Ctrl + S F12 Alt + F4 F1 Ctrl + Z Ctrl + Y F4 Ctrl + C Ctrl + X Ctrl + V Delete Ctrl + - (minus) Ctrl + + (plus) Ctrl + ' (apostrophe) Ctrl + R Shift +
More informationMicrosoft Excel 2010
Microsoft Excel 2010 An Introduction to MS Excel 2010 STM Training Program Center for Teaching and Learning Prepared by: Niranjan Khadka (Instructional Design Assistant) 1 MS Excel 2010 Formulas and Formatting
More informationEXCEL 2007 CHAPTER 2 LAB INSTRUCTIONS
Apply Your Knowledge Profit Analysis Worksheet EXCEL 2007 CHAPTER 2 LAB INSTRUCTIONS Instructions Part 1: Start Excel. Open the workbook Apply 2-1 Car-B-Clean Profit Analysis. See the inside back cover
More informationMicrosoft Excel 2013 Tutorial
Microsoft Excel 2013 Tutorial TABLE OF CONTENTS 1. Getting Started Pg. 3 2. Creating A New Document Pg. 3 3. Saving Your Document Pg. 4 4. Toolbars Pg. 4 5. Formatting Pg. 6 Working With Cells Pg. 6 Changing
More informationGetting started with Excel 2010
Getting started with Excel 2010 Getting started with Excel 2010 This document is a brief introduction to Excel 2010. It looks at some of the changes since Excel 2003, and highlights some key features to
More informationMicrosoft Word 2010 Prepared by Computing Services at the Eastman School of Music July 2010
Microsoft Word 2010 Prepared by Computing Services at the Eastman School of Music July 2010 Contents Microsoft Office Interface... 4 File Ribbon Tab... 5 Microsoft Office Quick Access Toolbar... 6 Appearance
More informationECDL. European Computer Driving Licence. Spreadsheet Software BCS ITQ Level 2. Syllabus Version 5.0
European Computer Driving Licence Spreadsheet Software BCS ITQ Level 2 Using Microsoft Excel 2010 Syllabus Version 5.0 This training, which has been approved by BCS, The Chartered Institute for IT, includes
More informationExcel Unit 4. Data files needed to complete these exercises will be found on the S: drive>410>student>computer Technology>Excel>Unit 4
Excel Unit 4 Data files needed to complete these exercises will be found on the S: drive>410>student>computer Technology>Excel>Unit 4 Step by Step 4.1 Creating and Positioning Charts GET READY. Before
More informationPart I: An Introduction to Application Software
Application Software Personal Productivity Software Part I: An Introduction to Application Software Application Software refers generally to all the programs that enable computer users to apply the computer
More informationExcel Guide for Finite Mathematics and Applied Calculus
Excel Guide for Finite Mathematics and Applied Calculus Revathi Narasimhan Kean University A technology guide to accompany Mathematical Applications, 6 th Edition Applied Calculus, 2 nd Edition Calculus:
More information Introduction To Microsoft Office Excel 2007. Bob Booth July 2008 AP-Excel8
Introduction To Microsoft Office Excel 2007. Bob Booth July 2008 AP-Excel8 University of Sheffield Contents 1. INTRODUCTION... 3 2. OVERVIEW OF SPREADSHEETS... 3 3. GETTING STARTED... 4 3.1 STARTING EXCEL
More informationBelow is a very brief tutorial on the basic capabilities of Excel. Refer to the Excel help files for more information.
Excel Tutorial Below is a very brief tutorial on the basic capabilities of Excel. Refer to the Excel help files for more information. Working with Data Entering and Formatting Data Before entering data
More informationExcel Level Two. Introduction. Contents. Exploring Formulas. Entering Formulas
Introduction Excel Level Two This workshop introduces you to formulas, functions, moving and copying data, using autofill, relative and absolute references, and formatting cells. Contents Introduction
More informationGuidelines for Microsoft Office 2010
Nancy Muir Anita Verno CONTENTS Preface Introduction: Your Digital Toolkit Chapter 1: Managing Your Time with Microsoft Outlook 2010 Skill 1 Open Outlook and Display the Calendar Skill 2 Schedule an Appointment
More informationMicrosoft Office Excel 2007 Key Features. Office of Enterprise Development and Support Applications Support Group
Microsoft Office Excel 2007 Key Features Office of Enterprise Development and Support Applications Support Group 2011 TABLE OF CONTENTS Office of Enterprise Development & Support Acknowledgment. 3 Introduction.
More informationTo launch the Microsoft Excel program, locate the Microsoft Excel icon, and double click.
EDIT202 Spreadsheet Lab Assignment Guidelines Getting Started 1. For this lab you will modify a sample spreadsheet file named Starter- Spreadsheet.xls which is available for download from the Spreadsheet
More informationExcel: Creating Charts
Excel: Creating Charts TABLE OF CONTENTS CHARTING IN EXCEL...1 WHICH CHART TO USE?!...1 SOME DEFINITIONS OF TERMINOLOGY RELATING TO CHARTS...3 CREATING A CHART...5 CHART WIZARD...5 ADD DATA TO A CHART...7
More information