Computer Notes
Computer Basics and Advance Videos Toturial & PDF Books for Beginners. Please add your friends and relatives.
Computer Basics and Advance Videos Toturial & PDF Books for Beginners. Please add your friends and relatives.
Join this channel right now for get best computer skills....
Ms Word, Excel, Power point, and Tally ERP9 with GST
Ms Word, Excel, Power point, and Tally ERP9 with GST
Dear Friends,
In this group will try to learn the basics of MS Word, MS Excel and PowerPoint one by one. Than as will increase subscriber we will start.
Thank you 👍
In this group will try to learn the basics of MS Word, MS Excel and PowerPoint one by one. Than as will increase subscriber we will start.
Thank you 👍
Some shortcut keys of MS Excel
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Q:- What is MS Excel?
A:- MS Excel is spreadsheet tool which help us to work in different cells and that is beneficial for different type of calculations and table presentation.
A:- MS Excel is spreadsheet tool which help us to work in different cells and that is beneficial for different type of calculations and table presentation.
Some shortcut keys of MS Excel
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional
Dear Friends
Please do share this chennal with others so that they can also get the benefits.
Please do share this chennal with others so that they can also get the benefits.
🔴*IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIVES:*🔴
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Question:- Difference between Workbook and Worksheet
Answer:- The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook).
Answer:- The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook).
Question:- What is Function in Excel.
Answer:- A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Answer:- A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Question:- What is Formula Bar?
Answer:- The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
Answer:- The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
CCC Questions Practice Sets Book with Answer
🔴 Language English and Hindi
🔴 Language English and Hindi