Genuine Earn Money Online Without Investment

1. Websites That Pay

Here are some legitimate websites that pay:

1. Swagbucks – Swagbucks is great for earning some extra cash. You can do a variety of things to make money, from taking surveys to using their search engine. You won’t get rich, but you will earn a few bucks. If you have the time to kill, you can spend it earning some extra cash, instead of surfing the web.
2. InboxDollars – InboxDollars is similar to Swagbucks, since you’re going to be taking surveys, shopping, etc., so if you want to maximize your return, sign up with both websites. They also offer a search engine that pays you (like Swagbucks) and you get $5 just for signing up.  I won’t continue to list survey sites one after another down the list, but if you want to get paid to take surveys, also check out GlobalTestMarket, E-Poll Surveys and Survey Club.
3. Project Payday – Project Payday is one of those sites that has testimonials of people who have earned thousands of dollars by getting paid to get trial offers. I’m not saying you’ll earn thousands, but it is legit and you can earn some extra cash. They assume that by paying you to do a free trial, you’ll either like the product and purchase it, or forget to cancel the trial and get charged for it. If you can keep track and cancel before you get charged (if you don’t want the product), then this is a great site for making some money.
4. User Testing – User Testing pays $10 a pop for testing websites. A test usually takes about 15-20 minutes. The purpose is for a website owner to watch someone, who is new to their site, try to navigate it. The value that the site owner gets by watching an actual user experience is worth a ton, but $10 isn’t a bad pay-out.
5. Fiverr – Fiverr is a great place to make a few bucks or spend a few bucks if you need some of the services people offer. Basically, everything is $5. You either pay $5 or charge $5. They call them “gigs.” You can offer your services however you choose. If you sell art and you’re fine selling pieces for $5 each, that’s a gig. If you’re a graphic designer and you want to offer your services for $10/hour, simply offer a 30 minute gig. If they need two hours of graphic design, they pay you $20, or $10/hour by buying four gigs.
6. IZEA – IZEA works in addition to a blog or on its own. You get paid to blog, tweet, take photos and take videos. The pay is mostly based on your following, so if you want to make money with your tweets, you’ll need to grow you Twitter following.  Likewise, if you want to make money with blogs, you’ll need substantial blog traffic (more on blogging below).

2. Freelance Writing

Freelance writing is one of the most popular ways to earn money online.

1.      Listverse – Listverse pays $100 for each accepted post. The article must be a list, it must be at least 1,500 words and you must include at least 10 things. Other than that, you can get pretty creative with it.

2. TopTenz – TopTenz pays $50 for each accepted post. Again, the article has to be in a list format and it must be at least 1,500 words, with few exceptions. They post often so your chances of getting accepted are fairly high.
3. A List Apart – A List Apart pays $200 for each accepted post. They’re not first on the list, because they tend to publish less articles, which means you have a smaller chance of getting accepted. Same guidelines as above, 1,500 word minimum.
4. International Living – International Living pays $75 for each accepted post. They are mostly looking for travel experiences from countries you have visited. For this site, it’s more about your experience than your writing ability.
5. FundsforWriters – FundsforWriters pays $50 for each accepted post. They are looking for articles about writing and making money with it. They only accept articles between 500-600 words, but they want you to make each word count.
6. Uxbooth – Uxbooth pays $100 for each accepted post. They do tend to take four to eight weeks to accept and post articles, so don’t count on this being a quick money maker. They take so long, because they pair with editors to only publish amazing content.
7. iWriter – iWriter pays up to $15 for each accepted post. That may seem small, but they aren’t as strict as many of the others above and they also allow you to pick exactly what you write. You can write as many or as few articles as you want.
8. Textbroker – Textbroker pays up to five cents per word, if you’re a 5-star writer. You’ll start by submitting a short sample article and you will most likely start as a 3-star writer, but you can work your way up by writing more and writing great content.
9. Matador Network – Matador Network pays up to $60 for each accepted post, but standard pay is around $20-$25. They don’t really focus on a minimum word count, but they have a maximum count of 1,500 words.
10. The Penny Hoarder – The Penny Hoarder pays up to $800 (rarely), depending upon the number of page views you receive. The pay starts at $100 for 50,000 page views, so this isn’t a guaranteed paid article, but it can potentially be highly rewarding.

3. Sell Your Stuff

Ever since the idea of online auctions came into existence, the online selling market has been on the rise. Many are interested, but don’t know how to get started. There are still all kinds of ways to make money by selling online, whether you’re selling what you already have or buying and selling like a store. Before we get started, here are a few general tips when selling anything online:

• Get a PayPal account. If you don’t have a PayPal account, you’ll want to get one if you’re doing business online. It’s the standard in online business for receiving payment and paying others.
• Take good pictures. Some of the options below don’t require you to actually take the picture and sell the product, but for the ones that do, make sure you take a clear picture that makes your product stand out from the others.  If you’re going to be taking a lot of pictures, set up a small “studio-like” area in your home with a backdrop and proper lighting to really make your pictures come across as professional. And of course, you’ll want a good camera too.
• Be honest.  If you’re selling used items, be honest about every dent, scratch, blemish, etc.. This will reduce many issues you could run into and keep your reviews positive.
• Do good business. Plain and simple. Whether you’re selling on a small site or opening an online store, your customer service matters. You’ll want to get those positive reviews and make a good name for yourself. Respond to questions, concerns and complaints. Offer a guarantee if available.

Follow those guidelines and you will do well in online sales. When you’re ready to start selling, here’s where you go:

1. Amazon – Have you heard of FBA? It stands for “Fulfilled by Amazon” and it’s getting pretty popular. Basically, you buy products (in bulk is best) and ship them to Amazon for them to store. When your products sell, Amazon packs them up, ships them out and sends you the money (after taking their cut). There are people making a full-time living from FBA, while others just do it for some extra money.
2. CraigsList – Some things don’t ship very well. Other things may make you feel uncomfortable to sell to someone across the country. Anytime you’re selling a large item or something you just don’t want to ship, Craigslist is a great place to go. It’s simple to list your item (again, take good pictures!). If you don’t like the idea of putting your phone number out there, the interested individual can send you a message to your inbox without even getting your email address.
3. eBay – Of course you can’t read an article about making money online that doesn’t mention eBay. You can start an eBay store and get serious about it or you can just sell some stuff to declutter your home. Either way, I’ve made my fair share from selling on eBay and it’s still a popular way to earn money. If you decide to start an actual eBay store, you’ll want to find a drop-ship business like Doba that will store and ship items straight to your customers so you don’t have to deal with an inventory.
4. Etsy – If you like to create arts and crafts, you can sell them on Etsy.It’s completely free to open an Etsy store. You simply sign up, post pictures of your creations and starting selling. You can choose your payment option, but PayPal is generally the easiest. Etsy makes it easy to sell and keep track of your inventory. There is a small listing fee and they take 3.5% of every sale you make.
5. Facebook – Facebook swap shops are great for selling things locally. It’s like CraigsList, but a little easier. You simply search for swap shops in your area and ask to join the group. Once you’re in, take a picture of the item, write a quick description with the price and post it. It doesn’t get much easier than that. You can generally expect to get about what you would get at a yard sale, maybe a little more.

4. Blogging

1. Advertising – This is definitely the most old-school way of earning money with a blog. It’s also starting to become the least common way. You can sell advertising spots directly on your site or you can sign up with a company like Google AdSense or Media.net. Either way, you won’t see a whole lot of money from ads until your views are well into the thousands each day.
2. Affiliates – There are many affiliate networks, such as FlexOffers and CJ Affiliate that allow you to promote other people’s products and services. You simply put a link or a banner on your page and then you get a percentage if someone clicks through and buys the product/service. You’ll want to select products that are specifically within your blog’s category.This is an effective way to earn money once you have the traffic coming to your blog.
3. Membership – Many people have created a paid membership area on their blog. This is typically for exclusive content that you can only access in the “member’s area.” If you have a really great idea on what to include, this can be a great idea.  You’ll have to create something that can’t easily be accessed around the web.
4. Products – You can create your own product, such as an ebook or computer software. You would then use your blog as a promotion tool to get people to buy your product. As long as you create a legitimate product with a whole lot of value, you should be able to get some buyers, but like everything else with a blog, you’ll need the traffic to get the sells.
5. Services – You can offer a paid service, such as life coaching, blog coaching, goal setting or financial planning. Just be sure to investigate all the legal implications and make sure you’re not claiming to be a professional if you’re not one. With a service like this, you’re basically using your blog to sell yourself. You’ll need to convince people that you’re worth buying and then be able to back up your claims once they purchase your service.
6. Sponsored/paid posts – Many blogs publish sponsored and paid posts. Sponsored posts are basically just posts about a specific brand, product or service. A company will pay you to publish an article about it. It’s similar with other paid posts as well. Your basically selling the spot for the article on your site. If you decide to take this route, you’ll want to build your traffic before you will get many offers.
7. Subscription – If you think of something valuable (newsletter, online magazine, etc.) that you can consistently offer on a certain basis (weekly, monthly, etc.), you may want to offer a subscription service. This could be a fee charged each time your product is sent out or on a monthly basis. Either way, this has to be something that your customers can only get by subscribing to your website.
8. Videos – This could be an entire section on it’s own. Many people have made money by creating YouTube videos. Evan of EvanTube is a kid and he has made millions by creating reviews of products that other kids his age would use. It’s not easy to get views into the millions, but once you do, you’ll start seeing some cash come in. Many bloggers have completely turned to videos to get their point across by starting a video blog.

If you’re truly interested in becoming a blogger, start by looking through the archives of ProBlogger, Copyblogger and Boost Blog Traffic. Then go read through all the free guides over at Quick Sprout. It may take you a year to complete those tasks alone, but it will be worth it. You’ll practically have a MBA in blogging.

5. Work-at-Home Companies

1. CrowdSource – CrowdSource offers many types of jobs from “microtask” jobs to larger writing and editing jobs. You decide how much you work and you can do most of it right at your computer.
2. Demand Studios – Demand Studios is hiring all kinds of creative professionals, from writer to filmmakers. The pay isn’t amazing, but it’s competitive for a work-at-home job.
3. Fast Chart – Fast Chart allows you to work from home as a medical transcriptionist. There are some requirments and qualifications listed on the page, but if you meet them, you’ll make competitive pay for the industry. You’ll also be able to set your own schedule since you’ll be working from home.
4. Leap Force – Leap Force is one way that Google rates websites for search engine ranking. If you’re hired, you make decent money (usually over $11/hour), you set your own schedule and it can be pretty fun to view and rank websites.
5. Liveops – Liveops is a call center that allows you to work from home. Once your set up to take the calls, you can begin making a weekly schedule and working from home. The pay is generally close to $10/hour, but you can earn more with commissions.
6. SpeakWrite – SpeakWrite will pay you up to $15/hour to transcribe information. You set your own schedule and work from home.

Chapter-4 (Spreadsheet Tool)

Question: Write Introduction to Spreadsheets?

Answer: A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets.

Question: Write Concept of Worksheets and Workbooks?

Answer: In Microsoft Excel, a workbook is simply an Excel file that stores entered related data. Workbooks are capable of holding an almost infinite number of worksheets, depending on the size and the relevance of the data. It is, essentially, a book filled with the data from multiple worksheets. Workbooks are usually labeled by the data which is on each worksheet – if all the pages of the workbook hold the same type of data, that workbook will be named for the relevant data that it holds.

In Excel, a worksheet is an amalgamation of a number of cells that hold data pertaining to a certain piece of information. It is also known as a spreadsheet. A user is able to enter, modify, and manipulate the data that is entered in the spreadsheet. With a spreadsheet, a user is essentially entering information onto a page of a workbook.

Question: How to Creating and saving a worksheet?

Answer:

 

Starting EXCEL

By selecting the Start button located at the bottom left hand side of your screen, then selecting Programs then

Microsoft Excel.  

SAVING WORKBOOKS

Go to File> Save/ Save As, and Excel will display the Save As dialog box.

Question: How to Use the Fill Handle and Fill Button to Autofill Numbers and Dates?

Answer:

 

Autofill a Growth Series (Geometric Pattern)

Specifying growth series in newer versions of Excel is easy. The fastest way is to enter the first two numbers and then right-click on the Fill Handle.

1. In the Excel worksheet, enter 1 in the first cell and 2 in the cell immediately below.
2. Highlight the two cells, and hover the cursor over the Fill Handle (+).
3. Press the RIGHT mouse button, drag down the column, and release. Click Growth Trend.
4. Because you entered two numbers, Excel knows that the step value is 2. The autofill results are shown.

 

 Autofilling Dates (Days, Weekdays, Months, and Years)

 

1. Type the beginning date in the cell. For our example, we've entered the first day of the year. Right-click on the Fill Handle and drag down the column.
2. When the mouse button is released, a menu displays as shown in the first image. We select Months in our example.
3. Excel autofills the column with the first day of each consecutive month as shown.

Question: How to Editing and formatting a worksheet including changing colour, size, font and alignment of text?

 

Answer:

 

Change the default font or font size for new workbooks

 

1. Click the Microsoft Office Button, and then click Excel Options.
2. In the Popular category, under When creating new workbooks, do the following:
1. In the Use this font box, click the font that you want to use.
2. In the Font Size box, enter the font size that you want to use.

Changing the alignment or orientation of data

For the optimal display of the data on your worksheet, you may want to reposition the text within a cell. You can change the alignment of the cell contents, use indentation for better spacing, or display the data at a different angle by rotating it.

Question: How to inserting or deleting cells, rows and columns in ms-excel?

Answer:

Insert blank cells on a worksheet

1. Select the cell or the range of cells where you want to insert the new blank cells. Select the same number of cells as you want to insert. For example, to insert five blank cells, select five cells.
2. On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Cells.
3. In the Insert dialog box, click the direction in which you want to shift the surrounding cells.

Insert rows on a worksheet

1. To insert a single row, select either the whole row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5.
2. On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Rows.

Insert columns on a worksheet

1. To insert a single column, select the column or a cell in the column immediately to the right of where you want to insert the new column. For example, to insert a new column to the left of column B, click a cell in column B.
2. On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert Sheet Columns.

Delete cells, rows, or columns

1. Select the cells, rows, or columns that you want to delete.

On the Home tab, in the Cells group, click the arrow next to Delete, and then do one of the following:

·         To delete selected cells, click Delete Cells.

·         To delete selected rows, click Delete Sheet Rows.

·         To delete selected columns, click Delete Sheet Columns.

2.      If you are deleting a cell or a range of cells, in the Delete dialog box, click Shift cells left, Shift cells up, Entire row, or Entire column.

Question: How to insert Formula- Entering a formula in a cell in ms-excel?

Answer:

Create a simple formula by using constants and calculation operators

1. Click the cell in which you want to enter the formula.
2. Type = (equal sign).
3. To enter the formula, do one of the following:
• Type the constants and operators that you want to use in the calculation.

Example formula	What it does
=5+2	Adds 5 and 2
=5-2	Subtracts 2 from 5
=5/2	Divides 5 by 2
=5*2	Multiplies 5 times 2
=5^2	Raises 5 to the 2nd power

• Click the cell that contains the value that you want to use in the formula, type the operator that you want to use, and then click another cell that contains a value.

Example formula	What it does
=A1+A2	Adds the values in cells A1 and A2
=A1-A2	Subtracts the value in cell A2 from the value in A1
=A1/A2	Divides the value in cell A1 by the value in A2
=A1*A2	Multiplies the value in cell A1 times the value in A2
=A1^A2	Raises the value in cell A1 to the exponential value specified in A2

1. Press ENTER.
2. You can enter as many constants and operators as you need to achieve the calculation result that you want.
3. Excel follows the standard order of mathematical operations. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result – the multiplication operation (2*3) is performed first, and then 5 is added to its result.

Question: Describe between Switch between relative, absolute and mixed references?

Answer:

Switch between relative, absolute and mixed references

By default, a cell reference is relative. For example, when you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A), and in the same row (2). A formula that contains a relative cell reference changes as you copy it from one cell to another. As an example, if you copy the formula =A2+B2 from cell C2 to D2, the formula in D2 adjusts downward by one row and becomes =A3+B3. If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (A and B) and row (2) with a dollar sign ($). Then, when you copy the formula (=$A$2+$B$2) from C2 to D2, the formula stays exactly the same.

In less frequent cases, you may want to make a cell reference "mixed" by preceding either the column or the row value with a dollar sign to "lock" either the column or the row (for example, $A2 or B$3). To change the type of cell reference:

1.      Select the cell that contains the formula.

2.      In the formula bar, select the reference that you want to change.

3.      Press F4 to switch between the reference types.

Question: How to printing a worksheet in ms-excel?

Answer:

Print several workbooks at once

1. Click Microsoft Office Button, and then click Open. Keyboard shortcut you can also press CTRL+O.
2. Hold down CTRL and click the name of each workbook that you want to print.
3. On a computer that is running Windows Vista. Right-click the selection, and then click Print.

Question: Explain Use simple Statistical functions: SUM(), AVERAGE(), MAX(), MIN(), IF()?

Answer:

In order to have a cell showing the result of a statistical calculation (like the sum or the average of some other cells), we use what is called a “Function”.

We get the function by clicking a button, or by writing a short code composed of few letters.

Here is a description of the functions learned, with the relevant “function code” appearing at the beginning of each paragraph:

SUM – A sum function. Use it when you want a cell to show the sum of numbers written in a selected range of cells.
For example: you took 5 different loans during the past year, and you want to calculate their total sum.

AVERAGE – An average function. Use it when you want a cell to show the average of numbers written in a selected range.
For example: you have made nice income during the past week, and you want to calculate your average income per day.

MAX – The highest number. Use it when you want a cell to show the highest number within a selected range.
For example: you have a list of test scores, and you want a certain cell to show the highest score among them.
Another example: you have a list of sales made during this month, and you want a cell to show the highest sale.

MIN – The lowest number. The same as MAX, but relates to the lowest number.

COUNT – Counts numbers. Use it when you want to count how many numbers are there in a selected range.
For example, you have a list of students, of which some of them got scholarships. Using the COUNT function you can know how many students got scholarships. What you will do is count using this function the cells containing the scholarships amounts.

Another example: you have a big table of products with their prices. Because every product has only one price, counting the prices will tell you how many products you have.

COUNTIF – Use Excel Countif function when you want to count how many occurrences of a specific criteria appear in a selected range.
For example: How many times does the name “Jack” appear in a list of worker names?
Another Countif Excel example: How many prices higher than $1000 are there in a given price list?

COUNTA – Counts all the cells in a selected range that contain any value (cells that are not empty). This is a broader version of the COUNT function, because it counts cells containing numbers, as well as texts.
For example, you have a large amount of data, and you want to count how many items does it consist. These items can be student names, ID numbers, salary payments, addresses, dates etc.

COUNTBLANK – Counts all the empty cells in a selected range. Use it when you want to know how many cells in a selected range do not contain any value.

For example: a few students didn’t hand their homework, therefore didn’t get a score. If you want to know how many students didn’t hand their work, use the COUNTBLANK function on the score list, and see how many cells are empty, meanings: didn’t get a score.

Question: How to Inserting tables in worksheet?

Answer:

 

Insert a table

1.      On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data.

2.      On the Insert tab, in the Tables group, click Table.

Keyboard shortcut  You can also press CTRL+L or CTRL+T.

3.      If the selected range contains data that you want to display as table headers, select the My table has headers check box.

Question: How to insert Embedding Charts of various types: Line, Pie, Scatter, Bar and Area in ms-excel?

Answer:

Create a Chart

• Click the Insert tab.
• Click the chart type from the Charts section of the ribbon. The sub-type menu displays.
• Click the desired chart sub-type. The chart appears on the worksheet.
• If you want to create a second chart, click somewhere in the worksheet to "deselect" the current chart first, or the new chart will replace the current chart.

Type	Description	When to Use
Pie Chart	Displays the percentages of a whole for each member in a series.	Excellent chart for comparing values in a single series as percentages of a whole.
Column Chart	Using vertical columns, displays values for one or more series over time or other category.	This chart type is especially effective in comparing values for multiple series. The 3-D Column chart displays multiple series over three axes (X, Y, and Z).
Bar Chart	Displays values for one or more series using horizontal columns.	Though useful for single or multiple series, this chart type is especially effective in comparing a large quantity of values in a single series.
Line Chart	Displays values as equally spaced points connected with a line.	This chart is especially useful in displaying trends over time or other ordered category for single or multiple series of data.