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