Computer Tutorials for Beginners

Hi interesting readers, Prathysha NGO, Chennai. Bala gurukul orphange, chennai. Pratyusha support, Hyderbad. Krr oldage home, Vizag. Disa foundation.......................................................... so on..................... Join hands with us for a good cause. Thank you all. Contact  us on our  whatsapp no:  8939374254    for the more details. You can pay through Paytm scanner. for each donor we will give an online PDF book as a gift. Thank you Pratyusha Home

Combining Arithmetic Operators in Excel  - The basic operators you've just met can be combined to make more complex calculations. For example, you can add to cells together, and multiply by a third one. Like this: = A1 + A2 * A3 Or this: = A1 + A2 - A3 And even this: =SUM(A1:A9) * B1 In the above formula, we're asking Excel to add up the numbers in the cells A1 to A9, and then multiply the answer by B1. You'll get some practise with combining the operators shortly. But there's something you need to be aware of called Operator Precedence. Operator Precedence Some of the operators you have just met are calculated before others. This is known as Operator Precedence. As an example, try this: Open a new Excel spreadsheet In cell A1 enter 25 In cell A2 enter 50 In cell A3 enter 2 Now click in cell A5 and enter the following formula: =(A1 + A2) * A3 Hit the enter key on your keyboard, and you'll see an answer of 150. The thing to pay atten...

Microsoft Excel 2007 to 2016 - Excel Rows and Columns  - Spreadsheets are displayed in a grid layout. The letters across the top are Column headings. To highlight an entire Column, click on any of the letters. The image below shows the B Column highlighted: If you look down the left side of the grid, you'll see numbers, which start at number 1 at the very top and go down to over a million. (The exact number of rows and columns are 1,048,576 rows and 16,384 columns. You've never going to need this many!) You can click a number to highlight an entire Row. If you look at the image below, you'll see that Row 5 has been highlighted The image above is from Excel 2007. Later are version are the same except less colourful. The one below is from Excel 2016: Spreadsheets are all about individual Cells. A Cell is a letter combined with a number. So if you combine the B column with Row 5, you get Cell B5. Combine Column D with Row 5 and you get Cell D5. To see this ...

Widen an Excel Column -To widen a column, do the following: Move your mouse pointer up to the letter A The pointer will be in the shape of a white cross, as in the next image Now move your mouse pointer, the white cross, to the line in between the A and the B The mouse pointer will change shape again The mouse pointer will be in the shape of a black cross with arrowheads, like the one in the image below: When you mouse pointer changes shape, hold down your left mouse button Keep it held down and drag your mouse to the right Let go of the mouse button when your are satisfied with the width of your colum Widening an Excel Column The Result You can widen a row in exactly the same way. We'll now see how to centre those numbers in their cells, and format that text a little. Formatting cells Centring text in a cell comes under the heading of Formatting. Things like making the text bold, changing the font, and adding some colour al...