6th Class Computers Science Microsoft Excel Question Bank

done Microsoft Excel Total Questions - 40

• question_answer1)
  What is the basic file of MS Excel?
  A)
   Presentation                done clear
  B)
   Slide   done clear
  C)
        Bit map            done clear
  D)
          Workbook done clear
  View Solution play_arrow

• question_answer2)
  What is the last column of an Excel worksheet?
  A)
   IV                    done clear
  B)
        AV                  done clear
  C)
                    XV                  done clear
  D)
        DV done clear
  View Solution play_arrow

• question_answer3)
  Which component of MS Excel displays the address of the active cell?
  A)
   Formula bar             done clear
  B)
   Name box done clear
  C)
   Row header      done clear
  D)
           Column header done clear
  View Solution play_arrow

• question_answer4)
  What is the function of the button of Excel window marked X called?            
  A)
   It opens the previous worksheet. done clear
  B)
   It opens the last worksheet. done clear
  C)
   It opens the first worksheet. done clear
  D)
   It opens next worksheet. done clear
  View Solution play_arrow

• question_answer5)
  What is the component of MS-Excel window given called?
  A)
   Standard tool bar          done clear
  B)
   Formula bar done clear
  C)
   Title bar            done clear
  D)
         Chart bar done clear
  View Solution play_arrow

• question_answer6)
  Which component of Excel window allows you to type formulae?
  A)
   Name box       done clear
  B)
   Formula bar done clear
  C)
        Title bar            done clear
  D)
        Menu bar done clear
  View Solution play_arrow

• question_answer7)
  How many rows does an MS-Excel worksheet contain?
  A)
   65103                  done clear
  B)
   65123 done clear
  C)
        65536               done clear
  D)
       65725 done clear
  View Solution play_arrow

• question_answer8)
  How many columns does an MS-Excel worksheet contain?
  A)
   256                             done clear
  B)
   126                 done clear
  C)
        156                 done clear
  D)
        580 done clear
  View Solution play_arrow

• question_answer9)
  Which steps would you follow to insert a work sheet in your work book?
  A)
   File  New done clear
  B)
   Insert  Worksheet done clear
  C)
   Data  Insert x Worksheet done clear
  D)
   All of above done clear
  View Solution play_arrow

• question_answer10)
  Which steps would you follow to start MS Excel?
  A)
   Start  Programs  MS Excel done clear
  B)
   Start  Programs \[\to \] Microsoft office \[\to \] MS Excel done clear
  C)
   Click on    MS Excel icon of MS Office shortcut tool bar done clear
  D)
   All of the above done clear
  View Solution play_arrow

• question_answer11)
  What is a workbook?
  A)
   Collection of worksheets   done clear
  B)
   Collection of excel files done clear
  C)
   Collection of cells          done clear
  D)
   Collection of rows & columns done clear
  View Solution play_arrow

• question_answer12)
  In MS Excel a formula should always start with ___ sign.
  A)
   +                                done clear
  B)
   -                      done clear
  C)
        =                    done clear
  D)
        x done clear
  View Solution play_arrow

• question_answer13)
  What is the function of the button marked 'X' in the given picture?            
  A)
   It opens the next worksheet. done clear
  B)
   It opens the last work sheet. done clear
  C)
   Both (a) and (b) done clear
  D)
   It opens the previous worksheet.                          done clear
  View Solution play_arrow

• question_answer14)
  How are columns in excel worksheet labelled?
  A)
   Roman numbers done clear
  B)
        Numbers         done clear
  C)
        English Alphabet done clear
  D)
        Symbols done clear
  View Solution play_arrow

• question_answer15)
  Which component of MS-Excel is the intersection of row and column?
  A)
   Cell                             done clear
  B)
   Formula bar                done clear
  C)
   Row header      done clear
  D)
                    Column header done clear
  View Solution play_arrow

• question_answer16)
  How are rows in an Excel worksheet labelled?
  A)
   Alphabets         done clear
  B)
                    Worksheet      done clear
  C)
                    Column header done clear
  D)
          Numbers done clear
  View Solution play_arrow

• question_answer17)
  What steps are followed for saving an Excel workbook?
  A)
   Click on      icon of standard tool bar \[\to \]Type the name of the file \[\to \] OK. done clear
  B)
   File \[\to \] Save \[\to \] Type name of the file \[\to \] OK done clear
  C)
   Either (a) or (b) done clear
  D)
   Edit \[\to \] Save \[\to \] Type name of file \[\to \] OK done clear
  View Solution play_arrow

• question_answer18)
  What action will take place, when you click on  button of menu bar in MS Excel?
  A)
   You will Exit from MS Excel. done clear
  B)
   Your workbook will be closed. done clear
  C)
   Your file will be saved. done clear
  D)
   Your file will be minimized. done clear
  View Solution play_arrow

• question_answer19)
  What is the extension of a MS-Excel file?
  A)
   .EXL                           done clear
  B)
   EXCL             done clear
  C)
        .XLS               done clear
  D)
        .XL done clear
  View Solution play_arrow

• question_answer20)
  What is the work sheet which is currently in use called?
  A)
   Active cell                   done clear
  B)
   Active work sheet        done clear
  C)
   Both (a) and (b) done clear
  D)
   Neither (a) nor (b) done clear
  View Solution play_arrow

• question_answer21)
  Microsoft Excel is a/an ___ program.
  A)
   animation                done clear
  B)
   word processor done clear
  C)
   spreadsheet      done clear
  D)
           language done clear
  View Solution play_arrow

• question_answer22)
  Which button does X in the given picture denote?
  A)
   Enter                           done clear
  B)
   Cancel            done clear
  C)
        OK                    done clear
  D)
        Save done clear
  View Solution play_arrow

• question_answer23)
  Identify the keyboard shortcut to navigate between different worksheets?
  A)
   Shift + Pg up         done clear
  B)
              -Ctrl + Pg up done clear
  C)
        Alt+ Pg down         done clear
  D)
              Click on the desired sheet   done clear
  View Solution play_arrow

• question_answer24)
  What are the steps to insert a new row in a worksheet?
  A)
   Edit \[\to \] New \[\to \] Row      done clear
  B)
        File \[\to \] New \[\to \] Row done clear
  C)
        Format \[\to \] Row      done clear
  D)
              Insert \[\to \] Row             done clear
  View Solution play_arrow

• question_answer25)
  Which of the following statements is NOT true?
  A)
   Cell conents of MS Excel can be modified using edit commands. done clear
  B)
        Cancel and enter buttons are found on formula bar. done clear
  C)
        When you double click the cell, it allows you to perform minor modifications. done clear
  D)
        In MS Excel, calculations can only be performed using formulae. done clear
  View Solution play_arrow

• question_answer26)
  Which of these is/are the data types of MS-Excel?
  A)
   Numbers                     done clear
  B)
        Text                done clear
  C)
        Formulae                done clear
  D)
        All of these done clear
  View Solution play_arrow

• question_answer27)
  What does a spreadsheet contain?                           
  A)
   Columns                 done clear
  B)
        Rows                      done clear
  C)
                                Cells                            done clear
  D)
        All of these                 done clear
  View Solution play_arrow

• question_answer28)
  What is the smallest unit of worksheet in Excel?               
  A)
   Row                            done clear
  B)
        Column                  done clear
  C)
                                Cell                             done clear
  D)
        Range done clear
  View Solution play_arrow

• question_answer29)
  How many sheets does an excel window display by default?
  A)
   1                                 done clear
  B)
        2                                 done clear
  C)
                    3                                 done clear
  D)
        4 done clear
  View Solution play_arrow

• question_answer30)
  In a school, the marks details of class-VI students are entered in Excel sheet. What is the quickest way to access the details of a particular student of a worksheet?
  A)
   Type the students name in the name box. done clear
  B)
        Type the students name in the formula bar. done clear
  C)
        Type the students name in the zoom bar. done clear
  D)
        Type the students name in the font size box. done clear
  View Solution play_arrow

• question_answer31)
  Which of the following components displays the contents of active cell?
  A)
   Name box      done clear
  B)
        Formula bar    done clear
  C)
        Menu bar                done clear
  D)
        Status bar done clear
  View Solution play_arrow

• question_answer32)
  Which of the following keys is pressed in order to move between the cells in MS-Excel?
  A)
   Tab key                       done clear
  B)
        Enter key                     done clear
  C)
        Arrow key               done clear
  D)
        All of these done clear
  View Solution play_arrow

• question_answer33)
  What combination keys will help you select the entire row of the active cell?
  A)
   Ctrl + F1                    done clear
  B)
        Alt + Space bar                      done clear
  C)
        Ctrl + Space bar     done clear
  D)
        Shift + Space bar done clear
  View Solution play_arrow

• question_answer34)
  In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented?
  A)
   A10                             done clear
  B)
        A12                             done clear
  C)
        A2:A10                       done clear
  D)
        A2:A12 done clear
  View Solution play_arrow

• question_answer35)
  Which shortcut key will access the entire column of an active cell?
  A)
   Ctrl + Spacebar         done clear
  B)
        Alt + Spacebar           done clear
  C)
        Ctrl + F1                done clear
  D)
        Alt + F1 done clear
  View Solution play_arrow

• question_answer36)
  How many rows does each worksheet contain?
  A)
   256                             done clear
  B)
        1024               done clear
  C)
        64                               done clear
  D)
        65536 done clear
  View Solution play_arrow

• question_answer37)
  What does the cell with the arrow mark represent?
  A)
   Sheet tab                    done clear
  B)
        Cell pointer     done clear
  C)
                    Active sheet                done clear
  D)
        Workbook  done clear
  View Solution play_arrow

• question_answer38)
  Which key should be pressed to activate extend indicator (EXT) in status bar?                                              
  A)
   F5                               done clear
  B)
        F7                   done clear
  C)
        F8                               done clear
  D)
        F11         done clear
  View Solution play_arrow

• question_answer39)
  Which cell in the Excel window is active?
  A)
   C3                              done clear
  B)
        B2                               done clear
  C)
        A6                               done clear
  D)
        D1 done clear
  View Solution play_arrow

• question_answer40)
  Which component of MS-Excel window helps you to negative between different worksheets?
  A)
   Cell                             done clear
  B)
        Scroll button   done clear
  C)
                    Formula bar                done clear
  D)
        Title bar done clear
  View Solution play_arrow