How To Use The Excel Basic Functions?

Excel Basic Functions For Beginners and excel definition – Microsoft Excel is a spreadsheet. It is a powerful application that allows users to do calculations, produce tables and graphs effortlessly. These can range from simple formulas easy to complex functions and mathematical models. It has helped an individual to work and manage his time effectively. In order to start working on excel, you need first to open the Excel workbook on your desktop. You open your excel workbook either by double-clicking on this icon.

Office Excel Icon

If you don’t find the icon, you can open the file by going on the start menu, and once you see the excel icon click on the icon using the mouse’s left button.

Start menu

Once you have clicked on the excel icon, an excel workbook opens. Let’s see the difference between an excel workbook and an excel worksheet.

Excel Basic Functions -Excel Workbook

An Excel file is called a workbook.
Initially, each workbook consists of 3 worksheets (you can add and remove worksheets as needed)

Excel Basic Functions – Excel Worksheet

Each worksheet consists of columns and rows that intersect to form boxes called cells in which you enter text and numbers.
The tabs at the bottom of the workbook (labeled Sheet1, Sheet2, and so on) allow you to flip through the worksheets by clicking them with a mouse.
Double-clicking on a tab will allow you to change the name of a worksheet

Let’s understand the details of the excel window

Excel sheet Bar

Here are some important tools Excel For Beginners

Heading	Excel for Dummies – Explanation
Menu Bar	It contains menus that organize familiar commands
Toolbars	A collection of icons displayed in a long bar Each icon represents a common command or task Standard Toolbar Formatting Toolbar
Formula Bar	Contains tools for creating and editing formulas Displays the contents of the active cell The cell’s location/reference address also appears in this bar It consists of the cell name box and the cell editor
Cell Name Box	Displays the name of the active cell(s); otherwise, displays the cell address.
Cell Editor	Displays the content of the active cell; can be changed by typing new information.
Cell	An intersection of row and column where data are entered
Column Headings	Letters across the top of the worksheet, which identifies the columns in the worksheet
Row Headings	Numbers down the side of the worksheet, which identify the rows in the worksheet
Status Bar	Displays information about a selected command
Worksheet Tabs	Individual worksheets in a workbook where data are entered and analyzed
Task Pane	A window within MS Office software that provides commonly used commands

Let’s understand the different basic navigation panes which one can use in Excel For Beginners

To Move	Command
One Cell Up, Down, Left or Right	One cell
Up One Screen	[PAGE UP]
Down One Screen	[PAGE DOWN]
Left One Screen	[ALT] [PAGE UP]
Right One Screen	[ALT] [PAGE DOWN]
To Edge of Worksheet (or the current block of data)	[CTRL] [Relevant Arrow Key]
To a Particular Cell	[F5] then type the reference for the cell required & press Return
To column A in the current row	[HOME]
To cell A1	[CTRL] [HOME]

Moving between the workbook sheets

Each new workbook contains worksheets, named sheets 1 to sheet 3. The sheet name appears on a tab at the bottom of the workbook window
Click on the appropriate tab.
If the sheet required is not in view, use the tab scrolling buttons to display the sheet.
Press CTRL PAGE DOWN to move to the next sheet or CTRL PAGE UP to move to the previous sheet

Sheet Number

Excel Basic Functions – Entering Values:

ENTER – When done entering data; the active cell will be the next cell down
TAB – Enter the text and move to the next cell to the right
Arrow key – Enter the text and move to another cell
ESC – If you made a mistake and you want to cancel your entry or edit
Data can be text or numeric
The text is defined as any combination of numbers and letters.
Numeric entries are limited to numbers.
Numbers can exist as independent values or values derived from formula (calculated values)

Cut, Copy, Paste

In order to cut or copy-paste the data select the cell which you want to cut or copy and go to the home menu and select the option as required.

In order to paste the data select the cell in which you want to paste the data and then go to the home menu and select the paste option.

Here are some Editing the Datapoint for Excel For Beginners

Editing a cell’s data is done by clicking on the cell to modify and type in the new entry.
If the cell to modify has an existing entry, the new entry will replace the old one.
You may append data to an existing cell entry through any of the following:
- Double click on the cell to edit and type in the additional data
- Click on the cell to edit and then click once in the formula bar. Anything you type in the formula bar will be added to the existing cell’s data
- Click on the cell to edit and press F2. Type in the cell directly

You can use different options from the home menu in order to edit the data

Popular Course in this category

All in One Excel VBA Bundle (120+ Courses)120+ Online Courses | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (2,356 ratings)

Course Price

View Course

Toolbar

Excel help

If you are stuck up with any function in excel, you can click on the question mark for excel help. you can press an F1 key from a keyboard for Excel help.

Close bar

Save the file and exit

In order to save the file, you can either use the Save icon, or the save options from the file option then you can exit the excel file. If you exit the file before saving, excel will ask for a confirmation whether you want to exit without saving so you can save your file even at that point in time.

Save

Recommended Articles

Here are some articles that will help you to get more detail about the Excel Basic Functions For Beginners, so just go through the link.

0 Shares

Quiz Result
Total Questions	Correct Answers	Wrong Answers	Percentage