Basic Excel tasks
Excel is a very effective tool for making sense of massive volumes of data. However, it also performs admirably when used to track virtually any type of information and perform basic calculations. The cell grid holds the key to realizing all of that potential. Formulas, text, and numbers can all be found in cells. Data is entered into cells, which are then arranged in rows and columns. You can then add up your data, sort and filter it, organize it in tables, and create stunning charts. Let's go over the fundamental procedures to get you going.
Make a fresh workbook.
Workbooks are Excel documents. Each workbook contains sheets, sometimes known as spreadsheets. To keep your data organized, you can add as many sheets as you like to a workbook or make new workbooks from scratch.
1. Select a blank cell.
Consider the A1 cell on a fresh sheet. Since cells are identified on a sheet by the row and column in which they are found, cell A1 is in the first row of column A.
2. Enter a number or text in the cell.
3. To advance to the following cell, press Enter or Tab.
Put cell borders in
1. Choose the cell or range of cells to which a border should be added.
2. Select the desired border style by clicking the arrow next to Borders in the Font group on the Home tab.
Put cell shading in.
1. Choose the cell range or individual cells to which you want to apply cell shading.
2. Select the desired colour under Theme Colours or Standard Colours on the Home tab's Font group by clicking the arrow next to Fill Colour.
As you upload your data, use AutoSum.
You might want to include the numbers you've typed in your sheet. Using AutoSum to accomplish that is a quick method.
1. Decide whether cell should be above or below the ones you want to add.
2. Select the Home tab, then select the Editing group, and finally select AutoSum.
Make a basic formula.
Excel can perform various types of math in addition to addition, which is just one of the things it can accomplish. To add, subtract, multiply, or divide your numbers, try some straightforward formulas.
1. Select a cell, then press the equals sign (=).
This instructs Excel that a formula will be present in this cell.
2. Enter a number together with a mathematical operator, such as a plus (+) for addition, a minus (-) for subtraction, an asterisk (*) for multiplication, or a forward slash (/) for division.
Enter =2+4, =4-2, =2*4, or =4/2 as an example.
3. Hit Enter.
Run the computation with this.
If you wish the cursor to remain in the currently selected cell, you may also hit Ctrl+Enter.
0 Comments