Microsoft Excel Introduction

Microsoft Excel Introduction

Microsoft Excel -

Microsoft Excel is a spreadsheet that is developed by Microsoft. It is available for windows, macOS, Android and iOS. It is used for the data visualization and mainly to store, organize the data.

In Excel Sheet, We have rows and columns. Rows are denoted with digits that is 1,2...etc and Columns are denoted with A,B,C....etc.

Cell - one box in spreadsheet that is row + column, ex: A1,A2 are cells

In Excel we have menu as follows,

-> File

->Home

->Insert

->Page Layout

->Formulas

->Data

->Review

->View

->Help

Main Topics of Microsoft Excel are -

1. Formulas
2. Functions
3. Pivot Tables
4. Excel Shortcuts
5. Excel Charts

Main Functions of Microsoft Excel are -

SUM function
TEXT function
VLOOKUP function
AVERAGE function
CONCATEMNATE function

Shortcut keys:

To move one cell to another cell

* From top to down - ENTER

* From down to top - SHIFT + ENTER

* From Left to right - TAB

* From Right to Left - SHIFT + TAB

If you have any doubt, Please comment below

Comments

JNTUK R16 percentage calculation

JNTUK R16 PERCENTAGE CALCULATION Here R16 batch students can calculate percentage according to obtained CGPA throughout the graduation. JNTUK introduced SGPA, CGPA in 2020 batch that is R16 REGULATION. Most of the companies ask percentage but students suffer how much percentage equal to obtained CGPA. for that here providing a wonderful platform for calculation of percentage by providing CGPA. ENETR CGPA BELOW BOX AND GET PERCENTAGE: ENTER CGPA Percentage For Lateral Entry students CGPA Calculator- click here for Regular students CGPA Calculator - click here Andhra Pradesh SI and Constable recruitment Notification 2022 Details - Click here for more details feel free to comment ...

JNTUK Convocation VIII for 2018-19 and 2019-20 batch OD apply

JNTUK Convocation VIII for 2018-19 and 2019-20 batch, who have taken the PC in the period of 01/01/2019 to 31/12/2020 For more details Click here last Date to apply - 18-12-2021 Required Documents: 1. PC 2. CMM (For UG ) 3. SSC 4. Recent Photo 5. For PG courses - Sem wise mark sheets 6. Adhaar front and back scanned copy 7. Bank challan or Payment - Those made offline payment should submit hard copies of above documents at the university examination Fee - Rs.2000/- Process to apply: 1. Register with Hall ticket number and email Id(user name) - Click here 2. Login with user name(E-mail ID) and password - click here 3. Enter the details and next step will be payment Note: Updation of payment status into complete status may take 2-3 days 4. Then need to attach the required documents 5. Next step is to check the details and everything and then click on check box by agreeing that there information was furnished by you is true. 6. There will be no Submit option that is only downlo...

JNTUK R16 SGPA and CGPA calculator for Lateral entry b.tech

Lateral entry students those are joined directly engineering by completing polytechnic, they may or may not appeared for ECET for getting seat in engineering course. that is B.Tech students studied course in 4 years but lateral entry students studied course is 3 years, that one year spend in polytechnic course. Lateral entry students strong in Technically than regular students. for SGPA calculator - click here NOTE: IF ANYONE WANT CALCULATE UPTO SOME SEMISTERS(LIKE UPTO 3-2) FOR PLACEMENTS CAN PROVIDE REMAINING SGPAS AND TOTAL CREDITS AS ZEROS(0) THEN WILL GET ACCURATE CGPA TILL THAT PARTICULAR SEMISTER. FOR LATERAL ENTRY SCHEME B.TECH CGPA IS... FIRST SEMISTER SGPA total credits SECOND SEMISTER SGPA total credits THIRD SEMISTER SGPA total credits FOURTH SEMISTER SGPA total credits FIFTH S...

Search This Blog

Welcome to Daily Updates

* Happy Learning*