Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

excel quiz

Question 1

  1. Which group of the Chart Tools Design tab is used to switch the rows and columns of a chart? 

     

    Chart Layouts

     

    Chart Styles

     

    Data

     

    Type

     

    5 points  

    Question 2
    1. Which of the following functions is written in the correct syntax? 

       

      NOW(today)

       

      =SUM(A1:D1)

       

      SUM(D2=A2)

       

      =SUM(A1=B1)

       

      5 points  

      Question 3
      1. Where do you type a cell reference and then move directly to that cell?

         

        Name box

         

        Formula bar

         

        Status bar

         

        Navigation pane

         

        5 points  

        Question 4
        1. Which tab on the Ribbon includes the feature to freeze panes?

           

          Page Layout

           

          Home

           

          View

           

          Data

           

          5 points  

          Question 5
          1. By default, how are charts inserted into a worksheet? 

             

            Source object

             

            Paste Special object

             

            Embedded object

             

            Linked object

             

            5 points  

            Question 6
            1. Which of the following occurs whenever a number in a referenced cell in a formula changes? 

               

              All formulas that are dependent on the changed value are deleted.

               

              All formulas that are dependent on the changed value are edited.

               

              All formulas that are dependent on the changed value are recalculated.

               

              All formulas that are dependent on the changed value are highlighted.

               

              5 points  

              Question 7
              1. Which of the following terms refers to separating the slices of a pie chart? 

                 

                Arranging

                 

                Exploding

                 

                Imploding

                 

                Expanding

                 

                5 points  

                Question 8
                1. Which of the following is an absolute reference? 

                   

                  #E#8

                   

                  E$8

                   

                  $E$8

                   

                  E8

                   

                  5 points  

                  Question 9
                  1. Which of the following would result from setting a cell's number style to Comma [0]?

                     

                    12345.67

                     

                    12,345.67

                     

                    $12,345.67

                     

                    12,346

                     

                    5 points  

                    Question 10
                    1. Which of the following is a predefined set of formatting choices that can be applied to an entire workbook in one simple step? 

                       

                      Theme

                       

                      Screenshot

                       

                      AutoFormat

                       

                      SmartArt

                       

                      5 points  

                      Question 11
                      1. Which of the following is not a method to rename a sheet? 

                         

                        Double-click the sheet tab

                         

                        Page Layout tab, Page, Setup group

                         

                        Home tab, Cells group, Format, Rename Sheet

                         

                        Right-click the sheet tab

                         

                        5 points  

                        Question 12
                        1. Which of the following is not a valid character for use in a number entry? 

                           

                          5

                           

                          +

                           

                          #

                           

                          %

                           

                          5 points  

                          Question 13
                          1. Which tab on the Ribbon displays error checking tools? 

                             

                            Home

                             

                            Formulas

                             

                            Data

                             

                            Review

                             

                            5 points  

                            Question 14
                            1. Which of the following automatically resizes the column to fit the width of the column's contents? 

                               

                              Clicking the column boundary line

                               

                              Double-clicking the column boundary line

                               

                              Right-clicking the column boundary line

                               

                              Double right-clicking the column boundary line

                               

                              5 points  

                              Question 15
                              1. What is the name of the square in the lower-right corner of a selection that is used to copy cells? 

                                 

                                Copy handle

                                 

                                Range handle

                                 

                                Fill handle

                                 

                                Replicate handle

                                 

                                5 points  

                                Question 16
                                1. Which of the following displays different sections of a worksheet at the same time? 

                                   

                                  Windows

                                   

                                  Frames

                                   

                                  Panes

                                   

                                  Breaks

                                   

                                  5 points  

                                  Question 17
                                  1. Which of the following is the intersection of a row and a column?

                                     

                                    Cell

                                     

                                    Pane

                                     

                                    Chart

                                     

                                    Grid

                                     

                                    5 points  

                                    Question 18
                                    1. Which of the following displays entries as they are made and edited in the Excel workbook window?

                                       

                                      Formula bar

                                       

                                      Format menu

                                       

                                      Format menu

                                       

                                      Title bar

                                       

                                      5 points  

                                      Question 19
                                      1. What is created when two or more cells are combined? 

                                         

                                        Combination cell

                                         

                                        Merged cell

                                         

                                        Grouped cell

                                         

                                        Combined cell

                                         

                                        5 points  

                                        Question 20
                                        1. How many cells are included in the range A1:B3?

                                           

                                          2

                                           

                                          4

                                           

                                          6

                                           

                                          9

                                           
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question