Please respond by answering the following:
A: List one function or topic discussed in the reading that you think is important or stood out to you from the list below:
Item A: Integration
Item B:
free data exchange between various programs of Windows and Excel
item C: Unit M, Exchanging Data with Other Programs
Item D: I found this handy and convenient when exchanging data between excel and other programs because there’s compatibility in the various tools found in the Microsoft Office programs Item A: Data Exchange
Item B:Before the actual exchange of data you must plan first the objective of every data exchange (the goal)
Item C: Unit M, Planning a Data Exchange
Item D: the guidelines offered can be quite useful in enhancing a smooth data exchange Item A:Source Program
Item B:So that the connection can be maintained, the files should not be inserted with the use of a simplified paste command method
Item C:Unit M, Embedding a Workbook in a Word Document (pg 306)
Item D: the step-by-step procedures can save valuable time during data exchange rather than being bombarded by recurring disconnections Item A:Destination Program
Item B: Simultaneous working of Microsoft programs and insertion of the document in a dissimilar program
Item C:Unit M, Embedding a Workbook in a Word Document
Item D:So as to know the process that you use to do the data exchange, it’s recommended that know both the programs that made the data that’s to be exchanged and also the receiving program
Object OLE Linked Object Embedded Object
Item A:Importing Files
Item B: readable files by Excel can be brought in using other programs
Item C: Unit M, Importing a Text File
If at all the type of the file can be read by the Excel, data made in other programs can be brought in using it Item A:Delimiter
Unit B: Columns separating received data
Item C:Unit M, Importing a Text File
Unit D:Used in tabs to show where the tabs, divide the hordes of data being received Unit A: Linked Object
Unit B:They are used to show the alterations that are made on the original file after a workbook is joined to another
Unit C: Unit M, Linking a Workbook to a Word Document
Unit D: can be used to make references on the original document Unit A:m Embedded Object
Unit B:They allow one to edit a workbook of Excel from within a dissimilar program with the use of Excel features(tools and commands)
Unit C: Unit M, Embedding a Workbook in a Work Document
Unit D:it implies that it’s an added advantage to embed the objects than merely paste them
Reading Two
Please respond by answering the following:
A: List one function or topic discussed in the reading that you think is important or stood out to you from the list below:
Unit A:Worksheet Auditing
Unit B: a system that points out errors during editing
Unit C: Unit O, Auditing a Worksheet
Unit D:The sole purpose of auditing is to track mistakes since they can appear in any process of the worksheet improvement Unit A: unit Grouping Data
Unit B: systematic arrangement of data
Unit C: Unit O, Grouping Worksheet Data
Unit D: In a worksheet, the data is grouped using columns and rows so as to make it more convenient when working with it Unit A: Cell Comments
Unit B: annotations surfacing when a the pointer is placed over cell after they are being attached to individual cells
Unit C: Unit O, Using Cell Comments
Unit D:when they are attached to the worksheet, they hasten the time that your working partner familiarizes himself with your work Unit A: Custom Autofill Lists
Unit B:They are typed listing of words in blank cells that make the whole text/name appear after the starting digits are entered
Unit C: Unit O, Creating Custom Autofill Lists
Unit D: they help one save valuable time by clicking the first digit and the rest clicks into place
Customize Excel Workbooks Customize Excel Options Template Error Checking
Unit A: Worksheet Calculation Options
Unit B: they are automatic calculations on large worksheets
Unit C: Unit O, Controlling Worksheet Calculations
Unit D: Recalculations in big worksheets make the process of the entry of data and updating of the screen sluggish and if the user wants the worksheets to update automatically, adjusts the mode of calculation to manual since it’s the mode that Excel uses to all the worksheets that are open Unit A: Customize Excel Options
Unit B:This feature allows one to insert commands in the Quick Access
Unit C: Unit O, Customizing Excel Options
Unit D: they bring convenience since they can be got using a single click Unit A: Template
Unit B: it’s a workbook with features that are used frequently
Unit C: Unit O, Creating a Template
Unit D: they provide the need to no more to enter the standard data again when one wants to create a fresh workbook after they are saved in a wordbook which has features that are often used Unit A: Error Checking
Unit B:that are tools that point out to the errors edited
Unit C: Unit O, Auditing a Worksheet
Unit D: these tools help identify errors which one is prone to when editing and they recognize the errors by auditing the entire worksheet
Reading Three Please respond by answering the following:
A: List one function or topic discussed in the reading that you think is important or stood out to you from the list below:
Unit A: Visual Basic Editor
Unit B:it’s used to both examine or edit a macro and creating new macros
Unit C: Unit P, Viewing VBA Code
Unit D: They come in handy when one wants to see or edit an already present macro and also make new ones (Reding Elizabeth, 2007)
Unit A: Comments
Unit B: notes defining the various codes and displays in green and the one to be used is displayed in black
Unit C: Unit P, Viewing VBA Code
Unit D: Conserve time when one is surfing through the codes Unit A:Arguments
Unit B:they are variables applied by other starting steps that run the main procedure
Unit C: Unit P, Viewing VBA Code
Unit D: they are handy when one wants to refer to one of the constituents of data inserted to the subroutine Unit A: Procedure Header
Unit B: They are used to state the various features of a procedure including namely type, arguments and the name
Unit C: Unit P, Viewing VBA Code
Unit D: assist in the memory location of the procedure to be used by recalling the name assigned to the word inserted in the procedure header: therefore I found them to be time conserving
Keywords Analyzing VB Code Conditional Statement Function
Unit A:Debugging
Unit B: correcting an error after it has been locates by the Visual Basic Editor
Unit C: Unit P, Debugging a Macro
Unit D:Bearing the fact that the macro procedure may fail to run smoothly due to an error(bug),I found it handy because it can locate the error whereby one is helped to located the bug by the Visual Basic Editor Unit A:Main Procedure
Unit B: it’s the procedure made that processes many procedures in succession unit C: Unit P, Creating a Main Procedure
Unit D:Theses are created if one wants to conserve time if wanting to run a number of macros consecutively Unit A:Call Statement
Unit B:It’s typed to every procedure that one wants to run in a main procedure
Unit C: Unit P, Creating a Main Procedure
Unit D: I found them useful it puts off the need to frequently run the macros one after the other Unit A:Sub Procedure
Unit B:It’s a descriptive text that is used to explain the various parts of a main procedure
Unit C: Unit P, Creating a Main Procedure
Unit D: there are a number of macros that run in a procedure
This is completely my fault. I didn’t realize there was a specific format that the assignment was supposed to be in.
I’ve attached the directions that show the specific format. Can you put the information in the proper format?
References
Reding Elizabeth, W. L. (2007). Microsoft Office Excel 2007: Illustrated Complete. New York: Cengage Learning.
Order Management
Premium Service
- 100% Custom papers
- Any delivery date
- 100% Confidentiality
- 24/7 Customer support
- The finest writers & editors
- No hidden charges
- No resale promise
Format and Features
- Approx. 275 words / page
- All paper formats (APA, MLA, Harvard, Chicago/Turabian)
- Font: 12 point Arial/Times New Roman
- Double and single spacing
- FREE bibliography page
- FREE title page
0% Plagiarism
We take all due measures in order to avoid plagiarisms in papers. We have strict fines policy towards those writers who use plagiarisms and members of QAD make sure that papers are original.