7th Class Computers Science Microsoft Excel Question Bank

done Introduction to MS-Excel 2010 Total Questions - 25

• question_answer1)
  A row and column arrangement of data and the formulas to manipulate it is called a _____.
  A)
  Spreadsheet done clear
  B)
      Tablesheet done clear
  C)
  Gridsheet      done clear
  D)
  Rolesheet done clear
  View Solution play_arrow

• question_answer2)
  Observe the given image and answer the questions that follow.

  Cell marked as A is called _________ cell.

  A)
  Active          done clear
  B)
  Passive done clear
  C)
  Marquee            done clear
  D)
  Formula done clear
  View Solution play_arrow

• question_answer3)
  Observe the given image and answer the questions that follow.

  Match the following.
  Column - I	Column - II
  (a)	(i) Sheet tab scroll buttons
  (b)	(ii) Name Box
  (c)	(iii) Insert Worksheet
  (d)	(iv) Expand Formula Bar

   
  A)
  (a) - (ii), (b) - (iii), (c) - (iv), (d) - (i) done clear
  B)
  (a) - (iii), (b) - (ii), (c) - (iv), (d) - (i) done clear
  C)
  (a) - (iv), (b) - (i), (c) - (ii), (d) - (iii) done clear
  D)
  (a) - (iii), (b) - (iv), (c) - (i), (d) - (ii) done clear
  View Solution play_arrow

• question_answer4)
  The arrows indicated by 'A' in the given image are called __________.   
  A)
  Filter switches done clear
  B)
  Data switches done clear
  C)
  Form switches done clear
  D)
  None of these done clear
  View Solution play_arrow

• question_answer5)
  Which of the following options when clicked after selecting cell A1 in Fig.1 will display the data as shown in Fig. 2?        
  A)
         done clear
  B)
    done clear
  C)
          done clear
  D)
    done clear
  View Solution play_arrow

• question_answer6)
  To format only those cells that rank in the top 10 items in a selected data range, use ______ option.
  A)
  done clear
  B)
  done clear
  C)
         done clear
  D)
     done clear
  View Solution play_arrow

• question_answer7)
  What should be typed in a cell to select all cells in row 5?
  A)
  = A11(5) done clear
  B)
  = cell(5) done clear
  C)
  =5 done clear
  D)
  =5:5 done clear
  View Solution play_arrow

• question_answer8)
  Which of the following icons is used to format a cell using pre-defined styles?
  A)
      done clear
  B)
    done clear
  C)
     done clear
  D)
    done clear
  View Solution play_arrow

• question_answer9)
  To select the entire row containing the current cell, press __________.
  A)
    + done clear
  B)
    done clear
  C)
    + done clear
  D)
    + done clear
  View Solution play_arrow

• question_answer10)
  Which of the following is a valid cell range?
  A)
  A1 ; C4             done clear
  B)
  A1-C4 done clear
  C)
  A1:C4         done clear
  D)
  C4;A1 done clear
  View Solution play_arrow

• question_answer11)
  You can enable filtering of the selected cells by _______.
  A)
  Home tab \[\to \] Filter group \[\to \] Click on 'Filter' done clear
  B)
  Home tab \[\to \]Editing group \[\to \] Click 'Sort & Filter' \[\to \]Filter done clear
  C)
  Press  +  + done clear
  D)
  Both [B] and [C] done clear
  View Solution play_arrow

• question_answer12)
  Which of the following options when clicked will convert the data as shown in Image-1 into the data, as shown in Image-2?   
  A)
          done clear
  B)
  done clear
  C)
                      done clear
  D)
    done clear
  View Solution play_arrow

• question_answer13)
  Match the different Merge options given in Column-I with their corresponding names given in Column-II.

  Column -I	Column - II
  (a)	(i) Merge & Center
  (b)	(ii) Unmerge Cells
  (c)	(iii) Merge Cells
  (d)	(iv) Merge Across

   
  A)
  (a) - (i), (b) - (ii), (c) - (iii), (d) - (iv) done clear
  B)
  (a) - (ii), (b) - (iii), (c) - (iv), (d) - (i) done clear
  C)
  (a) - (iv), (b) - (i), (c) - (ii), (d) - (iii) done clear
  D)
  (a) - (iii), (b) - (iv), (c) - (i), (d) - (ii) done clear
  View Solution play_arrow

• question_answer14)
  Identify the function of the given icon.
  A)
  It is used for adding up and down arrows. done clear
  B)
  It is used to rotate text diagonally or vertically. done clear
  C)
  It is used for wrapping text by displaying it on multiple lines. done clear
  D)
  It is used for adding text effects to a cell. done clear
  View Solution play_arrow

• question_answer15)
  Ankur has entered the value 1 into cell A1 and 3 into cell A2. Now, he selected both the cells and dragged down the fill handle. What would be the result of this action?
  A)
  It will create a linear series of even numbers. done clear
  B)
  It will create a number series of odd numbers. done clear
  C)
  It will copy the values of selected cells into next cells. done clear
  D)
  It is not possible to drag the fill handle downward. done clear
  View Solution play_arrow

• question_answer16)
  Which of the following keyboard shortcuts when pressed, will select the cell one column to the left of active cell?
  A)
  done clear
  B)
   + done clear
  C)
   + done clear
  D)
  Both [A] and [B] done clear
  View Solution play_arrow

• question_answer17)
  ___________ number format multiplies the cell value by 100 and displays the result with a percent symbol.
  A)
  Currency done clear
  B)
  Fraction done clear
  C)
  Special done clear
  D)
  Percentage done clear
  View Solution play_arrow

• question_answer18)
  If you want to display the leading zero in a numeric entry, like 01234567, how should it be entered in the cell?
  A)
  +01234567 done clear
  B)
  '01234567 done clear
  C)
  ''01234567 done clear
  D)
  (01234567) done clear
  View Solution play_arrow

• question_answer19)
  While entering data in a worksheet, Riya pressed  +  in a cell, what value will be printed in that cell?
  A)
  Current Time done clear
  B)
  Square root of current value in cell done clear
  C)
  Current Date done clear
  D)
  Square of current value in cell done clear
  View Solution play_arrow

• question_answer20)
  You have pasted some text in a cell. To again paste the same text in some other cell you can press the _________ key.
  A)
                done clear
  B)
    done clear
  C)
     done clear
  D)
    done clear
  View Solution play_arrow

• question_answer21)
  Match the MS-Excel shortcut sequences given in Column-I with their description in Column-II.

  Column - I	Column - II
  (a)  +	(i) Applies or removes bold formatting
  (b)  +	(ii) Applies or removes underlining
  (c)  +	(iii) Displays the Format Cells dialog box
  (d)  +	(iv) Applies or removes italic formatting

   
  A)
  (a) - (ii), (b) - (i), (c) - (iv), (d) - (iii) done clear
  B)
  (a) - (ii), (b) - (iii), (c) - (i), (d) - (iv) done clear
  C)
  (a) - (ii), (b) - (iv), (c) - (i), (d) - (iii) done clear
  D)
  (a) - (iii), (b) - (i), (c) - (iv), (d) - (ii) done clear
  View Solution play_arrow

• question_answer22)

  Consider the given expression entered in a cell.

  = 476 + 28 * (100-(10)^2)

  What would be displayed in the cell when you type the given expression and then press the Enter key?

  A)
  #DIV/0!              done clear
  B)
  476 done clear
  C)
  #NAME?       done clear
  D)
  0 done clear
  View Solution play_arrow

• question_answer23)
  Which of the following is the CORRECT description of AutoComplete feature?
  A)
  It will force MS-Excel to display value in multiple lines within the cell. done clear
  B)
  It automatically fills the entry based on other entries that you have already made in a column, when you type the first few letters of the similar text. done clear
  C)
  It inserts a series of values or text items in a range of cells. done clear
  D)
  None of these done clear
  View Solution play_arrow

• question_answer24)
  Which of the following statements hold(s) true about the given command button with respect to Header & Footer tools?   

  Statement 1: It adds the count of total number of pages in a worksheet to the header or footer.

  Statement 2: The count gets automatically updated changes are made in the at product 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_answer25)

  Consider the given data.

  What would be displayed when you select the cells B1 to B3 and then press  +  keys?

  A)
    done clear
  B)
  done clear
  C)
  done clear
  D)
  done clear
  View Solution play_arrow