# CIM 216 SPREADSHEETS - DOC by 0xr79J

VIEWS: 0 PAGES: 3

• pg 1
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.

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

Question 3                                                                                                           2 out of 2 points
The VLOOKUP function uses data arranged by ________.

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

Question 5                                                                                                           2 out of 2 points
The VLOOKUP function uses data arranged by columns.

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

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

Question 8                                                                                                           2 out of 2 points
Any character may be used in a range name.

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

=IF(A15>G1,G15,H15)

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.

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.

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.

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:

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

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.

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

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

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

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

Question 24                                                                                                 2 out of 2 points
Clip Art, once inserted into a worksheet, can be modified.

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

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.

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