Language and space / edited by Paul Bloom ... [and others].

Format:

Book

Contributor:

Bloom, Paul, editor.

Series:

Language, speech, and communication

Language:

English

Subjects (All):

Space and time in language.

Physical Description:

1 online resource (616 pages) : illustrations

Other Title:

MIT Press CogNet.

Place of Publication:

Cambridge, Massachusetts : The MIT Press, [1999]

System Details:

text file

Summary:

The study of the relationship between natural language and spatial cognition has the potential to yield answers to vexing questions about the nature of the mind, language, and culture. The fifteen original contributions in Language and Space bring together the major lines of research and the most important theoretical viewpoints in the areas of psychology, linguistics, anthropology, and neuroscience, providing a much-needed synthesis across these diverse domains. Chapters address such questions as: How does the brain represent space? How many kinds of spatial representations are there? How do we learn to talk about space and what role does culture play in these matters? and Should experimental tests of the relations between space and language be restricted to closed-class linguistic elements or must the role of open-class elements be considered as well? Throughout, the authors address areas of agreement and disagreement.

Contents:

1 Creating a Workbook 1

The Workbook 1

Creating or Opening a Workbook 2

Working With Multiple Workbooks 3

Renaming Worksheets 4

Adding and Deleting Worksheets 4

Moving and Copying Worksheets 5

Entering Information 7

How Excel Translates What You Enter 8

Entering Formulas 10

Adding Functions to your Formulas 14

Working with Name 18

Saving Your Work 21

2 Editing Worksheets 24

Editing Individual Cells 24

Making Selections 26

Selecting a Row or Column 26

Selecting a Range of Cells 27

Selecting an Entire Worksheet 27

Creating a Selection Set 28

Canceling a Selection 28

Clearing and Deleting Cells 29

Inserting Rows, Columns, and Cells 31

Moving and Copying Cells 32

Formulas versus Values 33

Drag-and-drop Editing 33

Undoing Changes 34

Spell Checking 35

Checking Your Worksheet 35

Adding Custom Words 36

Using AutoCorrect 36

Adding Entries 37

Removing Entries 38

3 Formatting Your Worksheet 39

Controlling the Display of Numbers 39

Quickly Formatting a Number 40

Applying a Number Format 41

Using Custom Number Formats 41

Positioning Information Within a Cell 48

Horizontal Alignment 48

Vertical Alignment 52

Orientation 52

Miscellaneous Controls 53

Working with Fonts 53

Changing the Font 54

Setting Text Attributes 55

Changing Font Sizes 55

Changing Font Colors 55

Changing Font Information All at Once 56

Cell Colors and Patterns 57

Changing Cell Colors 57

Changing Cell Patterns 58

Cell Borders 59

Adding Borders 59

Removing Borders 60

Formatting Rows 61

Setting Row Height 61

Hiding and Unhiding Rows 62

Formatting Columns 62

Setting Column Width 62

Setting a Default Column Width 63

Hiding and Unhiding Columns 64

Formatting Worksheets 64

Changing the Background 64

Hiding and Unhiding Worksheets 65

Copying Formatting 66

Using the Format Painter 66

Using Copy and Paste 67

4 Printing Your Worksheet 69

Understanding Printing Concepts in Excel 69

Changing the Page Setup 69

Page Size and Orientation 70

Scaling 71

Page Numbers 71

Page Margins 72

Headers and Footers 73

Controlling What Prints 76

Which Part of Your Worksheet Should Be Printed? 76

Setting Print Titles 77

Printout Controls 77

Printing Order 78

Using Page Break Preview 78

Using Print Preview 79

Selecting a Printer 81

Printing Your Workbook 82

Specifying What to Print 83

Printing to a Disk File 84

5 Excel Tools 86

Working With Comments 86

Adding Comments 87

Viewing Comments 88

Editing Comments 89

Removing Comments 90

Managing Comments 90

Printing Comments 91

Revision Tracking 92

Turning Revision Marking On and Off 92

Making Revision 93

Resolving Revisions 94

The Office Assistant 96

Changing the Assistant 96

Setting Assistant Options 97

Removing the Assistant 97

6 Advanced Formatting 99

Using Styles 99

Creating a Style 99

Applying a Style 101

Changing an Existing Style 101

Copying Styles 101

Deleting a Style 102

Using AutoFormat 102

Placing Limits on AutoFormat 103

Undoing an AutoFormat 104

Using Conditional Formatting 105

Establishing Conditions 105

Setting a Format 107

Using Multiple Conditions 108

Copying Conditional Formatting 109

Controlling the Display 110

Controlling Gridlines 110

Viewing Zero Values 111

Turning Headers On and Off 111

Viewing Formulas versus Results 112

Overhead Information 112

7 Excel as a Database 115

What Is a List? 115

Using Data Forms 116

Sorting Data 118

Sorting an Entire List 119

Sorting a Partial List 119

More Complex Sorts 120

Creating a Sort Order 121

Filtering Data 122

Using AutoFilter 123

Advanced Filtering 125

Performing Calculations While Filtering 127

Copying the Results of Filtering 129

Setting Up Automatic Subtotals 130

Displaying Only Subtotals 132

Removing Subtotals 132

8 Working With PivotTables 135

What Is a PivotTable? 135

Creating a PivotTable 136

Understanding Pages 140

Editing a PivotTable 141

Using the PivotTable Wizard to Edit an Existing PivotTable 141

Directly Changing a PivotTable Field 142

Using the Mouse to Edit a PivotTable 144

Refreshing Data 145

Formatting a PivotTable 145

9 Using "What If" Capabilities 147

The Solver 147

Installing the Solver 147

Using the Solver 148

Solver Options 151

Solver Reports 152

Goal Seeking 153

Using Data Tables 155

A Single-Input Data Table 155

A Double-Input Data Table 157

Scenarios 158

Saving a Scenario 159

Showing a Scenario 162

Editing a Scenario 163

Creating Scenario Summaries 164

10 Using Views and Reports 166

What is a View 166

Using Stored Views 167

Deleting a View 168

What is a Report? 168

Using the Report Manager 168

Adding a Report 169

Editing Reports 171

Printing Reports 172

Deleting Reports 172

11 Verifying Your Workbook 174

What Is Auditing? 174

Auditing a Worksheet 175

Tracing Errors 177

Following Auditing Arrows 178

Using Data Validation 179

Defining Data Validation Rules 179

Setting Input Messages 180

Specifying an Error Message 181

Auditing For Valid Data 183

12 Working with Others 185

Protecting Your Workbook 185

Protecting a Single Worksheet 185

Protecting an Entire Workbook 189

Sharing Your Workbooks 190

Allowing for Multiple Users 190

Turning Off Sharing 192

Password Protecting an Excel File 193

Merging Workbooks 194

Web Collaboration 194

Conducting a NetMeeting 195

Using Web Discussions 195

13 Charting Your Data 201

Creating a Chart 201

Formatting Your Chart 205

Changing Chart Types 206

Changing Chart Size 206

Adding Chart Titles 207

Adding Data Labels 208

3-D Changes 209

Creating Custom Formats 210

Updating Your Chart 212

Printing Revisited 212

Printing Embedded Charts 212

Preparing a Chart Sheet for Printing 212

Sending Your Chart to the Printer 213

14 Adding Graphic Objects 216

What Are Graphic Objects? 216

The Drawing Toolbar 217

Drawing Different Objects 219

Drawing Simple Objects 219

Drawing AutoShapes 220

Drawing Complex Objects 220

Using Text Boxes 222

Editing Graphic Objects 223

Editing a Complex Object 224

Adjusting an AutoShape 225

Changing an AutoShape 225

Editing a Text Box 226

Formatting Graphics Objects 226

Filling an Object 226

Changing Line Color and Pattern 227

Styles for Lines, Dashes, and Arrows 228

Adding Shadows 288

3-D Effects 288

Rotating Graphic Objects 229

A Word on WordArt 230

15 Excel and the Web 232

What is the Web? 232

How the Web Works 233

Web Addressing 234

Using Hyperlinks 235

Defining a Hyperlink 235

Using Drag-and-Drop to Create a Hyperlink 238

Activating a Hyperlink 238

Editing a Hyperlink 238

Deleting a Hyperlink 239

Creating Web Pages 240

Making a New Web Page 241

Adding To a Web Page 243

16 The Basics of Macros 246

Creating a Macro 246

Examining a Macro 249

Editing a Macro 250

Writing a Macro from Scratch 252

Running a Macro 255

Deleting a Macro 255

17 Adding Control Features 257

Controls Add a "Front End" to Your Macros 257

Working with Messages 257

Displaying a Message Box 259

Specifying the Type of Message Box 259

Understanding the Return Values 260

Putting It Together 261

Getting User Input 261

Using Buttons and Other Graphical Controls 263

Buttons 265

Checkboxes 266

Option Buttons 267

List Boxes 268

Scroll Bars 270

Spinner Arrows 271

Group Boxes 272

18 Making Macros Part of Excel 274

Working With Menus 274

Adding Items To a Menu 274

Moving Items On a Menu 278

Adding a New Menu 278

Removing Items From a Menu 278

Changing the Keyboard 279

Working With Toolbars 281

Editing Toolbars 281

Creating Your Own Toolbars 283

Assigning a Macro To a Tool 285

Changing the Image On a Button 286

19 Automatically Running Macros 288

Creating Automatic Procedures 288

Running a Procedure When a Workbook is Opened 288

Running a Procedure When a Workbook is Closed 289

Running a Procedure When a Worksheet is Activated 290

Running a Procedure When a Worksheet is Deactivated 291

Understanding Add-Ins 292

Creating Add-Ins 293

Using Custom Add-Ins 295

20 Basic Business Forms 297

Using the Basic Business Forms 298

Suggested Improvements 298

Saving to a Different Workbook 298

Credit Application 299

How to Use This Form 299

Purchase Order 300

How to Use This Form 300

What Is Calculated? 301

Improvements You Can Make 301

Product Invoice 302

How to Use This Form 302

What Is Calculated? 302

Improvements You Can Make 303

Product Credit Memo 303

How to Use This Form 304

What Is Calculated? 304

Improvements You Can Make 304

Quotation 304

Improvements You Can Make 305

Service Invoice 306

How to Use This Form 306

What Is Calculated? 307

Improvements You Can Make 307

Service Credit Memo 307

How to Use This Form 307

Improvements You Can Make 308

Account Statement 308

How to Use This Form 308

What Is Calculated? 309

Improvements You Can Make 310

Cash Receipt 310

How to Use This Form 311

Improvements You Can Make 311

Petty Cash Log 311

How to Use This Form 312

What Is Calculated? 312

Inventory Tracking 312

What Is Calculated? 314

Improvements You Can Make 315

Travel Itinerary 315

How to Use This Form 315

What Is Calculated? 316

Improvements You Can Make 316

Mileage Log 316

How to Use This Form 316

What Is Calculated? 317

Improvements You Can Make 317

Expense Report 317

How to Use This Form 318

What Is Calculated? 319

Improvements You Can Make 319

Daily Time Sheet 319

How to Use This Form 319

What Is Calculated? 320

Improvements You Can Make 320

Performance Review 321

How to Use This Form 321

What Is Calculated? 322

Improvements You Can Make 322

Fixed Assets Tracking 322

How to Use This Form 322

What Is Calculated? 323

21 Financial Business Forms 325

Using the Financial Business Forms 325

Accounts Receivable Summary 326

How to Use This Form 326

What Is Calculated? 327

Improvements You Can Make 327

Aging Report 327

How to Use This Form 328

What Is Calculated? 329

Improvements You Can Make 329

Cash Flow Analysis 330

How to Use This Form 330

What Is Calculated? 330

Improvements You Can Make 331

Accounts Payable Summary 331

How to Use This Form 331

What Is Calculated? 332

Improvements You Can Make 332

Break-Even Analysis 332

How to Use This Form 333

What Is Calculated? 334

G&A Budget 334

How to Use This Form 334

Improvements You Can Make 334

Depreciation Analysis 335

How to Use This Form 336

What Is Calculated? 337

Income Statement 337

How to Use This Form 338

What Is Calculated? 338

Improvements You Can Make 338

Pro forma Income Statement 338

How to Use This Form 339

What Is Calculated? 339

Improvements You Can Make 340

Balance Sheet 340

How to Use This Form 340

What Is Calculated? 340

Improvements You Can Make 341

Pro Forma Balance Sheet 341

How to Use This Form 342

What Is Calculated? 342

Improvements You Can Make 343

22 Business Management 345

Using the Business-Management Forms 345

Product Sales Goals 345

How to Use This Form 346

What Is Calculated? 347

Sales Projections 347

How to Use This Form 348

What Is Calculated? 348

Sales Call Tracking 348

Improvements You Can Make 349

Sales Tracking by Employee 349

How to Use This Form 350

What Is Calculated? 350

23 Personal Finance 352

Using the Personal Finance Forms 352

Household Budget 353

How to Use This Form 354

What Is Calculated? 354

Improvements You Can Make 354

Charitable Donations 354

How to Use This Form 355

What Is Calculated? 355

Health-Care Expenses 356

How to Use This Form 356

What Is Calculated 356

Improvements You Can Make 357

Credit Card Purchases 357

How to Use This Form 358

What Is Calculated? 358

Improvements You Can Make 358

Business Use of a Home 358

How to Use This Form 359

What Is Calculated? 359

Business Use of a Phone 360

How to Use This Form 360

What Is Calculated? 360

Improvements You Can Make 361

Insurance Summary 361

How to Use This Form 361

What Is Calculated? 361

Improvements You Can Make 362

Investment Tracking 362

How to Use This Form 363

What Is Calculated? 363

Net Worth Summary 364

How to Use This Form 364

What Is Calculated? 365

Improvements You Can Make 365

Planning for a Future Expense 365

How to Use This Form 366

What Is Calculated? 367

Retirement Planning 367

How to Use This Form 367

24 Buying Property 370

Using the Buying Property Forms 370

Mortgage Qualification 371

How to Use This Form 371

What Is Calculated? 372

Closing-Costs Summary 373

How to Use This Form 374

What Is Calculated? 374

Mortgage Amortization 374

What Is Calculated? 375

Improvements You Can Make 376

Effects of Prepayment 376

How to Use This Form 376

What Is Calculated? 377

Refinancing Your Mortgage 378

How to Use This Form 378

What Is Calculated? 379

Improvements You Can Make 379

25 Personal Management 380

Using the Personal Management Forms 380

Monthly Calendar 380

How to Use This Form 381

What Is Calculated? 382

Improvements You Can Make 382

Yearly Calendar 383

How to Use This Form 384

What Is Calculated? 384

Improvements You Can Make 384

Appointment Tracking 384

What Is Calculated? 385

Improvements You Can Make 385

Household Inventory 386

How to Use This Form 386

What Is Calculated? 387

Home Improvement Summary 387

How to Use This Form 387

What Is Calculated? 388

Appendix A Excel Worksheet Functions 389

Appendix B Installing and Using the Companion CD Forms 436.

Notes:

"A Bradford book."

Originally published: 1996.

Description based on print version record.

Other Format:

Print version: Language and space.

ISBN:

9780262268806

0262268809

Access Restriction:

Restricted for use by site license.