question_answer 1)
Presence of dollar sign (\[\$\]) before a row and column number, in a cell range for example, \[\$C\$7:\$D\$10\] indicates that ___________.
A)
An absolute cell reference is created done
clear
B)
Cell address will change when it is copied to another cell done
clear
C)
The sheet tab is changed done
clear
D)
The status bar does not display the cell address done
clear
View Solution play_arrow
question_answer 2)
Which of the following options will allow you to force the user to choose the value of a selected cell from the specified dropdown list in MS-Excel 2010?
A)
Data Validation done
clear
B)
Consolidate done
clear
C)
What-lf Analysis done
clear
D)
Subtotal done
clear
View Solution play_arrow
question_answer 3)
To do What-lf-Analysis, which of the following Data Tools can you use?
A)
Data Table done
clear
B)
Goal Seek done
clear
C)
Scenario Manager done
clear
D)
All of these done
clear
View Solution play_arrow
question_answer 4)
What is Watch Window?
A)
A separate window that remains visible to monitor the values of certain cells. done
clear
B)
A resizable window that displays a list of all formulas used in a sheet. done
clear
C)
A separate workbook that gets displayed when certain conditions are met. done
clear
D)
A window that displays all the formula errors. done
clear
View Solution play_arrow
question_answer 5)
A)
Trace Dependents done
clear
B)
Trace Precedents done
clear
C)
Show Formulas done
clear
D)
Calculate Result done
clear
View Solution play_arrow
question_answer 6)
_______ Option allows you to view multiple distant parts of your worksheet at once.
A)
Zoom to Selection done
clear
B)
Page Layout View done
clear
C)
Split done
clear
D)
Zoom In done
clear
View Solution play_arrow
question_answer 7)
Which of the following options would replace the "?" to open the Watch Window? Formulas tab\[\to \] ? \[\to \] Watch Window
A)
Calculations done
clear
B)
Function done
clear
C)
Formula Auditing done
clear
D)
Data Tools done
clear
View Solution play_arrow
question_answer 8)
Which of the following options allows you to debug a formula by executing each part of the formula individually?
A)
Evaluate Formula done
clear
B)
Examine Formula done
clear
C)
Auditing Formula done
clear
D)
Checking Formula done
clear
View Solution play_arrow
question_answer 9)
Which of the following statements hold(s) true about 'Protect Sheet' feature? Statement 1: It can be used to protect the entire workbook by providing password. Statement 2: It can be used to protect the worksheet from unwanted changes.
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 10)
is used to ______ .
A)
Insert a signature line to specify the person who must sign done
clear
B)
View the document in the full screen mode done
clear
C)
Edit the layout of the document done
clear
D)
Save a set of display and print settings done
clear
View Solution play_arrow
question_answer 11)
Which of the following statements is INCORRECT about 'Share Workbook' feature?
A)
It allows multiple people to work in a workbook at the same time. done
clear
B)
It requires workbook to be saved to a network location. done
clear
C)
Workbook that contains tables can be shared. done
clear
D)
Both [A] and [B] done
clear
View Solution play_arrow
question_answer 12)
What is the use of COUNTA function in MS-Excel 2010?
A)
It returns the number of blank cells in a range. done
clear
B)
It returns the number of blank cells on the entire worksheet. done
clear
C)
It returns the number of non-blank cells in a range. done
clear
D)
It returns the correlation between two data. done
clear
View Solution play_arrow
question_answer 13)
A)
(a) - (iv), (b) - (iii), (c) - (ii), (d) - (i) done
clear
B)
(a) - (ii), (b) - (iii), (c) - (iv), (d) - (i) done
clear
C)
(a) - (ii), (b) - (iii), (c) - (i), (d) - (iv) done
clear
D)
(a) - (ii), (b) - (i), (c) - (iv), (d) - (iii) done
clear
View Solution play_arrow
question_answer 14)
Which of the following statements hold(s) true about the given icon?
Statement 1: It is used to total several rows of related data together. Statement 2: The name of shown command button is sum data.
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 15)
What is the use of
icon?
A)
It is used to trace errors done
clear
B)
It is used to remove arrows drawn by Trace Precedents. done
clear
C)
It is used to remove arrows drawn by Trace Dependents done
clear
D)
Both [B] and [C] done
clear
View Solution play_arrow
question_answer 16)
Reema wants to display formulas in cells instead of the resulting value. Which of the following steps will help her to do so?
A)
B)
File tab \[\to \] Options \[\to \] Advanced \[\to \]select 'Show formulas in cells instead of their calculated results' checkbox under Display options for this worksheet' section \[\to \] OK done
clear
C)
View tab \[\to \] Display group \[\to \]select 'Show Formulas' check box done
clear
D)
Both [A] and [B] done
clear
View Solution play_arrow
question_answer 17)
Which MS-Excel tool will you use to combine values from multiple ranges into one new range?
A)
B)
C)
D)
View Solution play_arrow
question_answer 18)
Which of the following key combination is used to ungroup a range of cells?
A)
B)
C)
D)
View Solution play_arrow
question_answer 19)
Rishab wants to add a condition to selected range of cells, such that when a user enters a value less than 0, it should display a message stating that only positive numbers can be entered. Which of the following can be used for this purpose?
A)
Consolidate done
clear
B)
Data Validation done
clear
C)
Data Restriction done
clear
D)
What-lf Analysis done
clear
View Solution play_arrow
question_answer 20)
An organization sells its products in three regions and the quarterly sales from each region is stored in three identical worksheets. Now, the sales team want to know the total sales of each product by adding sales from all regions. Which MS-Excel tool should be used for this purpose?
A)
Goal Seek done
clear
B)
Consolidate done
clear
C)
Watch Window done
clear
D)
Subtotal done
clear
View Solution play_arrow