Type Reference

is there a place I can type in my reference information and APA style will be done for me?

I need to type a reference list using APA style. I am confused by the order of the information. Is there a website that will put my information in the order it is supposed to go?

This is an instruction page to teach you how to do it yourself:

http://owl.english.purdue.edu/handouts/research/r_apa.html

Be careful with citation-generating Web pages and software. If you don't input it exactly right or have an odd source, it will give you a wrong citation. Your teacher will probably not accept that you got it from software as a defense--they expect you to learn it yourself.

10 pack MAXELL AG13 LR44 357 button cell battery 10 pack MAXELL AG13 LR44 357 button cell battery
Sale Price: $0.01

MAXELL AG13 LR44 357 A76 button cell battery. Factory sealed in blister pack. 10 batteries per card.

Bulbrite 655021 - Q20GY8/120 - 20 Watt Bi-Pin Halogen Light Bulb, G8 Base, 120 Volts Bulbrite 655021 - Q20GY8/120 - 20 Watt Bi-Pin Halogen Light Bulb, G8 Base, 120 Volts
Sale Price: $0.83

Wattage 20 Voltage 120 Base Type G8 Standard Pin to Pin Spread 8 mm Over All Length (M.O.L.) 1.77 in. Over All Diameter .53 in. Lumens (Initial) 240 Color / Hue Clear Average Life hours 2000 hrs...

Diabetes Type 2 GUIDELINES Pocketcard: American Association of Clinical Endocrinologists (2008) Diabetes Type 2 GUIDELINES Pocketcard: American Association of Clinical Endocrinologists (2008)
Sale Price: $8.95

The Diabetes Mellitus Type 2 GUIDELINES Pocketcard provides all that is needed to make accurate clinical decisions at the point of care including: Key points; Treatment Algorithm; Glycemic Control Module; Hypertension (HTN) Management Module; Eye Care Module; Neuropathy Module; Foot Care Module; Cardiac-Peripheral Vascular Module; Renal Disease Module; Current Medication Tables with Brand and Generic Names; Detailed drug information - strengths, formulations, side effects, comments.

Maxell Watch Battery Button Cell LR41 AG3 192 Pack of 10 Batteries Maxell Watch Battery Button Cell LR41 AG3 192 Pack of 10 Batteries
Sale Price: $0.01

10 pack Genuine MAXELL AG3 LR41 192 button cell battery

50 x AG13/LR44/A76 Alkaline button cell battery 50 x AG13/LR44/A76 Alkaline button cell battery
Sale Price: $2.99

Great battery for many Toys, Watches, Calculators, Abtronic devices, PDA, and many other items. Compatible: G13, AG13, 357, A76, LR44, SR44, 76A, G13A, LR1154, RPX675, D76A, V13GA, PX76A, GPA76, 1128MP, 1166A, S76

Button Cell Type 371 Battery Button Cell Type 371 Battery
Sale Price: $0.98

Button cell batteries are for use in watches, cameras, calculators and many other electronic components. Replaces Eveready ##371, Duracell ##D371, Maxwell ##SR920SW, Varta ##V371.

Maxell Watch Battery Button Cell LR1130 AG10 Pack of 10 Batteries Maxell Watch Battery Button Cell LR1130 AG10 Pack of 10 Batteries
Sale Price: $0.01

Maxell Watch Battery Button Cell LR1130. Maxell is a worldwide leader in small electronics batteries. Maxell offers a full line of Watch Electronic Specialty Batteries for applications used in precision engineering tools to power a wide variety of small electronic devices...

Energizer Watch Batteries 364/363 SR621SW Battery New Energizer Watch Batteries 364/363 SR621SW Battery New
Sale Price: $2.55

5 New Type 364 Energizer Batteries. This is a new set of 5 type 364 Energizer batteries. Brand New & Guaranteed Factory Fresh. The shelf life on Energizer batteries is 5 to 10 years. These batteries are commonly required for Swatch, Fossil, Timex and Casio popular brands...

100 AG13 LR44 L1154 357 A76 BATTERY 100 AG13 LR44 L1154 357 A76 BATTERY
Sale Price: $6.14

10 Packs of 10 Batteries. Replaces: AG13, A76, 357, LR44, SR44

Energizer 395 / 399 Silver Oxide 5 Batteries (SR927W / SR927SW) Energizer 395 / 399 Silver Oxide 5 Batteries (SR927W / SR927SW)
Sale Price: $4.69

Energizer 395 / 399 Silver Oxide 5 Batteries (SR927W / SR927SW)

In the commercial world it is often more advantageous to split your Microsoft Excel data onto multiple worksheets rather than packing all of the data onto one single Microsoft Excel worksheet. Consequently, if you are going to split your data across multiple excel worksheets you will need to be able to reference that data. The name given to those references are called 3-D References.

The way you write the 3-D Reference is as follows:

WorksheetName!CellAddress

You can include 3-D References in your formulas by simply typing the reference into the cell or by selecting each cell in each worksheet as you create the formula. It is also possible to have the 3D-Reference created for you without actually typing the value in. The first step is to type the equals sign in the cell where you want the 3-D Reference to go and then simply click on the worksheet where the cell is you want to use and then select the cell. You will now notice in the Entry area the cells 3-D Reference.

It is also possible to refer to a range of cells using a 3-D Reference on multiple worksheets or for multiple cells.

For example you may want to reference the same cell on three different worksheets. To do this all you would actually do is simply type in the name of the worksheet, then press the colon key and then type the name of the last worksheet. All worksheets between the first and last worksheet would be included in the reference. Below is a 3-D reference to three worksheets and a single cell address.

Sales:Purchases!G6

You can also create a 3-D Reference for a range of cells. You do this by simply by typing the first cell and then a colon with the last cell in the range. Below is an example of a 3D Reference with a range.

Sales!G1:H4

There are many different reasons why you will use 3-D References in Microsoft Excel but the most common one will be to add up values from multiple worksheets and it is important to know how to structure the reference correctly.

If you would like to learn Microsoft Excel in detail simply goto our website Microsoft Excel Training. We also have cheatsheets to help you learn your shortcuts at Excel Shortcuts.

Sedona Training Associates - The Sedona Method
 

Leave a Comment