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
Which view in Excel displays the pages exactly as they appear when printed?
Anonymous Quiz
18%
Custom View
26%
Full screen view
18%
Page break view
38%
Page layout view
In the formula, which symbol specifies the fixed columns or rows?
Anonymous Quiz
25%
*
43%
$
23%
#
9%
&
Which function in Excel tells how many numeric entries are there ?
Anonymous Quiz
30%
NUM
50%
COUNT
13%
SUM
7%
CHKNUM
The ____ feature of MS Excel quickly completes a series of data?
Anonymous Quiz
23%
Auto Complete
62%
Auto fill
8%
Fill handle
7%
Sorting
Hi Folks,
Hope you all are doing well!
Please try to answer the below question:-
Question:- What is the use of IFERROR function in MS Excel?
Thank You
Hope you all are doing well!
Please try to answer the below question:-
Question:- What is the use of IFERROR function in MS Excel?
Thank You
Hi Folks,
You all tried very well and have given different replies.
Expecting more to come.
Thanks
You all tried very well and have given different replies.
Expecting more to come.
Thanks
IFERROR
▶️ Iferror is a function that provides alternate results like blank or text when there is an error in the function.
I hope you all are aligned with this.
Thank You
▶️ Iferror is a function that provides alternate results like blank or text when there is an error in the function.
I hope you all are aligned with this.
Thank You
Hi Folks,
Hope you all are doing well and enjoyed the last question !
Please try to answer the question below:-
Question:- What is the use of a UNIQUE function in MS Excel?
Thank You
Hope you all are doing well and enjoyed the last question !
Please try to answer the question below:-
Question:- What is the use of a UNIQUE function in MS Excel?
Thank You