CIM 216 SPREADSHEETS - DOC

Document Sample
CIM 216 SPREADSHEETS - DOC Powered By Docstoc
					CIM 216 - SPREADSHEETS: EXCEL (20101_15090) > TOOLS > MY GRADES > VIEW ATTEMPTS > REVIEW ASSESSMENT: CHAPTER 4 EXAM



      Review Assessment: Chapter 4 Exam

User             DON WILKS
Submitted        2/27/10 3:45 PM
Name             Chapter 4 Exam
Status           Completed
Score            56 out of 58 points
Instructions
 Question 1                                                                                                           2 out of 2 points
               Images cannot be added to your worksheet from the Office Clip Art Gallery.

               Selected Answer:        False
 Question 2                                                                                                           2 out of 2 points
               A picture’s style can be altered by using all of the following EXCEPT the:


                Selected Answer:           Picture Depth button.
 Question 3                                                                                                           2 out of 2 points
               The VLOOKUP function uses data arranged by ________.

                Selected Answer:           columns
 Question 4                                                                                                           2 out of 2 points
               An Excel 2007 template will be saved to disk with the extension of:


                Selected Answer:           xltx.
 Question 5                                                                                                           2 out of 2 points
               The VLOOKUP function uses data arranged by columns.

               Selected Answer:        True
 Question 6                                                                                                           2 out of 2 points
               A range name may contain each of the following characters EXCEPT:


                Selected Answer:           a space.
 Question 7                                                                                                           2 out of 2 points
               ________ images may be inserted into a worksheet to enhance its appearance.


                Selected Answer:           Clip Art
 Question 8                                                                                                           2 out of 2 points
               Any character may be used in a range name.

               Selected Answer:        False
 Question 9                                                                                                           2 out of 2 points
               In the following function, the logical_test is ________:

               =IF(A15>G1,G15,H15)


                Selected Answer:           A15>G1
Question 10                                                                                                    2 out of 2 points
              A formula containing a division operation that refers to an empty cell as the divisor generates an error.

              Selected Answer:      True
Question 11                                                                                                   2 out of 2 points
              The range lookup argument determines a result based upon ________.


              Selected Answer:         an exact match or not
Question 12                                                                                                   2 out of 2 points
              The IFERROR function can be used to provide a(n) ________.


              Selected Answer:         blank cell when an error occurs
Question 13                                                                                                   2 out of 2 points
              The equal sign in a logical function indicates that the values of two cells must match to be TRUE.

              Selected Answer:      True
Question 14                                                                                             2 out of 2 points
              When a workbook must be frequently reused, a ________ can save time and errors by providing a workbook
              with a set of formats and formulas.

              Selected Answer:         template
Question 15                                                                                                   2 out of 2 points
              The handle in each corner of an inserted graphic may be used to change:

              Selected Answer:         both the Height and the Width.
Question 16                                                                                                2 out of 2 points
              Formulas may be entered into a group of cells in a column by all of the following methods EXCEPT:


              Selected Answer:         Fill Right.
Question 17                                                                                                2 out of 2 points
              When protection is turned ON, others are prevented from making changes to locked cells in the worksheet.

              Selected Answer:      True
Question 18                                                                                                   0 out of 2 points
              To add a WordArt image to a worksheet, you click the WordArt button in the:

              Selected Answer:         Illustrations group on the Insert tab.
Question 19                                                                                                   2 out of 2 points
              The ________ tool allows text to be created as a graphic for logos and headings.

              Selected Answer:         WordArt
Question 20                                                                                                   2 out of 2 points
              All of the following operators can be used to compare two values EXCEPT:


              Selected Answer:         +
Question 21                                                                                                   2 out of 2 points
              Which of the following range names would NOT be treated as the same name?


              Selected Answer:         ProductCatalog
Question 22                                                                                                 2 out of 2 points
              Excel has variety of templates that you can access on-line.

              Selected Answer:      True
Question 23                                                                                                 2 out of 2 points
              An acceptable list of values that may be entered into a cell are defined by a(n) ________.

              Selected Answer:          validation list
Question 24                                                                                                 2 out of 2 points
              Clip Art, once inserted into a worksheet, can be modified.

              Selected Answer:      True
Question 25                                                                                                 2 out of 2 points
              The Define Name button will create a group of cells that are associated with a(n) ________.


              Selected Answer:          range name
Question 26                                                                                                 2 out of 2 points
              The corner handles in a graphic that has been inserted into a worksheet only allows the graphic to be resized
              horizontally.

              Selected Answer:      False
Question 27                                                                                                 2 out of 2 points
              A range name may start with any of the following characters EXCEPT a(n):


              Selected Answer:          number (0-9).
Question 28                                                                                                 2 out of 2 points
              To add a clip art image to a worksheet, you click the Clip Art button in the:

              Selected Answer:          Illustrations group on the Insert tab.
Question 29                                                                                                 2 out of 2 points
              A validation list can be created by typing a list of names.

              Selected Answer:      True

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:5/20/2012
language:
pages:3