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_arrowA) 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_arrowquestion_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_arrowquestion_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_arrowquestion_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_arrowA) done clear
B) done clear
C) done clear
D) done clear
View Solution play_arrowquestion_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_arrowquestion_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_arrowquestion_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_arrowA) $ done clear
B) # done clear
C) % done clear
D) & done clear
View Solution play_arrow=AVERAGE(MARKS, 60) |
A) 30 done clear
B) 22.5 done clear
C) 60 done clear
D) 15 done clear
View Solution play_arrowquestion_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_arrowquestion_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_arrowA | 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_arrowA) #DIV/0! done clear
B) #N/0 done clear
C) #NAME? done clear
D) #NULL! done clear
View Solution play_arrowColumn - 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_arrowA) Wrap Text done clear
B) Transpose done clear
C) Swap done clear
D) Sort done clear
View Solution play_arrowA) =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_arrowA) 45 done clear
B) 23 done clear
C) Good done clear
D) Bad done clear
View Solution play_arrowColumn - I | Column - II | ||
(i) | + + | (a) | Enters the current time into the active cell. |
(ii) | + + | (b) | Copies the value from the cell above the active cell into the cell |
(iii) | + + | (c) | Displays the Insert dialog box |
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_arrowYou need to login to perform this action.
You will be redirected in
3 sec