Excel 2007 (pre Test)

15 Questions  I  By PradipMCT
Please take the quiz to rate it.

Excel Quizzes & Trivia

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 1. 
    Is addition of rows and columns is possible beyond defined limit
    • A. 

      Yes

    • B. 

      No

    • C. 

      None of the above


  • 2. 
    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


  • 3. 
    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


  • 4. 
    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


  • 5. 
    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


  • 6. 
    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


  • 7. 
    When you first create a comment, what appears in the comment text box?
    • A. 

      Nothing

    • B. 

      User name

    • C. 

      IP address

    • D. 

      Worksheet name


  • 8. 
    What is the keyboard short cut for ‘Save-As’?
    • A. 

      F8

    • B. 

      F12

    • C. 

      F11

    • D. 

      Ctrl + Shift + A


  • 9. 
    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


  • 10. 
    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


  • 11. 
    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


  • 12. 
    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.


  • 13. 
    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


  • 14. 
    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


  • 15. 
    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.


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.