An Excel Workbook is a collection of....
?
?
Anonymous Quiz
10%
Workbooks
80%
Worksheets
4%
Charts
6%
Formulas
M.S. Office, Excel, PowerPoint, Word pinned «An Excel Workbook is a collection of....
?»
?»
What is the intersection of a column and a row in a worksheet called?
Anonymous Quiz
9%
Column
8%
Value
12%
Address
71%
Cell
Question : -
Which function in Excel checks whether a condition is true or not ?
Which function in Excel checks whether a condition is true or not ?
Anonymous Quiz
8%
SUM
12%
COUNT
74%
IF
6%
AVERAGE
Which function in Excel tells how many numeric entries are there ?
Anonymous Quiz
16%
NUM
58%
COUNT
11%
SUM
14%
CHECKNUM
What is the difference between SUMIF and SUMIFS?
Anonymous Quiz
10%
Both are same.
7%
No difference.
16%
SUMIF and SUMIFS are for single condition.
67%
SUMIF is for single condition and SUMIFS for Multiple Condition.
The software which contains rows and columns is called:-
Anonymous Quiz
74%
Spreadsheet
11%
Word
10%
Database
6%
None of th above
Forwarded from M.S. Office, Excel, PowerPoint, Word
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.
Forwarded from M.S. Office, Excel, PowerPoint, Word
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
Forwarded from M.S. Office, Excel, PowerPoint, Word
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
➡️Question: -
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
Shortcut key for “Paste Special”.
➡️Answer: -
Ctrl + Alt + V
Alt + E + S
❗️Note: - This “Paste Special” only works if you have copied or cut some data.
You can use the formula palette to:-
Anonymous Quiz
28%
Format cells containing numbers.
54%
Create and edit formula containing functions.
10%
Enter assumptiond data.
8%
Copy a range of cells.
Forwarded from M.S. Office, Excel, PowerPoint, Word
After having discussion on Vlookup with Exact Match, let us now discuss Vlookup with Approximate Match.
Syntax
= Vlookup (lookup_Value,table_array,col_index,[range_lookup])
Important Note: -
1. ‘V’ stands for Vertical lookup.
2. Only works towards extracting data from the Right side of the table.
Syntax
= Vlookup (lookup_Value,table_array,col_index,[range_lookup])
Important Note: -
1. ‘V’ stands for Vertical lookup.
2. Only works towards extracting data from the Right side of the table.
Forwarded from M.S. Office, Excel, PowerPoint, Word
♦️♦️In the below screenshot you can see one problem is given with Table A and we need to find the Price in Table B. We will solve this problem with the help of ‘Vlookup’ function. Please follow below steps: -
Forwarded from M.S. Office, Excel, PowerPoint, Word
☝️🟢Step 1: - Click on Cell ‘I9’ and press ‘=’ this will activate the cell to use function and start typing ‘Vlookup’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️🟢Step 2: - After Typing ‘Vlookup’ start the function by using any one from below two sub-steps: -
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
(i) Press Start bracket ‘(‘.
OR
(ii) You can press ‘Tab’ button.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟🟣Step 3: - Select ‘Lookup Value in Cell H9’ as given in the syntax.
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
(Lookup Value is the value for which you want to find the result and based on this you can find the result from Table Array).
Forwarded from M.S. Office, Excel, PowerPoint, Word
✌️✌️🟢Step 4: - After selecting ‘Lookup Value in cell H9’, Select ‘Table Array from Cell D9 to E19’ from which you want to find the results of ‘lookup value’.
Forwarded from M.S. Office, Excel, PowerPoint, Word
🤟✌️🟣Step 5: - After selecting Table array please put coma (,) and the third field will reflect ‘Col_Index_Num’ which means from which column you want to find the results, Type number 2 here.
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Discount Percentage based on Sale Value and Discount Percentage is lying in second column that is why we typed 2 here).
(Explanation: - In this problem we have only two columns in which data is exist, and we want to find the Discount Percentage based on Sale Value and Discount Percentage is lying in second column that is why we typed 2 here).