Statistical calculations and preparation of tables and graphs can be done using?
Anonymous Quiz
7%
Adobe Photoshop
82%
Excel
4%
Notepad
7%
Powerpoint
The ____ feature of MS Excel quickly completes a series of data?
Anonymous Quiz
23%
Auto Complete
60%
Auto Fill
7%
Fill Handle
10%
Sorting
Hi Friends,
Due to some personal issue not actively participating.
Will start shortly.
Thank You
Due to some personal issue not actively participating.
Will start shortly.
Thank You
What is the use of Format Painter?
Anonymous Quiz
19%
Copy and paste the values.
9%
Cut and paste the values.
63%
Copy and apply the formatting.
9%
Cut and apply the formatting.
M.S. Office, Excel, PowerPoint, Word
What is the use of Format Painter?
To check the reason/ information behind the correct answer, please click on the bulb visible below the question.
M.S. Office, Excel, PowerPoint, Word pinned «What is the use of Format Painter?»
Answer:-
(C) Copy and apply the formatting.
➡️Format Painter will help you to copy the formatting from one location and paste to other location. This is available in clipboard section of Home Ribbon.
(C) Copy and apply the formatting.
➡️Format Painter will help you to copy the formatting from one location and paste to other location. This is available in clipboard section of Home Ribbon.
What is the use of Merge in Excel?
Anonymous Quiz
80%
Combine two or more cells.
12%
Combine one cell.
5%
Find one cell.
3%
Remove two cells.
*Answer:- Combine two or more cells.*
▶️Merging will help you to merge two or more cells in one cell to create headings and present the data.
▶️Merging will help you to merge two or more cells in one cell to create headings and present the data.
Dear Team,
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.
Anonymous Poll
91%
Interested
9%
Not interested
Dear Team,
On the regular demand from the group members, I have decided to start the live class.
Shorty i will be starting paid live sessions for basic Excel students and then advance Excel. The charges will be lying in between Rs 20-50 per session and will give you topic and class wise details before starting it.
If any suggestion is there please write in chat box.
Thank You
On the regular demand from the group members, I have decided to start the live class.
Shorty i will be starting paid live sessions for basic Excel students and then advance Excel. The charges will be lying in between Rs 20-50 per session and will give you topic and class wise details before starting it.
If any suggestion is there please write in chat box.
Thank You
M.S. Office, Excel, PowerPoint, Word pinned «Dear Team,
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.»
On the regular demand from the group members, I have decided to start the live class. Those who are interested please select one option.»
Question of the day.
What is transpose in Excel, where it is exist and how it is working?
Please write your answer in comments.
What is transpose in Excel, where it is exist and how it is working?
Please write your answer in comments.
Answer;-
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Transpose is the function which helps you to convert table from vertical to horizontal and horizontal to vertical form.
It is exist in Paste Special box in Home tab.
Working:-
1. Select the table and copy it.
2. Press shortcut on keyboard Alt+E+S and select transpose from here.
Thank You
Dear All,
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
Thank you for your reply with correct answers.
Looking forward to have more detailed answers with example from your side on the questions which will be provided in the group
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.
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
Forwarded from M.S. Office, Excel, PowerPoint, Word
⭕️⭕️Let us discuss 'Formats' option of paste special command.