NAME___________________________________________________
Wentworth Institute of Technology
Division of Professional and Continuing Studies
COMP112 Section 71 – Intro to Computers and Programming - Spring, 2008
Midterm – Open Book – CIRCLE YOUR ANSWERS. THERE IS POSSIBLY
MORE THAN ONE CORRECT RESPONSE
Part 1 Questions are 5 points each. Part II is 25 points
1. Data Validation in an Excel cell can be done via:
A. A drop down list populated from other cells D. specifying text with certain numbers of characters
B. A drop down list from a typed list E. data must be typed in a certain format(like xxx-xx-xxxx
for a Social Security number)
C. A range of dates F. A range of numerical values
2. Which ways allow you to see formulas without changing the functioning of the formula:
A. An option in the view menu D. ctl grav,
B. Tools/formula auditing/forumula auditing mode E. Displayed in formula bar at top
C. By an option in format cell F. putting an apostrophe in front of the equal sign
3. Which of the below properties of an excel chart marker can be changed:
A. The edge color (foreground) D. The fill pattern
B. The inside color (background) E. The size
C. The thickness of the edge F. The shape (or style)
4. Autofill can do which of the following sequences:
A. 10,9,8,7,6,5,4,3,2,1 D. 5,5,5,5,5,5,5
B. January,February,March,April E. Monday,Tuesday,Wednesday,Thursday
C. Bob,Bob,Bob,Bob,Bob F. R,Q,M,R,Q,M,R,Q,M,R,Q,M
5. Draw lines connecting the formula on the left to its function on the right. IE Draw Lines from (A-C to the matching
description in (D-F)
A. =COUNT(range) D. Counts the cells that have numbers
B. =COUNTA(range) E. Counts only the items that have positive values
C. =COUNTIF(range,">0") F. Counts the NON-blank cells
6. Once a chart has been made in EXCEL, which of the below items CAN be changed.
A. Axis limits D. The vertical location of the X axis
B. The font of the title E. Chart type
C. Visibility of grid lines F. Font Size of the legend
7. Adding series to an EXCEL chart can be done via which of the below methods?
A. Format Chart Area D. Chart Type menu
B. Source Data menu E. Chart Options menu
C. Data Table tab F. Just typing a new column of data in the sheet
8. Which are NOT available trend lines that can be added to a chart
A. Logarithmic D. Exponential
B. Spline Fit E. 5th degree polynomial
C. Trignometric fit F. Least Square fit to arbitrary function
/app/work/qkdc2q-425256-2764989-midtermcomp112sp08-doc.doc 12/4/2020 1
P1
P2
Total
