7th Class Computers Science Microsoft Excel Question Bank

done Working with Basic Formulas in MS-Excel Total Questions - 51

• question_answer1)
  Which one of the following is NOT a function of MS-Excel?
  A)
   AVERAGE                              done clear
  B)
   ADD               done clear
  C)
                    MAX               done clear
  D)
                    MIN done clear
  View Solution play_arrow

• question_answer2)
  Which of these icons of MS Excels standard tool bar depicts Auto sum function?
  A)
    done clear
  B)
                      done clear
  C)
                       done clear
  D)
                     done clear
  View Solution play_arrow

• question_answer3)
  The spreadsheet given is used for recording (he rental fee for each student in the middle school band. How is the total cost per year for all the instruments calculated?
  A)
   By adding cells C7 through E7 done clear
  B)
   By adding cells C2 through C6 done clear
  C)
   By adding cells E2 through E6 done clear
  D)
   By adding cells D2 through D6 done clear
  View Solution play_arrow

• question_answer4)
  Observe the excel worksheet given. Which of the following gives the average of rekha?s marks?
  A)
   Average (B3 : F3)                   done clear
  B)
   Average (B3 : F5) done clear
  C)
   Average (G1 : G3) done clear
  D)
   Average (B1 : B3) done clear
  View Solution play_arrow

• question_answer5)
  What action is performed in window 1 to get window 2?
  A)
   Deleted the selected cells   done clear
  B)
   Moved the selected cells done clear
  C)
   Copied the selected cells   done clear
  D)
   Inserted new row a column done clear
  View Solution play_arrow

• question_answer6)
  Find the correct order of precedence.
  A)
   ^, *, /, ( )         done clear
  B)
                                ^, +, /, ( )      done clear
  C)
                    ( ), ^, *, t          done clear
  D)
                                *, ^, ( ), - done clear
  View Solution play_arrow

• question_answer7)
  What is the function of Max ( )?
  A)
   It finds the average value of the given cell range. done clear
  B)
   It finds the minimum value of the given cell range. done clear
  C)
   It finds the maximum value of the given cell range. done clear
  D)
   It finds the total value of the given cell range. done clear
  View Solution play_arrow

• question_answer8)
  How do you insert today's date in the document while working with MS-Excel?
  A)
   Ctrl + ?(single quote) done clear
  B)
   Ctrl +; (semi colon) done clear
  C)
   Ctrl +. (Dot) done clear
  D)
   Ctrl +! (Exclamation) done clear
  View Solution play_arrow

• question_answer9)
  Which function returns min value of the given cell range?
  A)
   Max ( )             done clear
  B)
                    Sum ( )           done clear
  C)
                                            Average ( )        done clear
  D)
                                Min ( ) done clear
  View Solution play_arrow

• question_answer10)
  To find Max value of the total marks of all the 4 students, which of these functions will you apply?
  A)
   Max (E2 : E5)                         done clear
  B)
   Max (B5 : E5) done clear
  C)
   Min (E2 : E5)    done clear
  D)
             Min (B5 : E5) done clear
  View Solution play_arrow

• question_answer11)
  What are predefined formulae in MS-Excel called?
  A)
   Range              done clear
  B)
                                Parentheses done clear
  C)
   Operators done clear
  D)
   Function done clear
  View Solution play_arrow

• question_answer12)
  What is the icon of MS Excel marked X called?
  A)
   Paste function  done clear
  B)
                    Auto sum done clear
  C)
   Auto fill             done clear
  D)
                                Insert function done clear
  View Solution play_arrow

• question_answer13)
  What is the default row height in an MS-Excel worksheet?
  A)
   12.75 points     done clear
  B)
                                10.75 points done clear
  C)
   11.75 points     done clear
  D)
             13. 75 points done clear
  View Solution play_arrow

• question_answer14)
  What is the default column width of an MS-Excel worksheet?
  A)
   8.25 points       done clear
  B)
                                12.75 points done clear
  C)
   8.43 points       done clear
  D)
            12.83 points done clear
  View Solution play_arrow

• question_answer15)
  What are the steps to change the column width of an MS-Excel worksheet?
  A)
   Format \[\to \] Column \[\to \] Width                              done clear
  B)
            View \[\to \] Column \[\to \] Width                                   done clear
  C)
            Tools \[\to \] Column \[\to \] Width                                   done clear
  D)
            Inserts \[\to \] Column \[\to \] Width done clear
  View Solution play_arrow

• question_answer16)
  Command allows the user to reverse the last action.
  A)
   Redo                           done clear
  B)
                    Undo                      done clear
  C)
                                Repeat                        done clear
  D)
                    Copy                                       done clear
  View Solution play_arrow

• question_answer17)
  Which of the following icons of the standard tool bar is X?
  A)
   Redo                           done clear
  B)
                    Undo      done clear
  C)
            Cut                             done clear
  D)
                    Paste        done clear
  View Solution play_arrow

• question_answer18)
  What is the function of redo command?
  A)
   It can redo the previously undone actions. done clear
  B)
            It can undo the redone actions. done clear
  C)
            It can clear the desired data. done clear
  D)
            It can open the previously closed document.                 done clear
  View Solution play_arrow

• question_answer19)
  What is the shortcut key combination of redo function?
  A)
   Ctrl + Z                      done clear
  B)
                    Ctrl + X    done clear
  C)
            Ctrl + Y                                  done clear
  D)
            Ctrl + V                                  done clear
  View Solution play_arrow

• question_answer20)
  Using menu options, what are the steps used to perform copy and paste function?
  A)
   Edit \[\to \] Copy and Edit \[\to \] Paste done clear
  B)
            File \[\to \] Copy and Edit \[\to \] Paste done clear
  C)
            Edit \[\to \] Copy and Insert \[\to \] Paste done clear
  D)
            Edit \[\to \] Copy and Format \[\to \] Paste done clear
  View Solution play_arrow

• question_answer21)
  Which icons will you click to perform copy and paste function?
  A)
                     done clear
  B)
                                       done clear
  C)
                            done clear
  D)
                     done clear
  View Solution play_arrow

• question_answer22)
  Which of these pairs of icons will you click to perform cut and paste function?
  A)
                      done clear
  B)
                                        done clear
  C)
                               done clear
  D)
                     done clear
  View Solution play_arrow

• question_answer23)
  What is the shortcut key combination to copy and paste?
  A)
   Ctrl + C and Ctrl + X done clear
  B)
                     Ctrl + V and Ctrl + X done clear
  C)
            Ctrl + Z and Ctrl + C done clear
  D)
                     Ctrl + C and Ctrl + V done clear
  View Solution play_arrow

• question_answer24)
  Look at the given two figures and find out which function has been performed?

  i.  copy ii.  paste iii.  cut

                     
  A)
   Only I                          done clear
  B)
                    Both I and II done clear
  C)
            Only III                   done clear
  D)
            Both II and III done clear
  View Solution play_arrow

• question_answer25)
  Observe these two Excel windows carefully and find out what has been done to the data.        
  A)
   Overwritten              done clear
  B)
                                Cleared                       done clear
  C)
                    Copied                        done clear
  D)
                    Moved done clear
  View Solution play_arrow

• question_answer26)
  Which feature of MS Excel helps you enter the series of data automatically?
  A)
   Auto sum                 done clear
  B)
                                Function                     done clear
  C)
                                Auto fill                   done clear
  D)
                                Chart done clear
  View Solution play_arrow

• question_answer27)
  Observe the two given windows and identify which action has been performed.       
  A)
   New row has been inserted. done clear
  B)
            Column width has been increased. done clear
  C)
            Copy and paste action has been performed. done clear
  D)
            Cut and paste action has been performed. done clear
  View Solution play_arrow

• question_answer28)
  What does the changing in the appearance of the text refer to?
  A)
   Sort                             done clear
  B)
                    Formatting done clear
  C)
            Functions                 done clear
  D)
            Copying done clear
  View Solution play_arrow

• question_answer29)
  What does the icon     represent?
  A)
   Sort \[\to \] Ascending    done clear
  B)
                  Sort \[\to \] Descending done clear
  C)
            Sort \[\to \] Justified        done clear
  D)
               Conditional sort done clear
  View Solution play_arrow

• question_answer30)
  The first step to format your spreadsheet data is to ___.
  A)
   Type '=' sign             done clear
  B)
              Insert a new row done clear
  C)
            Select the cell range   done clear
  D)
                 Insert a new column done clear
  View Solution play_arrow

• question_answer31)
  What is the function of the icon  of standard tool bar?
  A)
   It changes the font colour. done clear
  B)
            It changes the font style. done clear
  C)
            It underlines the font. done clear
  D)
            It fills colour into the selected cells. done clear
  View Solution play_arrow

• question_answer32)
  Which of these icons has been used to sort a given data with respect to "Name" column in descending order?
  A)
              done clear
  B)
                                             done clear
  C)
                                             done clear
  D)
                                 done clear
  View Solution play_arrow

• question_answer33)
  Name the icon of standard tool bar indicated with an arrow mark.
  A)
   Fill colour                  done clear
  B)
                                Font style                    done clear
  C)
            sort                             done clear
  D)
                    font colour done clear
  View Solution play_arrow

• question_answer34)
  What is the icon indicated with an arrow mark called?
  A)
   Sort - Descending      done clear
  B)
                    Sort ? Ascending done clear
  C)
            Upper case font         done clear
  D)
               Lower case font done clear
  View Solution play_arrow

• question_answer35)
  Which of these icons will you use for right alignment of data?
  A)
                   done clear
  B)
                                               done clear
  C)
                                   done clear
  D)
                     done clear
  View Solution play_arrow

• question_answer36)
  Which of the following statements is false?
  A)
   You cannot format a number to currency in MS Excel. done clear
  B)
            Steps to align contents of the cell are: Format  Cells  Alignment tab done clear
  C)
            Font style can be changed by using    and    buttons of standard tool bar. done clear
  D)
            You can print any worksheet of the workbook irrespective of its position. done clear
  View Solution play_arrow

• question_answer37)
  What do you mean by arrangement of data in a specified order in MS-Excel?
  A)
   Sorting                        done clear
  B)
                    Inserting   done clear
  C)
            Filtering                      done clear
  D)
                    Formatting done clear
  View Solution play_arrow

• question_answer38)
  What is the shortcut key to popup 'Format cells' dialogue box in MS-Excel?
  A)
   Ctrl + 1                      done clear
  B)
                    Ctrl + 2     done clear
  C)
            Ctrl + T                      done clear
  D)
                    Ctrl + 3 done clear
  View Solution play_arrow

• question_answer39)
  In MS-Excel, what is the pictorial representation of data in a worksheet called?
  A)
   Pictograph                done clear
  B)
                                Chart              done clear
  C)
                                Graph                     done clear
  D)
                                Pivot done clear
  View Solution play_arrow

• question_answer40)
  What is the shortcut key to apply border around selected cells?
  A)
   Ctrl + Shift + Plus (+) done clear
  B)
            Ctrl + Shift + Ampersand (b) done clear
  C)
            Ctrl + Shift + Asterisk (*) done clear
  D)
            Ctrl + Shift + Minus (-) done clear
  View Solution play_arrow

• question_answer41)
  Which of the following chart is referred to as scatter chart?
  A)
   Pie chart                     done clear
  B)
                    Bar chart   done clear
  C)
            XY chart                     done clear
  D)
                    Radar chart done clear
  View Solution play_arrow

• question_answer42)
  Which error is obtained when a formatted number does not fit within a cell?
  A)
   #####        done clear
  B)
                                #DIV/0     done clear
  C)
            #DIV@                      done clear
  D)
                    #VALUE! done clear
  View Solution play_arrow

• question_answer43)
  What does the tool indicated with an arrow mark in the chart toolbar of MS-Excel represent?
  A)
   Legend                   done clear
  B)
            Data table done clear
  C)
            Chart objects             done clear
  D)
            Chart types done clear
  View Solution play_arrow

• question_answer44)
  The formula bar displays what was entered in cell F2. Why did the error message #NAME? Appear in cell F2?
  A)
   There should be parenthesis around B2:E2. done clear
  B)
            The equal to sign should be deleted from the formula. done clear
  C)
            There should be a plus sign in the formula instead of a colon. done clear
  D)
            You can only use the count function to count down a column. done clear
  View Solution play_arrow

• question_answer45)
  What is the given tool bar called?
  A)
   Formatting tool bar   done clear
  B)
                  Menu bar done clear
  C)
            Standard tool bar      done clear
  D)
                 Drawing tool bar done clear
  View Solution play_arrow

• question_answer46)
  What is button P in the given tool bar in the picture?                                                    
  A)
   Percent style button   done clear
  B)
                  Increase decimal button done clear
  C)
            Decrease decimal button   done clear
  D)
            Currency style button done clear
  View Solution play_arrow

• question_answer47)
  What is the purpose of  button in the toolbar of MS-Excel?
  A)
   Merge and center      done clear
  B)
                 Lower case letters done clear
  C)
            Align center               done clear
  D)
            Italic and sentence case done clear
  View Solution play_arrow

• question_answer48)
  Which features of MS-Excel is used in window 1 for obtaining the drop-down control as shown in window 2?
  A)
   Auto sum                    done clear
  B)
                    Auto fill                       done clear
  C)
            Auto function done clear
  D)
                    Auto filter done clear
  View Solution play_arrow

• question_answer49)
  Which feature in MS-Excel allows you to apply different formatting options, such as colour, to a cell based on the data in the cell?
  A)
   Auto filter                 done clear
  B)
            Conditional formatting done clear
  C)
            Font colour                 done clear
  D)
            Sorting done clear
  View Solution play_arrow

• question_answer50)
  Which is the shortcut key that will hide the entire row in excel?
  A)
   Ctrl+9                        done clear
  B)
                    Ctrl + H                     done clear
  C)
                                Ctrl + R                  done clear
  D)
                                Ctrl + - done clear
  View Solution play_arrow

• question_answer51)
  What is the Auto complete feature of Excel?
  A)
   It automatically completes abbreviated words. done clear
  B)
            It completes text and numeric entries that match an existing entry in the same column. done clear
  C)
            It completes text entries that match an existing entry in the same column. done clear
  D)
            It completes text entries that match an existing entry in the same worksheet. done clear
  View Solution play_arrow