Excel2010

ENTERTAINMENT

Find the phrase by filling in the blanks below.

Homework

1.Create a new workbook and save it as “Macro-1.xlsm”

2.Select ‘Developer tab → Code → Record New Macro’ from the menu.

3.In the Macro name box type “Enter_Address,”

4.Click OK to start recording.

5.Type your name, address, and phone number in the following format:

6.Click the cell that contains your name and make it bold.

7.Click the Stop button.

8.Clear the address information you just entered and try running your macro. You can modify this Macro to put your signature to the end of your documents.

Macros

181

Chapter 1			Chapter 2			Chapter 3				Chapter 4			Chapter 5
1	A		1	C		1	B		1		D		1	C
2	A-C		2	B		2	A		2		B		2	D
3	A		3	D		3	FALSE		3		D		3	A
4	D		4	A		4	A		4		B-C		4	B
5	A		5	A		5	B		5		B		5	B
6	C		6	C		6	D		6		C		6	C
7	D		7	B		7	B-D		7		D		7	D
8	D		8	D		8	C		8		A		8	D
9	B		9	D		9	B		9		A		9	TRUE
10	A		10	D		10	C		10		C		10	D
11	C		11	B		11	D						11	A
12	B		12	C		12	A						12	C
13	B		13	A		13	D						13	C
14	C		14	A									14
15	FALSE		15	C									15	D
			16	D									16	B
			17	B
			18	B
Chapter 6			Chapter 7			Chapter 8				Chapter 9
1	TRUE		1	C		1	B			1	D
2	FALSE		2	A-D		2	B			2	A
3	A		3	C		3	B			3	C
4	D		4	D		4	TRUE			4	A-B-D
5	B		5	C		5	D			5	C
6	C		6	C		6	D			6	D
7	D		7	D		7	FALSE			7	A
8	B		8	TRUE		8	TRUE			8	A
9	B		9	B		9	TRUE			9	C
10	B					10	FALSE			10	C
11	FALSE					11	TRUE			11	A

12D

13D

14B

A

Abs 80

Absolute 69, 70, 80 Active cell 9, 21, 44 Alignment 36, 39, 42, 125 Area 21, 22, 54, 126, 132 Assign 124, 160, 162 Auto Correct 146

Autofit 24

Average 72, 86, 87, 91, 168

B

Border 24, 40

Button 70, 76, 170

C

Cancel 21, 178

Cell 9, 21, 23

Chart 57, 120, 159

Check box 170, 171

Class 134, 162

Color 36, 40, 42, 44, 106 Column 8, 9, 13, 15 Combo box 170, 172, 176 Comment 139, 140 Complete 21 Concatenate 160, 165, 176 Conditional Formatting 45 Consolidate 110 Contextual 11, 121 Correlation 88, 122

Count 73, 75, 79

Countif 86, 164

Currency 38, 39

Custom List 108, 148

Customize 13, 54, 149

D

Data 110, 132, 137, 176

Data Validation 132

Date 38, 56, 77, 80, 86, 93, 105 Day 39, 80, 148

Delete 24, 25, 26, 140, 157

Developer 28, 154, 256

Double Click 11, 23, 24, 26, 43, 135

E

Enter 21, 22

F

F2 23

Factorial 82, 162

File format 16

Fill 20, 24, 36, 41

Fill series 20, 148

Filter 108, 109

Find 89, 90, 92, 109

Footer 55, 56

Format 16, 20, 37, 39

Format control 170, 172

Format painter 43

Formatting 20, 25, 27, 36, 42, 45 Formula 13, 23, 25, 66

Formula bar 8, 23, 41, 67

Fraction 23, 38

Freeze 134

Function 71, 76, 158

G

Gridline	57, 123
Group	136, 138, 170

H

Header 43, 45, 55, 107, 157 Hidden 11, 20, 27, 41, 75, 112 Hide 11, 24, 27, 41, 108, 136, 175 HLookUp 90, 91

I

If 83, 85, 174

Index 92, 159

Input box 24, 160

Insert 24, 27, 44, 70

K

Keyboard 12, 59, 157

L

Left 21, 22, 60, 89, 135

Len 89, 90

Link 26, 66, 110

Logical 76, 84, 90

M

MMacro 16, 149, 154

Margin 36, 55

Match 90, 92, 94

Merge 36, 40, 141

Message box 160

Method 155

Mid 89, 90

Module 154

Month 14, 77, 80, 148

Mouse 12, 14, 20, 42

Move 20, 22, 26, 147

Multiple 21, 22, 24, 27, 40, 60, 86, 173

N

Name box 8, 9, 67, 68

Name Manager 44

NetWorkDays 80

Now 77

Number format 37, 39, 78 Numeric processing 10

O

Object 43, 126, 155, 159, 162

Office 2003 12, 41, 44, 46

Operation 25, 154, 167

Orientation 26, 40, 54

Pie 122, 123

Pivot table 112, 113 Pointer 20, 24, 36 Preview 58, 59, 145 Print 54, 57, 59, 60 Procedure 154, 158, 161 Property 155, 162 Protect 28, 41, 149

R

Relative 69, 91, 92

Resize 20, 24

Review 10, 141, 142

Ribbon 9, 11, 12, 13

Right 20, 22, 55, 89

Row 9, 24, 66, 69

P

Page break 8, 58 Page setup 54, 59, 60 Page view 8, 9, 58, 59 Paste 20, 25, 108, 167 Paste Special 25, 167

S

Scale 54, 57

Scatter 122, 124

Scrolling 136

Security 66, 149, 155

Select 20

Shape 124, 140

Share 122, 139, 141

Shift 22, 24, 27, 39, 77, 157

Shrink 40, 122

Sin 81

Skip blanks 26

Smart tags 20

Sort 104, 106, 149

Spacebar 22

Split 122, 134

Standard Deviation 87, 88

Statistical 85, 88

Style 40, 42, 66

Subtotal 74, 138

Sum 69, 71, 83, 112

T

Tab 9, 10, 40, 54

Table 15, 43, 90, 112

Task 10, 154

Template 16

Themes 25, 41, 42, 122

Title 105, 121, 125

Today 77, 86

Tracking 141, 143

Transpose 26, 168

U

Undo 13, 26

Unhide 24, 27, 143

V

VB Editor 155, 157, 164

Visual Basic 154, 157, 164, 175

VLookUp 90

W

Watch 139, 164

Workbook 9, 14, 16, 42

Worksheet 9, 26, 28

Wrap text 36, 40

Y

Year 69, 77, 80

Z

Zoom 8, 9, 58, 59

References

Excel 2007 for Project Managers	Wiley Publishing, Inc.
MS. Office Excel® 2007 Bible	Wiley Publishing, Inc.
Excel 2007 Formulas	Wiley Publishing, Inc.
Microsoft® Office Excel® 2007 Step by Step	Microsoft Press Excel 2003, Zambak Publishing
Excel 2007 Power Programming with VBA	Wiley Publishing, Inc.
MS. Excel Help Contents	Microsoft Inc.
MS. Excel 2003 Inside Out	Microsoft Press