CCE 170 - Exam #1 KEY

Fall Semester 2021

Short Answer

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

10. (excel) To enter an array formula in Excel, you must press - - Enter after typing or editing the formula.

11. (compsci) Suppose that you have a Qwest DSL broadband connection capable of downloading at 1.0 Mbps (mega-bit per second). At this rate, how long would it take you to download 700 MB (mega-byte) of data (about one CD's worth)?

[minutes]

12. (compsci) Due to the way they are stored in memory, real (decimal) numbers are often called point numbers.

13. (compsci) The binary number 1101 is equivalent to the number in base 10.

14. (compsci) Octal numbers are stored in groups of bits.

15. (html) The name for the default file (i.e. "home page") for a web contained in a folder of multiple files is .

16. (excel) Write a spreadsheet formula that checks the contents of cell G4. If value in G4 is not equal to zero, it returns the inverse (1/x) of the value in G4, otherwise it returns zero.

17. (html) What does the expression WYSIWYG stand for?