Forwarded from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Please like, subscribe and join my YouTube and telegram channel so that I can come up with more videos.
Thank you
https://www.youtube.com/channel/UC6p-X5eXX9Ade-ejCnHzxpA
Forwarded from M.S. Office, Excel, PowerPoint, Word
Dear Friends,
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
I know this function is difficult but If you understand this you will feel comfortable while doing big tasks in routine office work.
If you have any doubt you can ask me.
Please share my Youtube and Telegram channel with your friends and family members so that they can also get the benefit from this.
Thank you
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question: - What is Paste in Excel?
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Answer: - Paste is a feature provided by M.S. Office to Cut or Copy content from one location or document to another location of Document.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Shortcut key to do following functions in Excel.
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Copy: - Ctrl + C
Cut: - Ctrl + X
Paste: - Ctrl + V
Question: - What is “Paste Special in Excel?
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Answer: - “Paste Special” is same as “Paste” which is available in M.S. Office. “Paste Special” will help to copy or cut and paste the content from one location to another location with different formatting.
As options given in below picture which will discuss one by one in coming days: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Hlookup will help you to find the data from which side ?
Anonymous Quiz
40%
Left to Right
24%
Right to Left
29%
Top to Bottom
7%
Bottom to top
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.
Dear Friends,
Please share this chennal with your friends and family members so that they can also learn new things and get benefit.
Please share your valuable suggestions which help us to improve our chennal.
Thanks and regards
Please share this chennal with your friends and family members so that they can also learn new things and get benefit.
Please share your valuable suggestions which help us to improve our chennal.
Thanks and regards
*Shortcut Keys*
1. Create a new workbook. Ctrl + N.
2. Open an existing workbook. Ctrl + O.
3. Save a workbook/spreadsheet. Ctrl + S.
4. Close the current workbook. Ctrl + W.
5. Close Excel. Ctrl + F4.
6. Move to the next sheet. Ctrl + PageDown.
7. Move to the previous sheet. Ctrl + PageUp.
1. Create a new workbook. Ctrl + N.
2. Open an existing workbook. Ctrl + O.
3. Save a workbook/spreadsheet. Ctrl + S.
4. Close the current workbook. Ctrl + W.
5. Close Excel. Ctrl + F4.
6. Move to the next sheet. Ctrl + PageDown.
7. Move to the previous sheet. Ctrl + PageUp.
What is the address of the cell in the seventh column of the sixth row in an MS-Excel worksheet?
Anonymous Quiz
20%
F6
27%
G7
22%
F7
30%
G6
What is the address of the cell in the tenth row of the fifth column in an MS-Excel worksheet?
Anonymous Quiz
8%
5J
51%
E10
20%
J5
22%
10E
Which sentence is false for Microsoft Excel?
Anonymous Quiz
7%
A cell can contain numbers.
10%
A cell can contain text.
15%
A cell can contain formula.
67%
A cell cannot contain combination of number, textual and formula.
Which of the following is not a valid function in MS Excel?
Anonymous Quiz
11%
SUM()
9%
COUNT()
35%
COUNTA()
45%
SUBTRACT ()
What will be the value of the following excel formula?
=SUM(8/4/2, 4-2, 8-4/2)
=SUM(8/4/2, 4-2, 8-4/2)
Anonymous Quiz
18%
10
34%
8
29%
12
19%
9
What is the value of the following MS-Excel function?
=FLOOR(14, 4)
=FLOOR(14, 4)
Anonymous Quiz
34%
10
14%
13
26%
14
26%
12
Let's say the contents of cells A1, A2, B1 and B2 are 0, 0, a, and 0 respectively. What will be the output of the following Microsoft Excel formula?
= COUNT (A1 : B2)
= COUNT (A1 : B2)
Anonymous Quiz
24%
4
21%
1
42%
0
13%
3
Forwarded from Knowledge Sharing Excel
If cells A1 and A2 are empty, what will be the value of the following Excel formula?
=A1*A2
=A1*A2
Anonymous Quiz
13%
1
20%
Name? error
39%
0
27%
Value? error
What is the output of the following MS-Excel function?
=FLOOR(34, 5)
=FLOOR(34, 5)
Anonymous Quiz
25%
40
36%
35
32%
30
7%
33
*Shortcut Keys*
1. Create a new workbook. Ctrl + N.
2. Open an existing workbook. Ctrl + O.
3. Save a workbook/spreadsheet. Ctrl + S.
4. Close the current workbook. Ctrl + W.
5. Close Excel. Ctrl + F4.
6. Move to the next sheet. Ctrl + PageDown.
7. Move to the previous sheet. Ctrl + PageUp.
1. Create a new workbook. Ctrl + N.
2. Open an existing workbook. Ctrl + O.
3. Save a workbook/spreadsheet. Ctrl + S.
4. Close the current workbook. Ctrl + W.
5. Close Excel. Ctrl + F4.
6. Move to the next sheet. Ctrl + PageDown.
7. Move to the previous sheet. Ctrl + PageUp.