Skip to main content

Microsoft Office Excel 2021

 Microsoft Office Excel 2021

 

How To Open M S Office Excel??

·         Click To Start Button

·         All Programs

·         Microsoft Office

·         Click To M S Office Excel 2021

Window + R (Run Command) -> We Can Type -> Excel

Use Of M S Office Excel??

·         All The Type Formulas

·         All Types Mathematics Works

·         Table Creations

·         School & Collage Mark Sheet

·         Chart

·         Lookup Formulas

·         Use Of Filter

·         Etc….

 

Insert A New Worksheet - (Shift + 11)

Ctrl + Page Up , Ctrl + Page Down (Move To One Sheet To Another Sheet)

M S Office Excel extension : .xlsx



2021

 

2003

columns

16384

( A to XFD)

256

rows

1048576

(1 to 1048576)

65536

cells

17179869184

16777216


Excel Bars :-

1) Title Bar

·         Minimize ( Window + D)

·         Maximize ( Window + D) , (Alt + Tab) , ( Alt +Spacebar + X)

·         Close ( Alt + F4)

2) Menu Bar

·         Home Menu

·         Insert Menu

·         Page Layout Menu

·         Formulas Menu

·         Data Menu

·         Review Menu

·         View Menu

3) Formulas Bar

·         Fx (Insert Function)

4) Status Bar/ Status Line

·         Sheets Layout, Zooming Sliders

5) Scrolling Bar

·         Vertical Scrolling Bar

·         Horizontal Scrolling Bar

6) Task Bar

·         Left Side Start Button

·         Right Side Clock

Ctrl + + ( Insert New Column , Row)

Ctrl + - (Delete Any Column, Row)

 

Labels:

Comments

Post a Comment

Popular posts from this blog

SAP MM (Materials Management)

  SAP Materials Management (SAP MM)- Organizational structure/ Company structure What is a MM? Materials management is  the process of planning and controlling material flows . It includes planning and procuring materials, supplier evaluation and selection, purchasing, expenditure, shipping, receipt processes for materials (including quality control), warehousing and inventory, and materials distribution. Ø    How to Start SAP server? /POWER ON (Ctrl +B) Ø    How to POWER OFF (Ctrl + E) SAP Server? Ø    How to Suspend SAP Server? (Ctrl + J) ü    ECC 6.0 Latest version of SAP server ü    ECC (Enterprise Central Components) ü    SPRO (SAP Project Reference Object) ü    IMG (Implementation Guide) ü    Ctrl + Alt + Enter (Full Screen) ü    Going back to SAP EASY ACCESS screen . /N (forward slash & N) in command window . Transactions Code (T- code) Go to Additional Information -> Additi...
Post a Comment
Read more

TALLYPRIME GST ADVANCE || SYLLABUS

TALLYPRIME GST ADVANCE  ü   Volume -1  (Journal Entries, Provisions Entry, Prepaid Entries, & Other Adjustment Entries) ü   Volume -2  (Purchase & Sales Invoices || Purchase Return & Sales Return) ü   Bank Payment  ü   Bank Receipt ü   Cost Centers ü   Interest Calculations ü   Use separate Actual & Billed Qty columns in invoice ü   CGST, SGST  & IGST ü   Multiple Price List ü   Purchase & Sales Voucher class ü   Bank Reconciliations (BRS)   ü   Volume -3   Purchase and Sales Manufacturing ü   Godown Creations ü   Internal Stock Transfer ü   Cost Centers ü   Use Pre-defined Cost Center Allocations during Entry ü   Manufacturing Journal ü   Stock Journal with Class ü   Purchase Order ü   Receipt Note ü   Rejections Out ü   Sales Order ü   Delivery Note ü   Rejection In ü   Multy Currency ü   Price List...
Post a Comment
Read more

TallyPrime GST Exam Paper

   TallyPrime (GST) Q-1) Pass the following Journal Entries for the month of April-2021.                  1 Ashok Traders Started Fast Track Agency by bringing in cash of Rs.700000 2 Ashok Traders opened a bank account with ICICI bank, Vadodara for the firm by depositing cash of Rs.200000 3 Ashok Traders rented an office space for Rs.3000 per month on April 01-2021. He paid security deposit of Rs.45000 by cheq. 4 Ashok Traders issued cheq. And purchased the following fixed assets. 1.        Cell Phone for office usage for Rs.18000 2.        Furniture for Rs.75000 3.        An Air conditioner for Rs.55000 4.        Electrical fittings for Rs.22000 5 Ashok traders withdrew Rs.15500 cash for personal use. 6 Ashok traders paid Rs.2500 in cash towards office maintenance charges for Apr...
Post a Comment
Read more