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
CCC English Questions Practice Sets Book.pdf
28.4 MB
CCC English Questions Answer Practice Sets Book MCQ 400
CCC Hindi Questions Practice Sets Book.pdf
32.8 MB
CCC Hindi Questions Answer Practice Sets Book MQC 400
As per the shortcuts shared earlier, which combination of keys you can use to open new Excel Workbook when you are working on existing Excel Workbook?
Anonymous Quiz
21%
Ctrl + M
11%
Ctrl + A
58%
Ctrl + N
10%
Ctrl + W
Computer Notes pinned «As per the shortcuts shared earlier, which combination of keys you can use to open new Excel Workbook when you are working on existing Excel Workbook?»
Question:- What is Row and Column?
Answer:- MS Excel is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.
Answer:- MS Excel is in tabular format consisting of rows and columns. Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.
👍1
Question:- What is Cell in Excel?
Answer:- 1. A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. In the following example, a highlighted cell is shown. D8 (column D, row 8) is the highlighted cell that's also known as the cell address and cell reference. Any modifications made while this cell is highlighted will be limited to this cell in the spreadsheet.
Answer:- 1. A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. In the following example, a highlighted cell is shown. D8 (column D, row 8) is the highlighted cell that's also known as the cell address and cell reference. Any modifications made while this cell is highlighted will be limited to this cell in the spreadsheet.