CCE 170 - Exam #1 KEY

Fall Semester 2021

NOTE: This exam is divided into 7 pages. At the bottom of each page is a button that submits your answers for the current page. You must use this button to enter your scores to the database. Clicking on the forward and back buttons of your browser or using one of the links shown above does NOT submit your answers.

At the end of this exam you will encounter a confirmation page that lets you either finish the exam or go back to page 1 so that you can cycle through all of the pages again and review your answers.You can loop through the pages as many times as you want as long as you finish the exam on time.

If you accidentally kill your browser, simply bring up a new one and log on to the test again. Your previously submitted answers will be retained.

Note: Using the Excel Help Utility is NOT allowed on this page of the exam.

1. (1 pt each) True or False:

a. T F  (html) The term HTML stands for Hypertext Markup Language.

b. T F  (compsci) A bit consists of eight bytes.

c. T F  (compsci) RAM and ROM are examples of internal memory.

d. T F  (compsci) The Y2K scare resulted from programmers using only one byte to store the year portion of a date.

e. T F  (html) Photos cannot be embedded directly inside HTML-based web pages. Rather, they must be saved as separate files and are displayed by creating a link to the photo in the HTML source.

f. T F  (excel) When you use a array formula, the value returned by the formula is always an array (as opposed to a single value)

g. T F  (excel) The else part (third argument) to the IF function in Excel is optional.

h. T F  (excel) You can only have one custom name assigned to a given cell or range in Excel.

i. T F  (excel) The table argument to the VLOOKUP function is typically relative (as opposed to absolute).

j. T F  (compsci) Only one person can edit a google doc at a time.