M.S. Office, Excel, PowerPoint, Word
36K subscribers
143 photos
44 links
Knowledge Sharing
Download Telegram
____ sign is used to create an absolute cell reference.
Anonymous Quiz
61%
$
25%
@
10%
&
5%
%
Typed text visible in active cell and also in which location___?
Anonymous Quiz
60%
Formula bar
15%
Ribbon
20%
Title bar
5%
Scroll bar
🤔♦️➡️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.
➡️Shortcut key to do following functions in Excel.
🟠 Copy: - Ctrl + C
🟡 Cut: - Ctrl + X
🟢 Paste: - Ctrl + V
Dear Friends,
Please do practice and ask your doubts.
Thank You
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
Workbook is a collection of?
Anonymous Quiz
85%
Worksheets
10%
Page set-up
3%
Buttons
2%
Diagrams
Hi Friends,

Due to some personal issue not actively participating.

Will start shortly.

Thank You
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.
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.
____ sign is used to create an absolute cell reference.
Anonymous Quiz
54%
$
28%
@
12%
&
6%
%
*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.
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.
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
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.
»
Question of the day.

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