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
UNIQUE
➡️Unique is a function which helps to remove duplicate and provide only unique values in an array.
I hope you all are aligned with this.
Thank You
➡️Unique is a function which helps to remove duplicate and provide only unique values in an array.
I hope you all are aligned with this.
Thank You
*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.
🤔♦️➡️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.
➡️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 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.
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