-
question_answer1)
Current date and time in a cell can be entered using the formula __________.
A)
=TODAY () done
clear
B)
=NOW () done
clear
C)
=TIME () done
clear
D)
=CURRENTTIME () done
clear
View Solution play_arrow
-
question_answer2)
is________.
A)
The AutoCorrect button done
clear
B)
The AutoFormat button done
clear
C)
The AutoSum button done
clear
D)
The Conditional Format button done
clear
View Solution play_arrow
-
question_answer3)
The error value #NULL! appears in a cell because _______.
A)
The formula is trying to multiply a value done
clear
B)
The formula refers to a cell that is not valid done
clear
C)
The formula uses an intersection of two ranges that do not intersect done
clear
D)
The formula is trying to divide by zero done
clear
View Solution play_arrow
-
question_answer4)
Which of the following is NOT a valid function?
A)
COUNTIF done
clear
B)
SUMIF done
clear
C)
COUNTA done
clear
D)
COUNTUP done
clear
View Solution play_arrow
-
question_answer5)
A '$' sign in a cell reference like in $A$1 means that ______.
A)
The cell reference is relative done
clear
B)
The cell is formatted to dollars done
clear
C)
The cell reference is absolute done
clear
D)
The cell reference is invalid done
clear
View Solution play_arrow
-
question_answer6)
Which of the following options will allow you to create the name for the selected cell range?
A)
B)
C)
D)
View Solution play_arrow
-
question_answer7)
The first step while creating a formula for a cell is to ________.
A)
Select the cell you want to place the formula into done
clear
B)
Type the equals sign (\[\div \]) to tell Excel that you're about to enter a formula done
clear
C)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula done
clear
D)
Choose the new command from the file tab done
clear
View Solution play_arrow
-
question_answer8)
What will be the output of =SUM(A1: A99)?
A)
The sum of cells A1 through A100 done
clear
B)
The sum of cells A1 through A99 done
clear
C)
The sum of cells A1 through A98 done
clear
D)
It is an invalid function done
clear
View Solution play_arrow
-
question_answer9)
__________ is NOT a function in MS-Excel.
A)
SUM done
clear
B)
ADD done
clear
C)
MAX done
clear
D)
SQRT done
clear
View Solution play_arrow
-
question_answer10)
For absolute cell referencing, always place a ________ sign within the cell addresses in the formula.
A)
$ done
clear
B)
# done
clear
C)
% done
clear
D)
& done
clear
View Solution play_arrow
-
question_answer11)
If a range A1:A5 named MARKS contains numbers 5, 10, 15, 20 and 25 respectively, then what would be the result of the following function?
A)
30 done
clear
B)
22.5 done
clear
C)
60 done
clear
D)
15 done
clear
View Solution play_arrow
-
question_answer12)
Which of the following is CORRECT with respect to MS-Excel?
A)
SORT function is used to find the square root of a number. done
clear
B)
A formula always begins with a + (plus) sign. done
clear
C)
Mixed referencing can be used only when both row and column are fixed. done
clear
D)
The formula given in one sheet of a workbook can be linked to other worksheet. done
clear
View Solution play_arrow
-
question_answer13)
If you do not put an equal to (=) before a formula, _______.
A)
###### is displayed in the cell done
clear
B)
#REF! is displayed in the cell done
clear
C)
The formula is displayed as it is in the cell done
clear
D)
The formula is still executed and its results are displayed in the cell done
clear
View Solution play_arrow
-
question_answer14)
Which of the following should be used to find the minimum score among different subjects?
|
A |
B |
C |
D |
E |
F |
G |
1 |
Subject |
Mathematics |
Physics |
Chemistry |
Biology |
Computer |
|
2 |
Marks |
44 |
32 |
48 |
47 |
45 |
|
3 |
|
|
|
|
|
|
|
A)
=MIN(B2:F2) done
clear
B)
=MIN(B2,F2) done
clear
C)
=MIN(B1:F1) done
clear
D)
=MIN(B1,F1) done
clear
View Solution play_arrow
-
question_answer15)
You entered =C9/0 in a cell, instead of =C9/10. Which of the following error values will be displayed in the cell?
A)
#DIV/0! done
clear
B)
#N/0 done
clear
C)
#NAME? done
clear
D)
#NULL! done
clear
View Solution play_arrow
-
question_answer16)
Match the following MS-Excel functions given in Column-1 with their uses in Column - II
Column - I |
Column - II |
(i) |
AVERAGE(range) |
(a) |
Returns the number rounded to the nearest odd integer. |
(ii) |
ODD(number) |
(b) |
Current date is displayed in the cell. |
(iii) |
MOD(number1, number2 |
(c) |
Rounds the number1 to the digits specified in number2. |
(iv) |
ROUND(number1,number2) |
(d) |
Returns the remainder when number1 is divided by the number2. |
(v) |
TODAY( ) |
(e) |
Finds the average of the given range of numbers. |
A)
(i) - (e), (ii) - (a), (iii) - (c), (iv) - (d), (v) - (b) done
clear
B)
(i) - (a), (ii) - (e), (iii) - (c), (iv) - (d), (v) - (b) done
clear
C)
(i) - (a), (ii) - (e), (iii) - (d), (iv) - (c), (v) - (b) done
clear
D)
(i) - (e), (ii) - (a), (iii) - (d), (iv) - (c), (v) - (b) done
clear
View Solution play_arrow
-
question_answer17)
Which of the following Paste operations will switch the rows and columns from TABLE 1 into TABLE 2?
A)
Wrap Text done
clear
B)
Transpose done
clear
C)
Swap done
clear
D)
Sort done
clear
View Solution play_arrow
-
question_answer18)
What is the most appropriate formula you can put in the cell B2 to calculate 9% tax for the given data?
A)
=A2*0.09 done
clear
B)
=A2*0.09% done
clear
C)
=A2*1.09 done
clear
D)
= A2+(A2*0.09) done
clear
View Solution play_arrow
-
question_answer19)
What would be displayed in a cell, if it contains the following formula? =IF(AND(23 < 4, 45 = 15), "Good", "Bad")
A)
45 done
clear
B)
23 done
clear
C)
Good done
clear
D)
Bad done
clear
View Solution play_arrow
-
question_answer20)
A)
(i) - (c), (ii) - (b), (iii) - (a) done
clear
B)
(i) - (a), (ii) - (c), (iii) - (b) done
clear
C)
(i) - (b), (ii) - (c), (iii) - (a) done
clear
D)
(i) - (a), (ii) - (b), (iii) - (c) done
clear
View Solution play_arrow