*IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIFE:*
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.
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤔🤔▶️This will help in a situation where you want to copy or cut the cell in which a formula has used and want to take this to some other cells/ Location without formula so that if you change anything the rest of values should not change. Please use below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
Forwarded from M.S. Office, Excel, PowerPoint, Word
Step 1: - Use Copy or Cut command on the Cell or range of cells by using below shortcut keys: -
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.
Ctrl + C: - Copy
Ctrl + X: - Cut
Step 2: - Use any of below Shortcut key to show “Paste Special” window on screen: -
Ctrl + Alt + V
Alt + E + S
Step 3: - Select “Values” option and Press “OK”, other options should not be changed.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: -
https://youtu.be/evO57MP8pBc
https://youtu.be/evO57MP8pBc
YouTube
Use of “Values” option in Paste Special Command
Use of “Values” option in Paste Special Command
Free Excel Videos, Power point, MS Word, Excel, Microsoft Excel Videos Free.
"Values" option in "Paste Special" Excel Free leaning online, Paste special commands one by one free,
Excel Free Videos, Basic Excel…
Free Excel Videos, Power point, MS Word, Excel, Microsoft Excel Videos Free.
"Values" option in "Paste Special" Excel Free leaning online, Paste special commands one by one free,
Excel Free Videos, Basic Excel…
What is the use of Merge in MS Excel?
Anonymous Quiz
79%
Combine two or more cells.
12%
Combine one cell.
5%
Find one cell.
4%
Remove two cells.
*Answer:- Combine two or more cells.*
▶️Merging will help you to merge / combine two or more cells into one cell to create headings and present the data.
▶️Merging will help you to merge / combine two or more cells into one cell to create headings and present the data.
M.S. Office, Excel, PowerPoint, Word
🎥🎥For Video trial please click on below link: - https://youtu.be/evO57MP8pBc
Dear Friends,
Please do like and subscribe to this channel and will soon start posting new videos.
Thank You
Please do like and subscribe to this channel and will soon start posting new videos.
Thank You
MS Excel is a ________.?
Anonymous Quiz
29%
Database Management software
5%
Presentation software
19%
Workbook software
47%
Spreadsheet software
MS Excel 2019 has row limit of __________?
Anonymous Quiz
59%
1048576
23%
4810576
12%
16384
6%
157648
The __ feature of ms excel quickly completes a series of data.
Anonymous Quiz
17%
Auto Filter
18%
Auto Complete
55%
Auto Fill
10%
Auto Sum
What is Auto Fill ?
Please share in your words do not copy paste.
Please share in your words do not copy paste.
I am getting very interesting answers from everyone.
Still looking for others answers.
Still looking for others answers.
Thank you everyone for their wonderful answers, well tried!
Hi Friends
✳️Autofill
🟡Autofill in Microsoft Excel is a feature to fill cells with data that follows a pattern or are based on data in the last cells.
You can use this in two ways:-
🔸1. Ctrl+E: Put 1 in cell B1 and 2 in cell B2 and come to cell B3 then press Ctrl +E, you will get the desired results according to the criteria followed in previous cells.
🔹2. Square drag:- When you select a particular series of data like 1 in cell A1 and 2 in cell A2, then you will see a small square at the bottom-right corner, which you can drag and you will get the desired results according to the criteria followed in previous cells.
✳️Autofill
🟡Autofill in Microsoft Excel is a feature to fill cells with data that follows a pattern or are based on data in the last cells.
You can use this in two ways:-
🔸1. Ctrl+E: Put 1 in cell B1 and 2 in cell B2 and come to cell B3 then press Ctrl +E, you will get the desired results according to the criteria followed in previous cells.
🔹2. Square drag:- When you select a particular series of data like 1 in cell A1 and 2 in cell A2, then you will see a small square at the bottom-right corner, which you can drag and you will get the desired results according to the criteria followed in previous cells.
Which function is used to count the number of cells that contain numbers, in a range?
Anonymous Quiz
46%
Count()
35%
Countif()
14%
Sum()
5%
Sumif()
Which function in Excel is used to find the biggest value in a range?
Anonymous Quiz
10%
Ceiling
20%
DMAX
9%
LEN
62%
MAX