7 Million Study Materials
From students who've taken these classes before
From students who've taken these classes before
24/7 Access to Tutors
Personal attention for all your questions
Personal attention for all your questions
Learn
93% of our members earn better grades
93% of our members earn better grades
Virginia Tech | ACIS 2504
Personal Computers In Business
Professors
- Mt Griffin,
- Marilyn Griffin,
- Will Demere,
- Tba,
- Michelle M. Seref,
- Demere
100 sample documents related to ACIS 2504
-
Virginia Tech ACIS 2504
CodesmustalwaysstartwithSubandendwithEndSub Tomakeacommentonacodeyoumustputandaspacefirst.Thenitwillnot readthataspartofthecode,butyoucanseeit. VBAiscasesensitive ReadingCode: Range(\"C4:E14,K4:K14\").Selecthighlightedthatrangeofcells Selection.Copycopiedt -
Virginia Tech ACIS 2504
Textmustbeinbutnumbersdonthavetobe Excel:=IF(logicalexpression,whattodoiftrue,whattodoiffalse) =IF(AND(,),iftrue,iffalse) VBA:*forerrorchecking,thelogicalexpressionistheerror IferrorexpressionThen MsgBoxThereisanerror!,vbCritical,Error! ExitSub EndIf Iflo -
Virginia Tech ACIS 2504
ConditionalFormattingisthemostimportantpartoftodayslecture Dataentry Enterdataclickoncellandtype CopydatahighlightdataandclickcontrolC PastedataclickwhereyouwantitpastedandclickcontrolV NumberClickDragclickbottomrightofrectangleanddragdownandExcel willgu -
Virginia Tech ACIS 2504
2009 Sales Region Northeast Midwest South Southeast Quarter 1 $1,583,952 $1,948,383 $1,305,239 $1,849,281 Quarter 2 $1,739,820 $1,837,853 $1,294,029 $1,758,234 Quarter 3 $1,693,203 $1,747,283 $1,259,305 $1,820,349 Quarter 4 $1,520,394 $1,893,852 $1,385,92 -
Virginia Tech ACIS 2504
Cash flow initial investment payments ($1,200.00) $300.00 $450.00 $585.00 $645.00 $800.00 Interest Rate 8% Net Present Value $946.53 Date 1-Jan-08 1-Feb-08 1-Mar-08 1-Apr-08 1-May-08 1-Jun-08 1-Jul-08 1-Aug-08 1-Sep-08 1-Oct-08 1-Nov-08 1-Dec-08 1-Jan-09 -
Virginia Tech ACIS 2504
Year 2009 2008 2007 2006 2005 mean returns Staples $50,365 $8,842 $7,123 $5,181 $3,968 $15,096 Wal-Mart $49,156 $185,013 $157,634 $97,100 $104,859 $118,752 INTEL $33,726 $45,321 $28,273 $98,123 $20,847 $45,258 which stock has max mean returns? max mean re -
Virginia Tech ACIS 2504
Withdrawal Deposit Interest Service Transaction No. Transaction Date Account No. Description Amount Amount Earned Charge 00178 April 11, 2002 111223333 withdrawal -30.25 0 0 0 00189 May 5, 2002 111223333 deposit 0 52.48 0 0 00211 August 7, 2002 444556666 -
Virginia Tech ACIS 2504
Data (Copy) 50 12 30 john nancy 50 12 30 john nancy Numbers (Click-Drag) 1 2 Monday 2 4 Tuesday 3 6 Wednesday 4 8 Thursday 5 10 Friday 6 12 Saturday 7 14 8 16 9 18 10 20 11 22 12 24 *copy: CTL+C *paste special: right-click Data 22 24 29 15 21 14 17 15 19 -
Virginia Tech ACIS 2504
Relative and Absolute Referencing Data 46 25 48 95 32 85 78 65 43 91 Sum 608 Multiplier 20 31 54 61 48 78 15 97 35 15 79 Product 12160 10260 Absolute Referencing - when you put $ before the letter and number, it won\'t change 513 F2 to see formula in cell -
Virginia Tech ACIS 2504
Basic Functions Example Table Product Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Sum: Average: Minimum value: Maximum value: Function Categories Diameter Weight Thickness Time to Failure 3.05 35.05 69.49 79.15 50.22 59.52 43.97 45.13 39.54 56.18 64.26 23. -
Virginia Tech ACIS 2504
Item # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Order Quantity Unit Price 9 $16.98 25 $7.89 21 $12.03 5 $17.11 20 $8.65 25 $7.60 19 $6.17 9 $7.71 11 $8.80 20 $18.60 20 $17.96 16 $17.77 15 $19.22 29 $13.73 8 $14.51 29 $11.45 7 $19.00 15 $10.71 -
Virginia Tech ACIS 2504
Company Name Location Yearly RevenueStock Price Launch Year A Florida $732,910 $1.10 2001 B Virginia $621,174 $1.49 2005 C Texas $633,476 $1.68 2007 D DC $591,071 $1.73 2004 E Georgia $619,139 $1.81 2002 F Vermont $605,407 $1.97 2010 G Ohio $588,072 $2.00 -
Virginia Tech ACIS 2504
Directions Complete the following directions for the associated worksheets by class time on Tuesday, September 20. There will be an in-class quiz for this project on that day. Players worksheet 1 Add a column between the \"Birthdate\" column and the \"YTD Ea -
Virginia Tech ACIS 2504
Directions For this project, you will prepare a monthly personal budget template. When setting up the budget, you will input your estimates for each category at the beginning of the month. During the month, you will keep track of your income, savings, and -
Virginia Tech ACIS 2504
SizeoftheSolarSystem AssumingtheEarthis400ftfromtheSun intheModel Correctedscaletofitsin1squaremile DistancesofPlanets DataforGraphPrototype Distance fromSun (10^6km) (Xcolumn) (Ycolumn) Mercury 1 57.9 Venus 1 108.2 Earth 1 149.6 Mars 1 227.9 Juptiter 1 7 -
Virginia Tech ACIS 2504
Favorite Pies (In Percentage of Tastiness) Type Tastiness Apple 80% Cherry 70% Key Lime 50% Peach 90% Pecan 85% Favorite Pies Pecan 85% Peach Key Lime 90% 50% Cherry 70% Apple 0% 80% 10% 20% 30% 4 0% 50% 60% 70% 80% 90% 100% Percent age of T ast iness Fav -
Virginia Tech ACIS 2504
9/27 Design -> Select Data (defines data being used) Chart title -> a text box Or select Chart title = Cell reference + ENTER = Title Layout tab -> Labels -> None Layout tab -> labels -> axis title (to add a title) Layout tab -> labels -> data labels (to -
Virginia Tech ACIS 2504
10/6/11 Data table > Data Tools -> What if analysis When you have two variables, you can only evaluate one formula at a time Formula you evaluate will be placed in intersection (between column and row) formula you want evaluated Row input = refers to inpu -
Virginia Tech ACIS 2504
9/8 =TODAY( ) Function =NOW () function Subtract dates, = Cells, gives you the number of days in between =int( ) rounds to whole number =round () rounds to any number specified =DAY ( ) gives you date =MONTH =YEAR =DATE(C#,C#,C#) to give you date CUSTOM N -
Virginia Tech ACIS 2504
Insert a new employee timesheet Create a new worksheet o Name worksheet using employees name Create column labels for employee info (make the font bold) Create column for time pay info (make the font bold) Create formulas o Gross pay = hours worked x pay -
Virginia Tech ACIS 2504
Lesson 9-1 9/6 Check order of precedence. o First ^, second * or /, third + or -, fourth = o Starts from left to right o Parenthesis to set precedence Sales tab o To sum total, =sum(total expenses, taxes) o Or sum ranges together, =sum(B6:B17,F6:F17) o To -
Virginia Tech ACIS 2504
ACCRUALRULES [TheRulesthatProduceFinancialAccountingInformation] Big picture:Toprovideanaccountingofsomethingmeanstocommunicate theeffects ofasituationorevent onaperson,organization,orthingofinterest. The purpose of business accounting is toreporttovari -
Virginia Tech ACIS 2504
Chapter 6, Part 1 of 2: Using Excel to Support Business Decisions Chapter 6, Part 1 Skills Distinguish between subjective and objective decision model designs. Select the appropriate type of decision model for a business problem. Apply sensitivity anal -
Virginia Tech ACIS 2504
Chapter 1: Getting Started with Excel 2007 Chapter Skills Save a new Excel file with the appropriate file extension o The most secure file format o File formats that support macros Access Excel Help features Enter and format worksheet data Insert and -
Virginia Tech ACIS 2504
Chapter 2: Excel Formulas Chapter Skills Recall the four goals of good spreadsheet design: Copy and paste formulas using cell references entering cell references into formulas use absolute cell references in formulas use relative cell references in for -
Virginia Tech ACIS 2504
Chapter 3: Excel Functions, Part 3 (of 4): Financial Functions Chapter Skills for Part 3 Practice using financial functions to return data variables as used in various calculations of time value of money. Understand each argument of financial functions -
Virginia Tech ACIS 2504
Chapter 3: Excel Functions, Part 1 (of 4) This chapter will be presented in three parts: 1) Introduction to Excel Functions & Working with Dates in Excel 2) Mathematical and Logical Functions (with emphasis on the IF Function) 3) Financial Functions 4) LO -
Virginia Tech ACIS 2504
Chapter 3: Excel Functions, Part 2 (of 4): SUMIF, COUNTIF, & IF Functions Chapter Skills for Chapter 3, Part 2 Use functions that allow the user to specify criteria for including data in the aggregate operation. (These are not logical functions, but use -
Virginia Tech ACIS 2504
Chapter 3: Excel Functions, Part 4 (of 4): Lookup Functions Chapter Skills for Chapter 3, Part 4 Use the VLOOKUP HLOOKUP functions to return a match based on an alphabetic -
Virginia Tech ACIS 2504
Chapter 4: Excel Charts Chapter Skills Identify the appropriate chart type for a set of data. o Column chart (including clustered column and stacked column charts) o Bar chart (including stacked bar chart) o Line chart o Scatter chart o Pie chart Arrange -
Virginia Tech ACIS 2504
Chapter 5, Part 1 of 2: Importing & Exporting Data Chapter 5, Part 1 Skills Understand and apply the critical guidelines for list development that enable the automatic Excel list features to work correctly. Import delimited data into Excel. Use formulas a -
Virginia Tech ACIS 2504
Chapter 5, Part 2 of 2: Managing Excel List Data Chapter 5, Part 2 Skills Understand and apply the critical guidelines for list development that enable the automatic Excel list features to work correctly. Sort data rows by one column. Sort data rows by mu -
Virginia Tech ACIS 2504
Chapter 6, Part 2 of 2: Using PivotTables to Support Decisions Chapter 6, Part 2 Skills Recognize the type of data that benefits from PivotTable (& PivotChart) analysis. Set up a pivot table to view the desired dimensions of the data summary. Group PivotT -
Virginia Tech ACIS 2504
Copy and paste Just image, no data behide, cant interact Copy and embed Copy and link -
Virginia Tech ACIS 2504
Charts Charts Two basic placements of charts within a workbook o Embedded charts are objects within another worksheet o Chart sheets Dynamically update based on changes in underlying data To change a chart from an embedded chart to a chart sheet o Char -
Virginia Tech ACIS 2504
Data Analysis Data Tables Allow you to examine how changes in one or two variables can affect other formulas Data Tables are dynamic if you make changes to the underlying formulas or to the range of possible values for the variables, the Data Table will -
Virginia Tech ACIS 2504
Data Analysis (Day 2) Solver Allows you to optimize a model based on objectives, variables, and constraints Solver is an Excel add-in, and must be installed o To install Solver: File Excel Options Add-Ins (select Solver Add-in and click Go, and then cl -
Virginia Tech ACIS 2504
Managing Data in Excel Linking Workbooks Cell references to other workbooks are called external references A dependent workbook will reference data which is contained in the source workbook An external reference will have the following form: o [Workboo -
Virginia Tech ACIS 2504
Data Validation Excel Errors Excel will show an error preceded by a # sign o #DIV/0! o #N/A o #NAME? o #NULL! o #NUM! o #REF! o #VALUE! When an error is present, a small green triangle will appear in the top left corner of a cell (note that Excel may vi -
Virginia Tech ACIS 2504
Pivot Tables PivotTable Basics A PivotTable is a powerful summary tool o PivotTables wont update automatically when the underlying data is changed you have to choose to refresh the data (unless you use an Excel table as the underlying data; when you add -
Virginia Tech ACIS 2504
Pivot Tables (Day 2) U.S. Census Bureau Example Layout o Report Filters: None o Row Labels: STATE o Column Labels: None o Values: POP010210 (2010 Population), POP010200 (2000 Population) Filters o Row Labels: Filter out blank row labels Field Settings -
Virginia Tech ACIS 2504
Tables and File Management File Management Good practices o Name files appropriately o Use a clear filing system (create a hierarchy) o Dont save everything to your Desktop or to Documents (even though this might be the default) Transferring files o To -
Virginia Tech ACIS 2504
VBA Structure Day 2 Developer Tab, Visual Basic Icon o Opens up visual basic editor To make a variable write Dim VariableName As DataType o I.E. Dim Last As String o Dim First As String Use input boxes to obtain the necessary data o Prompt is the only -
Virginia Tech ACIS 2504
Introduction to VBA and Macros What is VBA? What is VBA? o VBA stands for Visual Basic for Applications o VBA is a programming language o Works in the background for all Microsoft Office applications (Excel, Word, Access, etc.) o Works in conjunction wit -
Virginia Tech ACIS 2504
VBA Structure Objects Application, Workbooks (a collection of Workbook objects), Worksheets, (a collection of Worksheet objects), Range, etc. To refer to a specific item within a collection (e.g. Worksheets), include the name within parentheses (e.g. Wo -
Virginia Tech ACIS 2504
Charts Charts are dynamic 3 tabs: o Design o Layout o Format In Layout and Format tabs go to drop down where current selection is o You can choose a bunch of options here 1. Bar Graph about Pies To Make chart click anywhere in the data set and go to i -
Virginia Tech ACIS 2504
Data Analysis What if analysis: o Create a series of new interest rates o We want to recalculate each formula at the new interest rates o To convert row labels to column labels go to copy, pick the cell and then use paste special (transpose) To fill tab -
Virginia Tech ACIS 2504
Data Management The forecast function allows you to specify a particular X value for which you want a corresponding Y value for existing X and Y values Go to Jan sales, type in =, go to the East, west, North, and south WS and select appropriate cells ad -
Virginia Tech ACIS 2504
Loan Payment Calculator Loan amount APR Number of periods Payment Period Principal amount Interest amount 10,000 4.28% 36 (296.49) 10 ($269.31) ($27.17) $10,000.00 4.28% 36 ($296.49) Credit Card Payment Calculator Credit card balance APR Minimum payment 1 -
Virginia Tech ACIS 2504
Date and Time Functions Today\'s date Current time First day of the year Days from Jan. 1 12/6/2011 12/6/2011 10:00 Times > midnight 9/9/2011 1:00 Tomorrow\'s date 12/7/2011 Today 1 week from today 2 weeks from today 3 weeks from today Birthday Today Age (u -
Virginia Tech ACIS 2504
Class Schedule CRN Course 90110 ACIS-2115 90125 ACIS-2504 91020 BIT-2405 98275 ECON-2005 93691 HTM-1414 Title Principles of Accounting Personal Computers in Business Quantitative Methods Principles of Economics Intro to HTM Management Instructor LA Almond -
Virginia Tech ACIS 2504
Introduction to VBA and Macros What is VBA? What is VBA? o VBA stands for Visual Basic for Applications o VBA is a programming language o Works in the background for all Microsoft Office applications (Excel, Word, Access, etc.) o Works in conjunction wit -
Virginia Tech ACIS 2504
Pivot Tables Day 2 Pivot chart is always tied to pivot table Pivt Table Field List o Axis Fields = Row Labels Applying WS protection to protect formulas: o You have to select cells, format cells, protection, and then unlock them A one input Data table -
Virginia Tech ACIS 2504
Tables Excel is a tables program, not a database program (Access) When dealing with databases: o Column = field o Column header = field name o Row = record Select everything and go to insert, table o Lots of stuff changes o Drop down boxes next to fiel -
Virginia Tech ACIS 2504
VBA Structure (Day 2) MsgBox Function Shows a message box with a message that the developer specifies InputBox Function Allows the user to provide input which will be used in the macro If-Then construct You can use an If-Then construct (similar to the -
Virginia Tech ACIS 2504
Chapter 5 1. When referencing an external workbook in an excel formula use a. [] 2. Use the text category of functions to manipulate data to improve list structure or data quality of an imported list of data. 3. _field_ is a term that literally refers to -
Virginia Tech ACIS 2504
Chapter 1: Getting Started with Excel 2007 Skills Practice 1. Navigate Excel using the Excel Ribbon a. Ribbon Tabs i. \"Home\" ii. \"Insert\" iii. \"Page Layout\" iv. \"Formulas\" v. \"Data\" vi. \"Review\" vii. \"View\" viii. Context tabs b. Navigate Excel using the Q -
Virginia Tech ACIS 2504
ExcelFormulas ClicktoeditMastersubtitlestyle Chapter2 TopicsfromChapter2 Workbookdesigngoals Usingcellreferencesinformulas Relative Absolute Usingnamedcellranges Troubleshootingformulaerrors ErrorValues FormulaAuditingTools Protectingworksheets Protec -
Virginia Tech ACIS 2504
C hapter 2: Excel Formulas Chapter Skills Recall the four goals of good spreadsheet design: Copy and paste formulas using cell references entering cell references into formulas use absolute cell references in formulas use relative cell references in f -
Virginia Tech ACIS 2504
Click to edit Master subtitle style Chapter 3 Excel Functions (an introduction & overview) 11 What is a function? In any environment, it is a predefined formula that performs some calculation or manipulation. accepts one or more inputs returns exactly one -
Virginia Tech ACIS 2504
C hapter 3: Excel Functions, Pa r t 1 (of 4) This chapter will be presented in th ree pa rts: 1) I n t roduction to Excel Functions & Working w ith Dates in Excel 2) M athematical and Logical F unctions (with emphasis on the I F Function) 3) F inancial Fu -
Virginia Tech ACIS 2504
C hapter 3: Excel Functions, Pa r t 2 (of 4) Chapter Skills for Chapter 3, Pa r t 2 Use some statistical functions that allow the user to specify criteria for including data in the operation. o SUMIF (or SUMIFS) functions to sum numeric data that meets s -
Virginia Tech ACIS 2504
C hapter 3: Excel Functions, Pa rt 3 (of 4) Chapter Skills for Part 3 Practice using financial functions to return various data variables used i n the calculation of t ime value of money. Understand each argument of financial functions used in t ime valu -
Virginia Tech ACIS 2504
C hapter 5: \"List Management\" ( Managing Data in Excel) Pa rt 1 of 2 (The mate rial on 3-D formulas that was presented M a rch 16 is included in t his pa rt.) Chapter 5, Pa rt 1 Skills Understand and apply the critical guidelines for list development tha -
Virginia Tech ACIS 2504
C hapter 5: \"List M anagement\" ( Managing Data in Excel) Pa rt 2 of 2 Chapter 5, Pa r t 2 Skills Understand and apply the critical guidelines for list development that enable t he automatic Excel list features to work correctly. Freeze panes to view col -
Virginia Tech ACIS 2504
Chapter 6 Quiz 1.Only the output can be produced using a t wo-variable data table. 1.The SUMPRODUCT function may be used in the decision matrix model to calculate the total weighted score for each decision alternative-. 1.The use of assumption cells for t -
Virginia Tech ACIS 2504
Purpose: To practice manipulating dates in Excel, and to utilize DATE/TIME, TEXT, and other categories of Excel functions. Creator: Marilyn Griffin Notes: This practice file accompanies class notes for Chapter 3, Part 1. Calculate age that is static Enter -
Virginia Tech ACIS 2504
EmployeeID LastName 1 Abner 2 Butler 3 Conrad 4 Davis 5 Edwards 6 Franklin 7 Gardner 8 Hilton 9 Jameson 10 Kelly 11 Zahn 12 Patel 13 Schnider 14 Zulkowski 15 Crockett 16 Hancock 17 Bateman 18 Powell 19 Phillips 20 Howard 21 Evans 22 Mathis 23 Morgan 24 Ca -
Virginia Tech ACIS 2504
Product Mix Analysis for September, 2008 Product 1 12 $1,200 Units Produced Unit Revenue Cost Category LaborHours Material Fixed(allocated) Product Cost Product Profit Total Profit Unit Cost $15 $80 $125 Cost Units Total cost 15 5 1 Product 2 Product 3 Co -
Virginia Tech ACIS 2504
Very Simple Payroll Application (Calculates Gross Pay for One Pay Period) SSN 111-11-1111 222-22-2222 333-33-3333 444-44-4444 555-55-5555 666-66-6666 777-77-7777 888-88-8888 999-99-9999 LastName Abner Butler Conrad Davis Edwards Franklin Gardner Hilton Ja -
Virginia Tech ACIS 2504
Homework 2: Create a Grade Calculator Use formulas and functions to create a term grade calculator that applies the following grading rules: 1. Three semester exams, each worth 100 points 2. Optional final exam worth 100 points: When the final exam is tak -
Virginia Tech ACIS 2504
ACIS 2504 Tentative Class Schedule, Fall 2009 Instructor: Marilyn Griffin You will be notified of any schedule change via a Blackboard \"Announcement\". Day Date Topic Tues 8/25 Thur 8/27 Course Intro & Introduction to Excel 1: Getting Started with Excel 2: -
Virginia Tech ACIS 2504
Personal Computers in Business ACIS 2504, Fall Semester 2009 Instructor: Marilyn Griffin Class Meeting Times Thursdays, 2:00-3:15, 5:00-6:15 in Torgersen 2150 Course Web Site: Blackboard at http:/learn.vt.edu Instructor E-mail: E-mail -
Virginia Tech ACIS 2504
50 mc questions 12 from ch.4 Strictly related to chart types with types of data Simple column chart vs. cluster chart Do not study bubble, radar, area and formatting of charts 7 matching with chart types Cluster, column, bar, stacked bar, etc Ch.6 Just pi -
Virginia Tech ACIS 2504
The Aeneid was written by Virgil around the time of 29-19 B.C. around the fall of the republic. Though he did not finish the work before he died, it was latter published after his death. He gained fame through his writings of the Eclogues and the Georgics -
-
Virginia Tech ACIS 2504
C hapter 2: Excel Formulas Chapter Skills Recall the four goals of good spreadsheet design: Copy and paste formulas using cell references entering cell references into formulas use absolute cell references in formulas use relative cell references in -
Virginia Tech ACIS 2504
* * * I F functions- when using AND logic then the subsequent if statement need to be nested in the value if t rue * * *For OR logic each subsequent if function is nested in the v alue if false * * * Requi rement for lookup table, range data must be in as -
Virginia Tech ACIS 2504
C hapter 3: Excel Functions, Pa r t 3 (of 3) Chapter Skills for Chapter 3, Pa r t 3 Use the VLOOKUP function to return a match based on a numeric range. Use the VLOOKUP function to return an exact match. Use the VLOOKUP function to return a match based on -
Virginia Tech ACIS 2504
C hapter 9 Summa ry/Review Questions 1. What is a variable? 2. How does a constant differ from a variable? 3. What naming convention is specific to constants? 4. How is a value assigned to a variable? 5. What does it mean to \"initialize\" a variable or con -
Virginia Tech ACIS 2504
C hapter 13: Pa rt 2 Using the R1C1 Reference Style in VBA Continue with the M acroPractice.xlsm f ile you created in a previous exercise. Change your cell reference style to R1C1 (you should be able to use one of your worksheet buttons). Objective: Recor -
Virginia Tech ACIS 2504
Attribute VB_Name = \"Functions\" O Option Explicit Function NewSheetName(oldName As String) As String Dim strMonth As String D Dim intYear As Integer strMonth = Left(oldName, 3) On Error GoTo YearError i intYear = CInt(Right(oldName, 4) Select Case LCase(s -
Virginia Tech ACIS 2504
(Visual Basic for Applications) Click to edit Master subtitle style Introduction to Macros & VBA Supplemental Reading In addition to Chapter 13: Chapter 7 Read entire chapter (10 pages) Study pages 286-289 Goal: Understand the 3 types of programming struc -
Virginia Tech ACIS 2504
C hapter 6: Using PivotTables to Support Decisions Chapter Skills Recognize the type of data that benefits from PivotTable (& PivotChart) analysis. Understand how to set up a pivot table to view the desired dimensions of the data summary. Group PivotTa -
Virginia Tech ACIS 2504
Chapter 9 Summary/Review Questions 1. What is a variable? 2. How does a constant differ from a variable? 3. What naming convention is specific to constants? 4. How is a value assigned to a variable? 5. What does it mean to \"initialize\" a variable or const -
Virginia Tech ACIS 2504
Using Variables and Constants in VBA & Troubleshooting Programming Errors Selected topics from Chapter 9 Click to edit Master subtitle style 11 Handling Program Data n Programs process sets of data, such as: n Calculating invoice totals based on invoice s -
Virginia Tech ACIS 2504
Introductionto ProgrammingStructures ClicktoeditMastersubtitlestyle SelectedTopicfrom Chapter7 ProgrammingLogic Structured Programming Structured programming means that all program code is written using one of 3 programming control structures. S Sequence -
Virginia Tech ACIS 2504
Loop Design and Modeling Click to edit Master subtitle style Selected Topics from Chapters 12 & 16 8/15/11 Loops a.k.a. Repetition structures a.k.a. Iterative structures Loops repeat one set of instructions multiple times. For example, repeat a set of ins -
Virginia Tech ACIS 2504
C hapter 13: Pa rt 2 Using the R1C1 Reference Style in VBA Continue with the M acroPractice.xlsm f ile you created in a previous exercise. Change your cell reference style to R1C1 (you should be able to use one of your worksheet buttons). Objective: Recor -
Virginia Tech ACIS 2504
C hapter 13: Pa rt 1 - I n t roduction to Visual Basic for A pplications ( and Working w ith M acros in Excel) Lea rning Objectives Add the Developer tab to the Excel r ibbon to access the VBA programming environment. Record a macro and save it in the act -
Virginia Tech ACIS 2504
C hapter 1: Getting Started w ith Excel 2007 ACIS 2504, Fall 2009 Skills P ractice Open Excel and create a new Excel workbook. 1. Navigate Excel using the Excel Ribbon 2. Navigate Excel using the Quick Access Toolbar a. Add common commands to the Quick Ac -
Virginia Tech ACIS 2504
Chapter 5: List Management Chapter Skills Understand and apply the critical guidelines for list development that enable the automatic Excel list features to work correctly. Freeze panes to view column or row headers for all rows of list data. Apply dat -
Virginia Tech ACIS 2504
Product Mix Analysis for September, 2008 Product 1 12 $1,200 Units Produced Unit Revenue Cost Category Labor Hours Material Fixed (allocated) Product Cost Product Profit Total Profit Cost Units Total cost Unit Cost $15 $80 $125 15 5 1 Product 2 Product 3 -
Virginia Tech ACIS 2504
ExcelFormulas ClicktoeditMastersubtitlestyle Chapter2 TopicsfromChapter2 Workbookdesigngoals Usingcellreferencesinformulas Relative Absolute Usingnamedcellranges Troubleshootingformulaerrors ErrorValues FormulaAuditingTools Protectingworksheets Protec -
Virginia Tech ACIS 2504
Purpose: To practice manipulating dates in Excel, and to utilize DATE/TIME functions. Creator: Marilyn Griffin Notes: This practice file accompanies class notes for Chapter 3, Part 1. Calculate age that is always current Enter today\'s date Enter your birt -
Virginia Tech ACIS 2504
City State ZipCode Agawam MA 01001 Amherst MA 01002 Belchertown MA 01007 Chicopee MA 01020 Easthampton MA 01027 East Longmeadow MA 01028 Granby MA 01033 Holyoke MA 01040 Ludlow MA 01056 Monson MA 01057 Northampton MA 01060 Palmer MA 01069 South Hadley MA -
Virginia Tech ACIS 2504
ACIS2504GradeCalculator Exam1 Exam2 Exam3 FinalExam ExamTotalPoints FinalCourseAverage FinalCourseGrade 66.8 36 66 94 226.8 88.13% B+ SyllabusQuiz HW1Quiz HW2Quiz HW3Quiz HW4Quiz HW5Quiz HW6Quiz HW7Quiz TotalQuizPoints QuizAverage AdjustedQuizPoints 12 6 -
Virginia Tech ACIS 2504
Writing Custom Functions in VBA Chapter14 ClicktoeditMastersubtitlestyle Custom VBA Functions \"Custom\"becauseyoudesignitandwriteitinVBA foryourspecificpurpose. Examples: l l Afunctionthatcalculatesasalescommissionthatmay includecomplexlogic Afunctionthatc -
Virginia Tech ACIS 2504
F unction Basics F unction Pa rts ( and an example of each) Function Name: t ax Input variables and type of each: ( taxableAmount is money, taxRate is decimal) Output data type: money Function Calculations/Manipulations: t ax = taxableAmount * taxRate So -
Virginia Tech ACIS 2504
EmployeeID Name Phone Address ZipCode SSN HireDate SeparationDate Title 1 Kevin Gates 402-146-7714 4714 Countrywood Drive 68501 387-39-3938 29-Jan-01 Manager 2 Bonnie Reese 919-245-0526 7140 Blackjack Road 27842 151-23-1243 31-Mar-01 Manager 3 Kathy Bisho
7,000,000 study materials • 24/7 tutors • earn better grades