10th Class Computers Science Microsoft Excel Question Bank

done MS-Excel 2010 Total Questions - 20

• question_answer1)
  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_answer2)
  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_answer3)
   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_answer4)
  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)
  Copy the selected cell, and then select the other cells. Then click  on the Home tab done clear
  C)
  Click on in the Home tab.  Then click the desired cell you want to copy the formatting to done clear
  D)
  Press  key to select the desired cells. Then click on copy command of Home tab done clear
  View Solution play_arrow

• question_answer5)
  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_answer6)
  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_answer7)
  Which of the following options will prevent invalid data from being entered into the cell?
  A)
                done clear
  B)
           done clear
  C)
                     done clear
  D)
                       done clear
  View Solution play_arrow

• question_answer8)
  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_answer9)
  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_answer10)

  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_answer11)
  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_answer12)

  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_answer13)
  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_answer14)

  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_answer15)
  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_answer16)
  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_answer17)
  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)
     done clear
  B)
                       done clear
  C)
                           done clear
  D)
    done clear
  View Solution play_arrow

• question_answer18)
  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_answer19)
  ______ is used to combine values from multiple ranges into one new range.
  A)
                       done clear
  B)
    done clear
  C)
                       done clear
  D)
  done clear
  View Solution play_arrow

• question_answer20)
  __________ 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