question_answer 1)
In the function, = SUBSTITUTE ("Mathematics", "Ma", "Ve", 1), what does the number 1 indicate?
A)
Reference to the cell containing text. done
clear
B)
Instance number of new text to be replaced. done
clear
C)
Instance number of old text to be replaced. done
clear
D)
None of these done
clear
View Solution play_arrow
question_answer 2)
Which of the following functions is NOT found when you click on the drop-down arrow of AutoSum option?
A)
Average done
clear
B)
Product done
clear
C)
Count Numbers done
clear
D)
Max done
clear
View Solution play_arrow
question_answer 3)
is used to __________.
A)
Merge and center selected cells done
clear
B)
Copy and align the cell content done
clear
C)
Adjust cell width to fit content done
clear
D)
Paste special content in a cell done
clear
View Solution play_arrow
question_answer 4)
A quick way to copy formatting from a selected cell to other cell on the same worksheet is _________.
A)
Press
key and select all the desired cells, then click
on the Home tab
done
clear
B)
C)
D)
View Solution play_arrow
question_answer 5)
To see the results of many different possible inputs at the same time, you should go to______.
A)
What-lf Analysis \[\to \]Data Table done
clear
B)
Data Validation done
clear
C)
Consolidate done
clear
D)
Remove Duplicates done
clear
View Solution play_arrow
question_answer 6)
When you enter =SUM(A1:Z1) in B2, it ___________.
A)
Shows an error message done
clear
B)
Inserts the sum of the contents of cells A1 and Z1 in B2 done
clear
C)
Replaces the contents of first column elements from A1 to Z1 after adding each element with the content of B2 done
clear
D)
Inserts the sum of all first column cells A1 through Z1 in B2 done
clear
View Solution play_arrow
question_answer 7)
Which of the following options will prevent invalid data from being entered into the cell?
A)
B)
C)
D)
View Solution play_arrow
question_answer 8)
Asha was entering data into a worksheet and in the cell A3 she entered the formula = A1+A2+A3. What would be the result after pressing the Enter key?
A)
Sum of A1, A2 and A3 done
clear
B)
Name Error done
clear
C)
#### done
clear
D)
Circular Reference Warning done
clear
View Solution play_arrow
question_answer 9)
Which of the following formulas will NOT return the age of a person whose date of birth is entered into cell A1?
A)
=INT(YEARFRAC(TODAY(), A1)) done
clear
B)
=INT(YEARFRAC(TODAY(), A1, 2)) done
clear
C)
=INT(YEARFRAC(NOW(), A1, 2)) done
clear
D)
=INT(YEARFRAC(DAY(), A1, 1)) done
clear
View Solution play_arrow
question_answer 10)
What happens when the following formula is applied to a cell? =A1 + MarchFigures!A2
A)
The value of the cell A1 in the current worksheet is added to the cell A2 in the worksheet named Sheet2. done
clear
B)
The sum of values of the cell A1 in current worksheet and cell A2 in the worksheet named March Figures is calculated and the result is updated in the current worksheet. done
clear
C)
The value of the cell A2 in the worksheet named March Figures is added to the cell A1 in the current worksheet and the result is updated in March Figures. done
clear
D)
This is an invalid operation. done
clear
View Solution play_arrow
question_answer 11)
Which of the following is NOT a 'Math & Trig' function?
A)
AGGREGATE done
clear
B)
DOLLAR done
clear
C)
CEILING done
clear
D)
COMBIN done
clear
View Solution play_arrow
question_answer 12)
Which of the following statements is CORRECT regarding given formula? =DATEDIF(A1, TODAY(), "y"), assume that cell A1 contains birth date of the person 'X'.
A)
It calculates age of the person 'X'. done
clear
B)
It returns the year from date. done
clear
C)
It returns the number of months between two dates. done
clear
D)
All of these done
clear
View Solution play_arrow
question_answer 13)
Why should you select this button?
A)
To update the content that is coming from other sources. done
clear
B)
To get external data from text only. done
clear
C)
To get external data from other sources. done
clear
D)
To get external data from the web only. done
clear
View Solution play_arrow
question_answer 14)
Which of the following options would replace the "?" (question mark), if you want that after pressing the Enter key the selection shall move towards right? File tab \[\to \]Options \[\to \] Advanced\[\to \]? \[\to \] Select Right in Direction list box present under "After pressing Enter, move selection" option
A)
Editing options done
clear
B)
Proofing options done
clear
C)
Display done
clear
D)
Formulas done
clear
View Solution play_arrow
question_answer 15)
Which of the following is NOT a type of a sparkline?
A)
Line done
clear
B)
Column done
clear
C)
Win/Loss done
clear
D)
3D charts done
clear
View Solution play_arrow
question_answer 16)
Which of the following statements hold(s) true about the given dialog box?
Statement 1: The "Set cell" must contain the formula.
Statement 2: Only one cell value can be supplied in "By changing cell" field.
A)
Only Statement 1 done
clear
B)
Only Statement 2 done
clear
C)
Both Statement 1 and Statement 2 done
clear
D)
Neither Statement 1 nor Statement 2 done
clear
View Solution play_arrow
question_answer 17)
You are working on a sheet in which you want to look values of some cells that are at the far right of sheet. You have to scroll again and again to check values of those cells. Which of the following options provide a method that lets you inspect values of such cells in a separate window?
A)
B)
C)
D)
View Solution play_arrow
question_answer 18)
Which of the following statements hold(s) true about the given icon?
Statement 1: When enabled it highlight changes made to an Excel sheet. Statement 2: It also shares the workbook.
A)
Only Statement 1 done
clear
B)
Only Statement 2 done
clear
C)
Both Statement 1 and Statement 2 done
clear
D)
Neither Statement 1 nor Statement 2 done
clear
View Solution play_arrow
question_answer 19)
______ is used to combine values from multiple ranges into one new range.
A)
B)
C)
D)
View Solution play_arrow
question_answer 20)
__________ Feature allows you to filter the data of Pivot Tables interactively.
A)
Groups done
clear
B)
What-lf Analysis done
clear
C)
Slicer done
clear
D)
Sparklines done
clear
View Solution play_arrow