StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Technical communication - Essay Example

Cite this document
Summary
Formulas are commands that instruct Microsoft Excel to carry out certain calculations. In responding to these calculations, Excel spreadsheet uses cell references and designated values. Microsoft…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.2% of users find it useful
Technical communication
Read Text Preview

Extract of sample "Technical communication"

Creating Formulas and Using them to perform Calculations in a Microsoft Excel Workbook Table of illustrations Table NumberPurposeTable 1.0Shows characters used in creating formulasTable of figures Figure NumberPurposeFigure 1Summarizes the steps followed in changing to manual calculations Figure 2Shows how the calculate now option appearsIntroduction Microsoft Excel helps in performing calculations using functions and formulas. Formulas are commands that instruct Microsoft Excel to carry out certain calculations.

In responding to these calculations, Excel spreadsheet uses cell references and designated values. Microsoft Excel has functions that help perform calculations automatically and embedding these functions with formulas helps save on time and work. Understanding how to write and use formulas in Microsoft excel requires an understanding of basic formula requirements. An equals sign appears in the beginning of a formula and it informs Excel about the task it is about to do. Operands are values used in the creation of a formula.

Operants are commands that guide Excel on what actions to perform on operands. Addition, subtraction, division, and multiplication are examples of operants. Below are guidelines on how to write formulas that can ease working with a Microsoft Excel workbook (Taylor 17). There are also guidelines on how to change to manual calculation in the workbook. Creating a formula for linking information in a single Microsoft Excel worksheetThe complexity or simplicity of a formula depends on the needs of a user.

It is advisable to insert a function when creating complex but fairly common formulas. This way, users do not have to create the entire formula (Taylor 18). Below are the steps followed in creating a formula used for linking information contained in a single Microsoft Excel worksheet. 1. Pick a cell where the results of the calculation will be displayed 2. Press the equals sign [=]3. Select the first cell that will be included or type the reference of the preferred first cellNote: Users need to consider whether they will be using absolute or relative reference4.

Type the preferred operator for example, [-]5. Select the second cell or type the reference of the second cell to be included6. Repeat steps 4 and 5 as appropriate until the completion of the targeted formula7. Press Enter [Enter] to finish creating the formulaNote: Pressing away from the cell before pressing Enter [Enter] adds that cell onto which you click. Creating formulas for many Excel WorksheetsWriting formulas that include information that are in different worksheets is more complicating that writing a formula that involves information on the same worksheet.

Microsoft Excel allows the linkage of information in different cells in the same or different worksheets contained in the same workbook. Five symbols help make formulas that link information from in worksheets (Taylor 19). The table below summarizes these five symbols, their names and use within formulas. Table 1.0Character Name Use within formulas+Plus signSignify a range[ ]BracketsEncompasses a filename :Colon Signify a range `Apostrophe Places around filenames and sheet names or when sheet names contain spaces!

Exclamation pointPlaces between worksheet names and cell references Note: a) A colon, for example, in A5:A8, signify a range from A5 through to A8b) A plus sign, for example, in D3+G5, means D3 and G5 onlyCreating a formula that link to a Microsoft Excel worksheet in a workbookMicrosoft Excel enables the creation of formulas linking to other worksheets in a workbook. 1. Pick the cell where the formula is to appear2. Type the details of the formula using the format of the example; =name of function(name of worksheet!

cell refence)Note: a) The above format works for worksheets without space in their namesb) Worksheets that have space between their names have apostrophes before and after the names of the worksheet so that their formula would appear in the format: =name of function(‘name of worksheet’!cell refence)3. Press Enter [Enter] to accept the formula (Taylor 20)Creating a link between multiple Microsoft Excel worksheets in a workbook Microsoft allows the creation of links between multiple worksheets at ago.

This helps users to perform calculations that involved a range of worksheets1. Pick the cell in which the formula will appear2. Use the following format in typing the details of the formula: =function(range of worksheets!cell reference)Note:a) Worksheets without space in their names use a formula with the above formulab) Worksheets with space in their names have apostrophes before and after the range of worksheets3. Users have to use a colon or plus sign to indicate the range of worksheets4. Press Enter [Enter] to accept the formula (Taylor 21)Changing to manual calculations Changing to manual calculations helps speed up the rate of entering data.

There are steps used in changing to manual calculations (Taylor 22). These steps are highlighted below. 1. Click on the ribbon and 2. Pick the command tab of formulas3. Select calculations4. Click on options 5. Pick the option of manual These actions can be summarized using the following illustration. Fig. 1 Note: Users can use the option of manual calculation either using the keyboard or using the ribbon. Steps in using the manual calculation option through the keyboard1. Press the F9 [F9] key or Press the Control [Ctrl] key then the plus sign and then the equals sign.

This can be summarized using the following format: [Ctrl] + [=]This updates the data automatically (Taylor 23)Steps in using the manual calculation option using the ribbon1. Pick the command tab of formulas on the ribbon2. Click on calculate now in the calculations groupFig. 2The calculate now option in the calculations groups appears as shown in the figure belowClicking on the Calculate now option in the calculations group updates the data automatically (Taylor 17)Works citedTaylor, Mark. Learn Microsoft Excel at Advanced Level.

Northampton: Paragon Pub, 2009. Print.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Technical communication Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
Retrieved from https://studentshare.org/miscellaneous/1627597-technical-communication
(Technical Communication Essay Example | Topics and Well Written Essays - 500 Words)
https://studentshare.org/miscellaneous/1627597-technical-communication.
“Technical Communication Essay Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/miscellaneous/1627597-technical-communication.
  • Cited: 0 times

CHECK THESE SAMPLES OF Technical communication

Technical Communication and Ethics

The author of the essay "technical communication and Ethics " stats that In this case, Dexter Tools has put out a brochure with its electric drill, showing a child using the tool, along with the statement, “It's so easy to use, even a kid could use it!... rdquo;… The company has also placed a parental figure in the background of the drawing and included instructions with the drill telling the owner to keep the product away from children....
1 Pages (250 words) Essay

Technical Communication Sample

Though both academic and technical writing have jargons in them, both are used for different purposes. The technical technical communication There are certain essential features that distinguish academic writing from technical writing.... Evidently, the White Paper epitomizes the concept of technical communication.... This technical communication gives no chance for entertainment.... While the purposes of academic writing are to present ones knowledge to others, to present the result of ones research, or simply to present ones point of view, the main purposes of technical writing can be to teach someone how to use a particular product or service, or to detail the procedures to be followed to do certain tasks in a company....
2 Pages (500 words) Essay

Professional and technical communication

It is the largest humanitarian organization in the world.... It does not discriminate in terms of race, religion, nationality or political opinions.... It was founded in 1919 and currently has 186 members… The members comprise of Red Cross and Red Crescent National Societies.... The Red Crescent is used in place of Red Cross in Islamic countries. IFRC aims at promoting and maintaining human dignity and peace throughout the world....
5 Pages (1250 words) Essay

The role of ethics in technical communication

Figure fudging, picture editing and other The role of ethics in technical communication: technical communication is of ive nature and can have an opinion attached to it.... However, the ethical aspect must be taken into account, while performing the task of technical communication.... here are different dimensions of technical communication.... he piece of technical material should have the necessary recipe that addresses all the aspects that are essential for making an effective technical report and technical communication....
1 Pages (250 words) Essay

Effective Technical Communication

The essay "Effective technical communication" describes that the discipline in discussion is the business field with a focus on Nestle as the business organization.... Effective technical communicationThe discipline in discussion is the business field with a focus on Nestle as the business organization....
1 Pages (250 words) Essay

Building Technical Communication Skills

My main concern should and will always be the merging of the two communication tools in order to support the development of technology and understanding among all levels of society and professional sectors.... The job of a technical communicator is something that I now consider to be one of the most important duties and positions in a company that is tasked with sharing information with people either within a given field of expertise, or with the public in general....
1 Pages (250 words) Essay

Strategies for Technical Communication

The subject of the paper "Strategies for technical communication" is to recommend the most and least beneficial units/teaching assignments in the course.... The author will analyze the units, which are being taken in the course in terms of their benefits to the students and the lecturer....
3 Pages (750 words) Coursework

Professional and Technical Communication Report

One of the basic pillars of the process of mentoring would be communication, which is one of the most debated upon and argued skills with respect to the functions in the modern corporate world.... … [Training and mentoring]ReportExecutive Summary:The problem at present is with the recurring complaints that are emanating from the senior members of the staff regarding the adaptability of the new graduates in the overall scheme of things....
9 Pages (2250 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us