# Excel 2007 (pre Test)

Changes are done, please start the quiz.

 1 The Name box
 A. Shows the address of the active cell
 B. Can be used to navigate to any cell and convert it to an active cell
 C. Can be used to give names to cells and corresponding ranges as applicable
 D. All of the above
 2 Excel allows users to be able to protect each cell with a different password
 A. This statement is true, but the protection only works if the workbook is protected too
 B. This statement is true, but the protection only works if the sheet is protected too
 C. This statement is true however, read only mode must be activated for those cells undergoing protection
 D. The above statement is false and this is not possible in excel
 3 Control + Enter shortcut is used ....
 A. As a shortcut to run Macro
 B. Copy the formula from a cell in editing mode to the range of cells selected
 C. To go back to the last edited cell
 D. Select the current region
 4 Select the most appropriate amongst the following
 A. Goal Seek can be used conditionally to solve scenarios based on multiple constraints
 B. Goal Seek can be used conditionally to solve scenarios based on single constraints
 C. Goal Seek is not an excel command
 D. Iterations must be enabled in order to use Goal Seek
 5 The formula present in cell D7 of book1, sheet2, is =sum(A2:A5). The same formula is copied to another workbook, book2 and pasted in sheet2, cell C7. Select the most appropriate outcome?
 A. Data cannot be copied across workbooks, if it contains a formula
 B. Will give the sum of data present in cells A2:A5 of book book2, sheet2
 C. Will give the sum of data present in cells A2:A5 of book book1, sheet2
 D. Will result in an error
 6 The number 32002 formatted as a date would be:
 A. March 2, 2002
 B. February 3, 2002
 C. August 13, 1987
 D. June 30, 1990
 7 Which of the following functions are correct syntactically?
 A. =Small(A5:A1:C1:C5,3)
 B. =Small(A1:A5,C1)
 C. =Small((A1:A5,C1:C5),3)
 D. All of the above
 8 Is addition of rows and columns is possible beyond defined limit
 A. Yes
 B. No
 C. None of the above
 9 You open a worksheet, you received in an email with cells D6:D9 containing the formula {=a6:A9*C6:C9}. Which feature of excel can help us design formulae like this
 A. List
 B. Array
 C. Range Product
 D. Matrix
 10 Which amongst the following is ideal methods is ideal to work with a workbook which has the huge data and takes lot of time to do the calculations
 A. 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
 B. Tools à Options à Calculation à Manual
 C. You will go to Formulas à Evaluate formula in the formula auditing Group. This will help you to evaluate the formula step by step
 D. Excel does not have the option to work with huge workbooks.
 11 What is the keyboard short cut for ‘Save-As’?
 A. F8
 B. F12
 C. F11
 D. Ctrl + Shift + A
 12 Which of the following function syntax is correct?
 A. =Vlookup(A1,\$A\$1:\$B\$12,"First Name",0)
 B. =Vlookup(A1:A101, \$A\$1:\$B\$12,2,0)
 C. =Vlookup(A1, \$A\$1:\$B\$12,1,0)
 D. None of the above
 13 Cell formatted as ";;;" will result in
 A. The cell will appear like ";;;".
 B. The cell's contents will appear in bold.
 C. The cell's contents will appear in italics.
 D. The cell's contents will be hidden.
 14 When you first create a comment, what appears in the comment text box?
 A. Nothing
 B. User name
 D. Worksheet name
 15 A column chart is made out of data present in A1:B5. For a new data added in A6 and B6, the chart has to be redesigned to include the new record
 A. There is no feature in excel to solve this problem
 B. This problem can be easily solved by converting your data into a list/ table range
 C. The chart will get auto updated with the new records, if the data is refreshed
 D. Column chart does not support new records to be added however, other chart types do
Take Another Quiz