Yes
No
None of the above
Goal Seek can be used conditionally to solve scenarios based on multiple constraints
Goal Seek can be used conditionally to solve scenarios based on single constraints
Goal Seek is not an excel command
Iterations must be enabled in order to use Goal Seek
=Vlookup(A1,$A$1:$B$12,"First Name",0)
=Vlookup(A1:A101, $A$1:$B$12,2,0)
=Vlookup(A1, $A$1:$B$12,1,0)
None of the above
There is no feature in excel to solve this problem
This problem can be easily solved by converting your data into a list/ table range
The chart will get auto updated with the new records, if the data is refreshed
Column chart does not support new records to be added however, other chart types do
This statement is true, but the protection only works if the workbook is protected too
This statement is true, but the protection only works if the sheet is protected too
This statement is true however, read only mode must be activated for those cells undergoing protection
The above statement is false and this is not possible in excel
List
Array
Range Product
Matrix
Nothing
User name
IP address
Worksheet name
F8
F12
F11
Ctrl + Shift + A
As a shortcut to run Macro
Copy the formula from a cell in editing mode to the range of cells selected
To go back to the last edited cell
Select the current region
March 2, 2002
February 3, 2002
August 13, 1987
June 30, 1990
Data cannot be copied across workbooks, if it contains a formula
Will give the sum of data present in cells A2:A5 of book book2, sheet2
Will give the sum of data present in cells A2:A5 of book book1, sheet2
Will result in an error
The cell will appear like ";;;".
The cell's contents will appear in bold.
The cell's contents will appear in italics.
The cell's contents will be hidden.
Shows the address of the active cell
Can be used to navigate to any cell and convert it to an active cell
Can be used to give names to cells and corresponding ranges as applicable
All of the above
=Small(A5:A1:C1:C5,3)
=Small(A1:A5,C1)
=Small((A1:A5,C1:C5),3)
All of the above
You will copy the entire data, go to ‘paste special’ and paste as value. Workbook will now not calculate anything since there are no formulae in the workbook
Tools à Options à Calculation à Manual
You will go to Formulas à Evaluate formula in the formula auditing Group. This will help you to evaluate the formula step by step
Excel does not have the option to work with huge workbooks.