*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.
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.