Micr
rosoft�
E el 2e Card
Exce 2010
0
Custom ng Materials
mizable Trainin
Qu
uick Reference
Tel. (888) 9 customguide.com
903-2432 | www.c m
The 010 Scree Keybo rtcuts
e Excel 20 en oard Shor
Quic ar Title bar C
ck Access Toolba e Close button
Genera
al
Formula Bar
Open a W +
Workbook <
Create Ne <
ew +
File ta
ab
Save <
+
on
Ribbo
Preview and Print <
+

Close a W +
Workbook <
Name
e
Help <

box
Run Spelli
ing Check <
Calculate worksheets <

Col
lumns
Active cell
Create an absolute, <

normal, or nce
r mixed referen
Ro
ows
Navigat
tion:
Scroll
bars Move Betw <ę!>, <�!>,
ween Cells <
<
<�!>, <>
Right One
e Cell <
Left One C < b>
Cell + Down One
e Cell <
Up One C < er>
Cell + Wo
orksheet tabs
Down One
e Screen <
View b Zoom s
buttons slider
Up One Screen <

To Cell A1 <
1 +
The mentals
e Fundam
To Last Ce < >
ell +
e File tab menu an w contain commands
The nd Backstage view
" Cell addresses: Cells a
are referenced by
Go To Dia
alog Box <
for w ogram s files, such
working with a pro h as Open, Save,
addres heir column letter
sses made from th
Clos
se, New, and Print.
and ro as cell A1, A2, B1,
ow number, such a
Editing
B2, etc. You can find the ll
e address of a cel
" To Create a Ne
" ew Workbook: Click
Cut <
+
by looking at the Name Box.
the File tab and
d select New, and click
Copy <
+
elect a Cell: Click a cell or use the
Create, or press + . " To Se
Paste <
+
keyboard arrow keys to select it.
" To Open a Workbook: Click the File
"
Undo <
+
tab and select O " To Se e: Click and drag t
Open, or press elect a Cell Range to
Redo <
+
+ .
select a range of cells. O d
Or, press and hold
Find <
+
down the key w
while using the
" To Save a Wor
" rkbook: Click the
Replace <
+
ow keys> to mov
Save button on the Quick Access
s
Select All <
+
pointe f the range.
er to the last cell of
Toolbar, or pres
ss + .
Edit active
e cell <
ook:
To Preview and Print a Workbo
" To Se orksheet: Click th
elect an Entire Wo he
Clear cell contents <

Click the File ta
ab and select Print, or
Select e column and row
t All button where
press +

.
headin ss + .
ngs meet. Or, pres
Format
tting
nimize the Ribbo
To Min on: Click the
" To Undo: Click Undo button
" k the
Bold Ctrl> +
Minim on on the Ribbon.
mize Ribbon butto
on the Quick Ac
ccess Toolbar, or
Or, pre >. Or, right-click a
ess +
Ctrl> +
press + . Italics tab an e Ribbon from the
nd select Minimize e
Underline Ctrl> +
" To Redo or Re
" epeat: Click the
contex
xtual menu.
Redo button on s
n the Quick Access
Open Form Ctrl> +
mat Cells " To Ch Settings: Click the
hange Program S e
Toolbar, or pres The
ss + . T
Dialog Box + <
x
File ta ions.
ab and select Opti
last command is o
s repeated if Undo
Select All Ctrl> +
was not previou " To Us nd drag the zoom
usly used. se Zoom: Click an
Select ent Shift> +tire row
slider to the left or right.
. Or, click the
" To Close a Wo e
" orkbook: Click the
m n buttons on
Zoom Out and Zoom In
Select ent Ctrl> +
tire column
Close button, o .
or press + <
the slider.
Hide selec Ctrl> + <9>
cted rows " To Get Help: P n the
" Press to open
" To Ch ck a View button in
hange Views: Clic n
Help window. T n and
Type your question
Hide selec Ctrl> + <0>
cted the sta
atus bar. Or, click the View tab and
press .
columns
select a view.
Custom er Training
mizable Compute
Excel Quick 011 CustomGuid
k Reference � 20 de
www.customg one 888.903.243
guide.com | Pho 32
Cour nline Learning Skills Assessm
rseware On ments
Editing Form
matting
" To E Formula Bar, or " To For e commands in th
Edit a Cell s Contents: Select the cell and click the F rmat Text: Use the he Font group on the Home tab, or
double-click the cell. E nter>. click the Dialog Box Lau nt group to open th
Edit the cell contents and press dialog b
box.
" To C e cell(s) and press y.
Clear a Cell s Contents: Select the s the key
" To For n the Number grou
rmat Values: Use the commands in up on the Home
" To C a: Select cell(s) an ut or tton
Cut or Copy Data nd click the Cu Copy but
tab, or click the Dialog B the Number group
Box Launcher in t p to open the
in th p on the Home tab
he Clipboard group b.
Format
t Cells dialog box.
" To P e the insertion poin
Paste Data: Place nt where you want to paste and click
" To Cop ainter: Select the cell(s) with the
py Formatting with the Format Pa
the Paste button in th p on the Home tab
he Clipboard group b.
formatt opy and click the Format Paint
ting you want to co ter button in the
To P Before Pasting: P n point where you
Preview an Item B Place the insertion
Clipboa Home tab. Then, s
ard group on the H select the cell(s) you want to apply
want to paste, click the Paste button list arrow in the Clip he
pboard group on th
the cop
pied formatting to.
Hom
me tab, and select a preview option to view the item.
" To App Select the cell(s) y
ply a Cell Style: S you want to apply a cell style to.
" To P elect the destinatio e Paste button list
Paste Special: Se on cell(s), click the t
Click th tton in the Styles g e tab on the
he Cell Styles but group of the Home
arro d group on the Ho ct Paste Special.
ow in the Clipboard ome tab, and selec
Ribbon e from the gallery.
n and select a style .
Sele
ect an option and click OK.
" To For e as a Table: Sele want to apply table
rmat a Cell Range ect the cells you w e
" To C o Fill: Point to the fill handle at the b
Copy Using Auto bottom-right corner of
formatt Format as Table b s group of the
ting to. Click the F button in the Styles
the selected cell(s), th estination cell(s).
hen drag to the de
Home t n and select a table
tab on the Ribbon e format from the gallery.
" To C es Using AutoFill: Select the cells t ries.
Complete a Serie that define the ser
" To App Theme: Click the Page Layout tab on the Ribbon,
ply a Document T
Clic
ck and drag the fill handle to complete the series.
click the Themes button in the Themes gr
roup, and select a theme from the
" To M ells Using Drag a the cell(s) you wan gallery.
Move or Copy Ce and Drop: Select t nt to .
mov on the pointer over e selected cell(s), t
ve or copy, positio r any border of the then
To App h you want to
ply Conditional Formatting: Select the cells to which
drag hold down key while dragging
g to the destination cells. To copy, h g.
apply co ing. Click the Con ing button in the
onditional formatti nditional Formatti
Styles g e tab. Select the fo e you wish to use,
group of the Home ormatting scheme
" To I or Row: Right-clic he column, or belo
Insert a Column o ck to the right of th ow
then se n the dialog box.
et the conditions in
the row you want to in rt from the contextual menu, or click
nsert. Select Inser k the
Inse Cells group on the Home tab.
ert button in the C
" To Adjust Column Widt t: Drag the right bo
th or Row Height order of the
column ottom border of the row header. Dou
n header, or the bo uble-click the
" To D he row or column heading(s). Right-
Delete a Column or Row: Select th -
border to AutoFit the colu ding to its content
umn or row accord ts.
click te from the contex k the Delete butto
k and select Delet xtual menu, or click on in
the Cells group on the
e Home tab.
Work anagement
kbook Ma
" To I nt: Select the cell w o insert a commen
Insert a Commen where you want to nt
and click the Review tab on the Ribbon Comment button in " To Inse sert Worksheet ta
n. Click the New C ert a New Worksheet: Click the Ins ab next to the
the Comments group. Type a comment e the comment box sheet ta creen. Or, press <
t and click outside x. abs at the bottom of the program sc + .
" To Delete a Worksheet: Select the sheet lick the Delete
t want to delete, cl
button in the Cells group b, and select Delet t-
p on the Home tab te Sheet. Or, right
For nd Functi
rmulas an ions
click the sheet tab and select Delete from the contextual me
enu.
" To T ge: Click the cell w nd
Total a Cell Rang where you want to insert the total an
" To Ren et: Double-click th
name a Workshee he sheet tab, enter a new name for
click up on the Home ta
k the Sum button in the Editing grou ab. Verify the selected
the wor s .
rksheet, and press
cell range and click th
he Sum button again.
" To Cha et s Tab Color: R et tab, select Tab
ange a Workshee Right-click the shee
" To E here you want to in
Enter a Formula: Select the cell wh nsert the formula.
Color, and choose the c apply.
color you want to a
Type = and enter the formula using va ces, operators, an
e alues, cell referenc nd
func ter> when you re f
ctions. Press " To Mov orksheet: Click and drag a tab to mo
ve or Copy a Wo ove a worksheet.
Hold do ey while clicking an py the worksheet.
own the ke nd dragging to cop
" To I n: Select the cell w n
Insert a Function where you want to enter the function
and ert Function butto " To Split a Window: Dra cal or horizontal sp
d click the Inse on on the Formula Bar. ag either the vertic plit bar (located
near th o the worksheet.
he scroll bars) onto
" To R ype the cell referen
Reference a Cell in a Formula: Ty nce (for example, B5)
in th k the cell you want " To Fre e the cell pointer w
he formula or click t to reference. eeze Panes: Place where you want to freeze the
window ab on the Ribbon, click the Freeze P
w, click the View ta Panes button in
" To C ute Cell Referenc ell references with a $
Create an Absolu ce: Precede the ce
the Win select an option from the list.
ndow group, and s
sign fter selecting cell(s
n or press af s) to make it absolute.
" To Sele nge you want to print, click the Page
ect a Print Area: Select the cell ran e
" To U erators or Cell Ra e part of a formula
Use Several Ope anges: Enclose the a
Layout on, click the Print A e Page Setup
t tab on the Ribbo Area button in the
you want to calculate first in parenthese
es.
group, and select Set Pr
rint Area.
just Page Margin
" To Adj ns, Orientation, Size, and Breaks: Click the Page
Cha
arts
Layout on and use the com age Setup group,
t tab on the Ribbo mmands in the Pa
or click Launcher in the P
k the Dialog Box L Page Setup group to open the Page
" To C Select the cell rang he data you want t
Create a Chart: S ge that contains th to
Setup d
dialog box.
chart and click the Ins bbon. Click a char
sert tab on the Rib rt type button in the
" To Pro Workbook: Click t n the Ribbon and
otect or Share a W the Review tab on
Cha ect the chart you w the list.
arts group and sele want to use from t
use the e Changes group.
e commands in the .
e: Select the cell range that contains
To Insert a Sparkline s the data you want to
To Rec the File tab on the
cover Autosaved Versions: Click t e Ribbon and
char sert tab on the Rib
rt and click the Ins bbon. Select the sparkline you want to
select In tosaved version fr
nfo. Select an aut rom the Versions list. Or, click the
inse nt to
ert from the Sparkline group. Select the cell or cell range where you wan
Manage n and select Reco ns.
e Versions button over Draft Version
add the sparkline and click OK.
Custom er Training
mizable Compute
Excel Quick Reference � 20
011 CustomGuide
www.customg one 888.903.2432
guide.com | Pho
Cours Onl ments
seware line Learning Skills Assessm


Wyszukiwarka