...Chapter 6 Reading Excel Worksheets 0.1 0.2 Introduction.............................................................................. Error! Bookmark not defined. A Section Title .......................................................................... Error! Bookmark not defined. Demonstration: .............................. Error! Bookmark not defined. Exercises .................................................................................. Error! Bookmark not defined. 0.3 0.4 Chapter Summary ................................................................... Error! Bookmark not defined. Solutions .................................................................................. Error! Bookmark not defined. Solutions to Exercises .............................................................. Error! Bookmark not defined. Solutions to Student Activities (Polls/Quizzes) .......................... Error! Bookmark not defined. 6-2 Chapter 6 Reading Excel Worksheets 6.1 Using Excel Data as Input 6-3 6.1 Using Excel Data as Input Objectives Use the DATA step to create a SAS data set from an Excel worksheet. Use the SAS/ACCESS LIBNAME statement to read from an Excel worksheet as though it were a SAS data set. 3 Business Scenario An existing data source contains information on Orion Star sales employees from Australia and the United States. A new SAS data set needs to be created that contains a subset of this existing data source. This...
Words: 4761 - Pages: 20
...CHAPTER 3 CONSOLIDATION SUBSEQUENT TO DATE OF ACQUISITION QUESTION SOLUTIONS 3-1. An 80 percent ownership requires the preparation of consolidated financial statements. Regardless of the method used to account for the investment on the parent’s financial records, the investment income or dividend income is replaced on the consolidated income statement by the subsidiary’s revenue and expense accounts. The equity method is required if the parent prepares separate financial statements. Search term “ownership” reveals 8 hits. The relevant item in this instance is paragraph 17, reproduced below: 17. The Board concludes that the equity method of accounting for an investment in common stock should also be followed by an investor whose investment in voting stock gives it the ability to exercise significant influence over operating and financial policies of an investee even though the investor holds 50% or less of the voting stock. Ability to exercise that influence may be indicated in several ways, such as representation on the board of directors, participation in policy making processes, material intercompany transactions, interchange of managerial personnel, or technological dependency. Another important consideration is the extent of ownership by an investor in relation to the concentration of other shareholdings, but substantial or majority ownership of the voting stock of an investee by another investor does not necessarily preclude the ability to exercise significant influence...
Words: 20856 - Pages: 84
...Excel VBA Programming Dummies Outline and Notes Jason Xu II: How VBA Works with Excel Chapter 3: Working in the Visual Basic Editor * To continue a single line of code from one line to the next, end the first line with a space followed by an underscore (_) * Option Explicit, inserted at the beginning of a VBA Module, forces variables to be defined (Should always use). Chapter 4: Introducing the Excel Object Model * A collection is a group of objects of the same type. * Workbooks: A collection of all currently open Workbook objects * Worksheets: A collection of all Worksheet objects contained in a particular Workbook object * Sheets: A collection of all sheets (regardless of their type) contained in a particular Workbook object. Contains both Worksheets and Charts. * Etc…. (collections are plural) * Referring to Objects * To reference a single object from a collection, you put the object’s name or index number in parentheses after the name of the collection: * Worksheets(“Sheet1”) * Excel won’t be able to identify the object if the quotation marks are omitted. * If Sheet1 if the first (or only) worksheet in the collection, you can also use the following reference: * Worksheets(1) * If referring to an object by its index number, use a plain number without quotation marks. * Navigating through the hierarchy * Application is at top of the hierarchy * Move...
Words: 2094 - Pages: 9
...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...
Words: 49651 - Pages: 199
...History Reading Worksheet #________/Chapter_______ The purpose of this worksheet is to give you a condensed version of the most important historical or central concepts within a given chapter. A “main idea” is a chief point an author is making about a particular historical period, or how she/he generally explains the change taking place over time. Typical historical writing is comprised of main ideas and supportive evidence that backs up an author’s claim, or interpretation of history. Your task is to record main ideas, not supportive evidence. You can paraphrase or use direct quotes that reflect or state a main point from the assigned chapter. A “response” is an original reaction or engagement with the text. This can be: a question, a connection to other material, state the significance, or importance. Typed worksheets are preferred, but not mandatory, and main ideas should reflect content of the whole chapter. Main Idea | Response | Page # | | | | | | | | | | | | | | | | | | | | | | Significant Historical Terms (choose 3 important terms from the Chapter) Term | Definition | 1) | | 2) | | 3) | | Main Argument of Reading Selection (1-3 sentences max): Use the ideas you identified from the chapter to decide what the main point/argument the author is attempting to make in this chapter. | Questions: Reading Reflection: 1) Review your notes from the reading selection. 2) In your own words type a brief 1 page double-spaced...
Words: 264 - Pages: 2
...can be used as a reference or read cover to cover. You won’t find a more comprehensive book on Excel 2010 than this!” —Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com • Searchable PDF of the book • Understand functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 • Perform magic with array formulas—and even more with Sparklines CD-ROM Included John Walkenbach ...
Words: 167105 - Pages: 669
...How to go to your page This eBook includes two bonus chapters, which are paginated separately from the rest of the book. The pagination of the bonus chapters consists of the identifer “BC” followed by the page number. For example, to go to page 5 of the bonus chapters, type BC5 in the “page #” box at the top of the screen and click “Go.” To go to page 15, type BC15… and so forth. Get More and Do More at Dummies.com ® Start with FREE Cheat Sheets Cheat Sheets include • Checklists • Charts • Common Instructions • And Other Good Stuff! To access the Cheat Sheet created specifically for this book, go to www.dummies.com/cheatsheet/excelvbaprogramming Get Smart at Dummies.com Dummies.com makes your life easier with 1,000s of answers on everything from removing wallpaper to using the latest version of Windows. Check out our • Videos • Illustrated Articles • Step-by-Step Instructions Plus, each month you can win valuable prizes by entering our Dummies.com sweepstakes. * Want a weekly dose of Dummies? Sign up for Newsletters on • Digital Photography • Microsoft Windows & Office • Personal Finance & Investing • Health & Wellness • Computing, iPods & Cell Phones • eBay • Internet • Food, Home & Garden Find out “HOW” at Dummies.com *Sweepstakes not currently available in all countries; visit Dummies.com for official rules. Excel VBA Programming ® FOR DUMmIES 2ND ‰ EDITION by John Walkenbach Excel® VBA Programming For Dummies®, 2nd Edition Published...
Words: 98776 - Pages: 396
...Comprehensive Information Management for Schools G/T (CIMS® G/T) Student Grading System User’s Guide NCS Publication Number 649 400 205 Second Edition (July 1999) This edition applies to Version 7.00 of the NCS Comprehensive Information Management for Schools G/T (CIMS® G/T) Student Grading System (SGS™) product for IBM AS/400* systems, and to all subsequent releases and modifications until otherwise indicated in new editions or updates. The data used to illustrate the reports and screen images may include names of individuals, companies, brands, and products. All of these names are fictitious; any similarities to actual names are entirely coincidental. Further, any illustrations of report formats or screen images are examples only, and reflect how a typical customer would install and use the product. CIMS® and SCH® are registered trademarks of National Computer Systems, Inc. ACS™, SMS™, SAS™, SGS™, CSO™, NCS Abacus™ and Performance Plus™ are trademarks of National Computer Systems, Inc. *IBM® and AS/400® are registered trademarks of the International Business Machines Corporation. GUI/400 is a product of Seagull Business Software B.V. and a trademark of International Business Machines Corporation. Copyright © 1997, 1999 National Computer Systems, Inc. Printed in the U.S.A. All rights reserved. No part of this book may be reproduced in any form or by any means without permission in writing from National Computer Systems, Inc. About This...
Words: 28011 - Pages: 113
...Desktop HardwareWeek 2 - Lab Worksheet | Student Name: <<Insert Name Here>> Guidelines for the Week 2 Assignment: This worksheet will assist you in completing your labs for this week. After you complete this worksheet, please save it as lastname_Week2Lab.docx and submit. You are required to complete all sections as indicated below. You will replace the red brackets and text with the indicated material. For example, for the “Student Name” section above, a completed response would look like this: Student Name: Monti Stanley When responding with text, please leave the text red so that your instructor will be able to find your responses easily. When pasting an image, please replace the red text with the image. Taking a screen shot: Be sure to press Alt+PrtScn key combination to capture a screen shot, instead of Ctrl+PrtScn. As you can see below, Ctrl+PrtScn captures the entire desktop while Alt+PrtScn captures only the active window. | | * Press Ctrl+PrtScn keys together * Press Ctrl+Fn+PrtScn keys together for some laptops | * Press Alt+PrtScn keys together * Press Alt+Fn+PrtScn keys together for some laptops | Complete the following activities by logging into the http://login.cengagebrain.com web site: 1) | LabConnection: Chapter 1 – Lab 1Follow the instructions provided in the course for accessing the LabConnection web site. Locate the labs for your class and then click on Chapter 1 – Lab 1. When you have completed...
Words: 459 - Pages: 2
...ACC 557 WK 4 Chapter 4 Quiz - All Possible Questions To Purchase Click Link Below: http://strtutorials.com/ACC-557-WK-4-Chapter-4-Quiz-All-Possible-Questions-ACC5576.htm ACC 557 WK 4 Chapter 4 Quiz - All Possible Questions TRUE-FALSE STATEMENTS 1. A worksheet is a mandatory form that must be prepared along with an income statement and balance sheet. 2. If a worksheet is used, financial statements can be prepared before adjusting entries are journalized. 3. If total credits in the income statement columns of a worksheet exceed total debits, the enterprise has net income. 4. It is not necessary to prepare formal financial statements if a worksheet has been prepared because financial position and net income are shown on the worksheet. 5. The adjustments on a worksheet can be posted directly to the accounts in the ledger from the worksheet. 6. The adjusted trial balance columns of a worksheet are obtained by subtracting the adjustment columns from the trial balance columns. 7. The balance of the depreciation expense account will appear in the income statement debit column of a worksheet. 8. Closing entries are unnecessary if the business plans to continue operating in the future and issue financial statements each year. 9. The Dividends account is closed to the Income Summary account in order to properly determine net income (or loss) for the period...
Words: 1229 - Pages: 5
...10 Creating Charts and Graphics In this chapter, you will learn how to ✔ Create charts. ✔ Customize the appearance of charts. ✔ Find trends in your data. ✔ Summarize your data by using sparklines. ✔ Create dynamic charts by using PivotCharts. ✔ Create diagrams by using SmartArt. ✔ Create shapes and mathematical equations. When you enter data into a Microsoft Excel 2010 worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, or the price of a product. What a list of values in cells can’t communicate easily, however, is the overall trends in the data. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually. In addition to the standard charts, with Excel 2010 you can create compact charts called sparklines, which summarize a data series using a graph contained within a single cell. You have a great deal of control over your charts’ appearance—you can change the color of any chart element, choose a different chart type to better summarize the underlying data, and change the display properties of text and numbers in a chart. If the data in the worksheet used to create a chart represents a progression through time, such as sales over several months, you can have Excel extrapolate future sales and add a trendline to the graph representing that prediction. Just as you can create a PivotTable dynamic view to reorganize your data dynamically, you can create...
Words: 8094 - Pages: 33
...ANNOTATING WORKSHEET A Write out the answers/responses to these prompts in your spiral notebook. |If reading a new piece or a first chapter, what is the genre… and who is the audience… and why do you say that? | |What is the author’s main point? | |What arguments does the author use to support his/her point? | |How does the author appeal to Logos? | |How does the author appeal to Pathos? | |How does the author appeal to Ethos? | |How does all of this relate to your life? | ANNOTATING WORKSHEET B Write out the answers/responses to these prompts in your spiral notebook. |What kinds of appeals have been made in this article? Use examples! ...
Words: 825 - Pages: 4
...Dates Prices and par values Frequency, and related Yields and interest/ discount rates Discount Any amount paid at maturity ? Frequency of payme nts pa First coupon Redemption amount Investment amount # of periods Settlement Par/coupon Maturity COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT ACCRINTM INTRATE DISC Excel for Professionals 2002 VJ Books. All rights reside with the author. Interest Basis Issue Yield Price Financial Analysis using Excel Financial Analysis using Excel Financial Analysis using Excel Volume 6 in the series Excel for Professionals Excel for Professionals Volume 1: Excel For Beginners Volume 2: Charting in Excel Volume 3: Excel-- Beyond The Basics Volume 4: Managing & Tabulating Data in Excel Volume 5: Statistical Analysis with Excel Volume 6: Financial Analysis using Excel Published by VJ Books Inc All rights reserved. No part of this book may be used or reproduced in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher except in the case of brief quotations embodied in reviews, articles, and research papers. Making copies of any part of this book for any purpose other than personal use is a violation of United States and international copyright laws. First year of printing: 2002 Date of this copy: Saturday, December 14, 2002 This...
Words: 26828 - Pages: 108
...and Excel capabilities to begin building your own Monte Carlo simulations applied to a wide range of business problems, including the construction of short-term profit plans (otherwise referred to as “Cost-Volume-Profit” models, covered in Chapter 9 of the text). Monte Carlo refers to a widely used approach for solving complex problems using computer algorithms to simulate the variables in the model (e.g., a CVP model). Typically, an algorithm is developed to "model" the problem, and then the algorithm is run many times (from a few hundred up to millions) in order to develop a statistical data set for how the model behaves. Simple Example: Tossing a “Fair” Coin—Heads vs. Tails? For the simplest example, consider the basic coin toss. This is a process which has two possible outcomes (heads or tails), each with a 50% probability. In a million coin tosses, roughly half will be “heads” and half will be “tails.” A simple Monte Carlo simulation would support this conclusion. If you were to develop a spreadsheet with a random number generator resulting in 0 for “heads” and 1 for “tails,” then have the spreadsheet recalculate a million times, you would see that very close to 50% of the recalculations resulted in 0 (“heads”) and the other 50% in 1 (“tails”). The basic approach would be to build a spreadsheet with random number generators that replicate the probabilities in the model. This is the essence of simulation: you are simulating the output(s) of a model given many...
Words: 2387 - Pages: 10
...ACC 557 WK 4 Chapter 4 Quiz - All Possible Questions To Purchase Click Link Below: http://strtutorials.com/ACC-557-WK-4-Chapter-4-Quiz-All-Possible-Questions-ACC5576.htm ACC 557 WK 4 Chapter 4 Quiz - All Possible Questions TRUE-FALSE STATEMENTS 1. A worksheet is a mandatory form that must be prepared along with an income statement and balance sheet. 2. If a worksheet is used, financial statements can be prepared before adjusting entries are journalized. 3. If total credits in the income statement columns of a worksheet exceed total debits, the enterprise has net income. 4. It is not necessary to prepare formal financial statements if a worksheet has been prepared because financial position and net income are shown on the worksheet. 5. The adjustments on a worksheet can be posted directly to the accounts in the ledger from the worksheet. 6. The adjusted trial balance columns of a worksheet are obtained by subtracting the adjustment columns from the trial balance columns. 7. The balance of the depreciation expense account will appear in the income statement debit column of a worksheet. 8. Closing entries are unnecessary if the business plans to continue operating in the future and issue financial statements each year. 9. The Dividends account is closed to the Income Summary account in order to properly determine net income (or loss) for the period...
Words: 1229 - Pages: 5
