What is the output of the following MS-Excel function?
=FLOOR(34, 5)
=FLOOR(34, 5)
Anonymous Quiz
25%
40
36%
35
32%
30
7%
33
*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.
Some shortcut keys of MS Excel
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Which of the following is NOT a valid MS Excel 2007 formula?
Anonymous Quiz
28%
SUMPRODUCT
18%
SUMIF
14%
SUM
41%
SUMADD
Forwarded from Knowledge Sharing Excel
How cells are named in MS Excel?
Anonymous Quiz
15%
Using rename option.
29%
Using name box.
23%
Simply double click on sheet name.
33%
Simply double click on cell and name it.
In Eccel, Rows are labelled as :-
Anonymous Quiz
26%
A, B, C, etc
40%
1, 2, 3, etc
25%
A1, A2, etc
9%
$A$1, $A$2, etc
Which function will help you to remove the duplicates from the given data in a row or column?
Anonymous Quiz
20%
Dup
23%
Unique
28%
Filter
30%
Removedup
You can set the page border in Excel from :-
Anonymous Quiz
38%
From Border tab in Format Cells dialog box.
33%
From Border tool in Formatting toolbar.
12%
From Line Style tool in Drawing toolbar.
17%
You can not set page border in Excel.
What is the use of Unique function in MS Excel?
Anonymous Quiz
45%
To extract unique values from data.
15%
To extract duplicate values from data.
9%
To extract formatting from data.
31%
All three options are correct.
What is the short cut key to highlight/select the entire column?
Anonymous Quiz
21%
Ctrl + C
24%
Ctrl + Enter
20%
Ctrl + Page Up
34%
Ctrl + Space Bar
Forwarded from M.S. Office, Excel, PowerPoint, Word
Question:-
What is Function in Excel.
Answer:-
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
What is Function in Excel.
Answer:-
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
*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.