CSCI 235 –MICRO-COMPUTER APPLICATIONS – SAMPLE EXAM



CSCI 235 –MICRO-COMPUTER APPLICATIONS – SAMPLE EXAM #2

October 27, 2006

Name:____________________________ ID No. ____________________________

Section 1. [30 pts] Multiple Choice.

The following questions refer to Microsoft Excel:

1. Assume that cell C4 contains a formula. Where would you see the formula displayed?

a) In cell C4

b) In the Formula bar

c) In the Name box

d) In the Status bar

2. Cell E3 contains the function =AVERAGE(A3:D3). What will be the contents of cell E4 if the entry in cell E3 is copied to cell E4?

a) =AVERAGE(A3:D3)

b) =AVERAGE(A4:D4)

c) =AVERAGE($A$3:$D$3)

d) =AVERAGE($A$4:$D$4)

3. Which of the following is a valid cell range?

a) 6

b) A2:B3

c) C4,G9

d) All of these answers are correct

4. $B8 is a(n):

a) Absolute cell reference

b) Mixed cell reference

c) Relative cell reference

d) None of these answers are correct

5. Which of the following is a valid Excel formula?

a) =C4*D4

b) B4*D4

c) Both =C4*D4 and B4*D4

d) Neither =C4*D4 nor B4*D4

6. Which key cycles through absolute, relative, and mixed cell references?

a) F11

b) F4

c) F1

d) Alt + Tab

7. Why should assumptions be isolated from the rest of the worksheet?

a) You can make a change to an assumption and instantly see the effect

b) You can change the contents of a single cell rather than change multiple formulas

c) Assumptions should not be isolated from the rest of the worksheet

d) You can make a change to an assumption and instantly see the effect and also change the contents of a single cell rather than change multiple formulas

8. The Today() function will return:

a) The date the worksheet was created

b) The current date

c) The date the function was inserted into the worksheet

d) None of these answers are correct

9. Which of the following is not a valid way to enter a date into a cell?

a) 1/3/01

b) =1/3/01

c) 1/3/2001

d) All of these answers are correct

10. How can an Excel workbook be saved as a Web page?

a) Select Save As and put “Web page” in the filename

b) Select Save

c) Select Save as Web Page

d) An Excel workbook cannot be saved as a Web page

11. Which argument in the =PMT function is typically entered as a negative amount?

a) The interest rate

b) The number of periods

c) The principal

d) None of these answers are correct

12. When using the Goal Seek command, how many parameters can you change at a time?

a) None

b) 1

c) 2

d) 3

13. Which of the following is not a valid conditional test in an =IF function?

a) B6 = A5

b) B6 > A5

c) (B6/A5)> 90

d) (B6/A5)*10

14. Which of the following is false about an =IF function?

a) A condition that can be evaluated as true or false is a required argument

b) A value to return if the condition is true is a required argument

c) A value to return if the condition is false is a required argument

d) A value to return if the condition is true or if the condition is false are both optional

15. Which of the following can be included in the function =AVERAGE?

a) A1:A4

b) A1,A4

c) Fred

d) All of these answers are correct

16. You are working with a large worksheet. It is not possible to see row headings while you are looking at distant row information. Which command(s) should be used to see both the row headings and distant rows?

a) Hide Rows

b) Split Window Horizontally

c) Freeze Panes

d) Separate worksheets and tile the worksheets

17. Which of the following is not suited to display multiple data series?

a) Pie chart

b) Horizontal bar chart

c) Column chart

d) Stacked column chart

18. Which of the following cannot be done using the Chart Wizard?

a) Adding an arrow and text to the chart

b) Adding a chart title

c) Removing the legend

d) Changing the data series to columns

The following questions refer to the Internet and the World Wide Web:

19. Which part of this URL is the document name: ?

a) http

b)

c) /vt/

d) usa.htm

20. Which of the following operators should you use between the key words “Civil” and “Rights” to implement the most restrictive search?

a) And

b) Or

c) Not

d) None of these answers is correct

Section 2. [30 pts] True/False.

The following questions refer to Microsoft Excel:

1. Multiple data series may be contained in either rows or columns.

2. A chart created using the Chart Wizard cannot be modified.

3. If a chart is kept in a separate chart sheet, it will not be updated when the data points in the worksheet are updated.

4. Column charts, bar charts, and pie charts are the only types of charts you can produce in Excel.

5. It is possible to include another =IF function as an argument in an =IF function.

6. If you want to calculate the value of investments you were making to a retirement account, the =FV function would be the best function to use.

7. The interest rate in the =PMT function is the rate per period, not the annual rate.

8. A cell reference can be entered into a formula by clicking on the cell you want to enter into the formula.

9. A formula may contain both absolute and relative cell references.

10. An absolute reference remains constant throughout a copy operation.

11. A cell reference with a dollar sign in front of the row and a dollar sign in front of the column is a relative reference.

12. When a cell containing a numeric value displays a series of number signs (########), this means there is an error in the formula.

13. Excel functions such as AVERAGE(B9:B12) do not need to be preceded by the equal sign.

14. An Excel worksheet may contain several workbooks.

15. Excel cell references refer to the row by letter and the column by number.

16. A constant is preceded by an equal sign.

The following questions refer to the Internet and the World Wide Web:

17. HTML stands for HyperText Markup Language.

18. The Internet is the same as the World Wide Web.

19. The Favorites menu allows Internet Explorer users to find Web pages again.

20. Most HTML tags occur in pairs.

Section 3. [36 pts] Short Answer.

1. What is the purpose/functionality of a modem?

2. What is bandwidth and how is it related to data rate?

3. What is the purpose of a port?

4. What is a protocol? Briefly describe the HTTP protocol

5. What is a cookie?

6. Briefly define the terms plaintext, cyphertext, cipher, and key

Section 4. [4 pts] HTML

Write HTML code for creating a link to our university’s webpage (). The text of the link should be “St. Francis Xavier University”.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download