Forwarded from M.S. Office, Excel, PowerPoint, Word
Hlookup will help you to find the data from which side ?
Anonymous Quiz
40%
Left to Right
24%
Right to Left
29%
Top to Bottom
7%
Bottom to top
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.
Dear Friends,
Please share this chennal with your friends and family members so that they can also learn new things and get benefit.
Please share your valuable suggestions which help us to improve our chennal.
Thanks and regards
Please share this chennal with your friends and family members so that they can also learn new things and get benefit.
Please share your valuable suggestions which help us to improve our chennal.
Thanks and regards
*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.
What is the address of the cell in the seventh column of the sixth row in an MS-Excel worksheet?
Anonymous Quiz
20%
F6
27%
G7
22%
F7
30%
G6
What is the address of the cell in the tenth row of the fifth column in an MS-Excel worksheet?
Anonymous Quiz
8%
5J
51%
E10
20%
J5
22%
10E
Which sentence is false for Microsoft Excel?
Anonymous Quiz
7%
A cell can contain numbers.
10%
A cell can contain text.
15%
A cell can contain formula.
67%
A cell cannot contain combination of number, textual and formula.
Which of the following is not a valid function in MS Excel?
Anonymous Quiz
11%
SUM()
9%
COUNT()
35%
COUNTA()
45%
SUBTRACT ()
What will be the value of the following excel formula?
=SUM(8/4/2, 4-2, 8-4/2)
=SUM(8/4/2, 4-2, 8-4/2)
Anonymous Quiz
18%
10
34%
8
29%
12
19%
9
What is the value of the following MS-Excel function?
=FLOOR(14, 4)
=FLOOR(14, 4)
Anonymous Quiz
34%
10
14%
13
26%
14
26%
12
Let's say the contents of cells A1, A2, B1 and B2 are 0, 0, a, and 0 respectively. What will be the output of the following Microsoft Excel formula?
= COUNT (A1 : B2)
= COUNT (A1 : B2)
Anonymous Quiz
24%
4
21%
1
42%
0
13%
3
Forwarded from Knowledge Sharing Excel
If cells A1 and A2 are empty, what will be the value of the following Excel formula?
=A1*A2
=A1*A2
Anonymous Quiz
13%
1
20%
Name? error
39%
0
27%
Value? error
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.