Your coworker created a workbook with a list of names and addresses. The state abbreviation and ZIP code are stored in one cell per customer, such as NC 27215. You need to be able to sort these data by postal code to use bulk-rate mailing. The appropriate Excel action is to: (a) Type 27215 in the cell to the right of NC 27215 and use Flash Fill.

(b) Copy the data to another column and edit each cell to delete the state abbreviations.

(c) Use the BREAK APART function to separate the state abbreviation and zip code.

(d) Insert a new column and retype the postal codes.

Kyle wants to access his school’s home page. how can he do this?

3. (6 pts) internally in the computer, with few exceptions, all numerical computation is done using binary numbers. output, however, often uses ascii, which is formed by appending 011 to the left of a bcd code. thus, an algorithm that directly converts a binary integer to a bcd integer is very useful. here is one such algorithm 1) draw lines to the left of the binary number to bound the expected bcd decades. (each decade is a group of 4 bits.) move the binary number one bit to the left. add 0011 to each bcd decade containing a binary value> 0100 repeat steps 2-3 until the last bit in the binary number has been moved into the least significant decade position. (note that when the last bit has been shifted into bcd decade, step 3 is not repeated.) read the bcd result. 2) 3) 4) 5) a) execute the algorithm for the binary number 1101101 b) execute the algorithm for the binary number 01110101110 4. (4 pts) represent the decimal number 3568 in bcd; excess-3 code; ascil; and hex.

Which of the following is true of operations within a spreadsheet program’s built-in functions? a. operations within parentheses, then multiplication and division, and then addition and subtraction are computed. b. operations within parentheses, then addition and subtraction, and then multiplication and division are computed. c. multiplication and division, then addition and subtraction, and then operations within parentheses are computed. d. addition and subtraction, then multiplication and division, and then operations within parentheses are computed