excell test

# Correct answer copying the contents of a cell to

This preview shows pages 2–4. Sign up to view the full content.

Correct Answer: copying the contents of a cell to adjacent cells. Question 13 Multiple Choice 3 of 3 points In the formula =\$B\$4*C4, which cell address will change when the cell is copied? Selected Answer: C4 Correct Answer: C4 Question 14 Multiple Choice 0 of 3 points Why should assumptions be isolated from the rest of the worksheet? Selected Answer: You can change the contents of a single cell rather than change several formulas. Correct Answer: It is easier to make changes since they are made in one place and the effects of the change are shown instantly. Question 15 Multiple Choice 3 of 3 points If you enter the function =AVERAGE(B10:B18) into a cell and enter two rows between rows 12 and 13, the function will now read:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Selected Answer: =AVERAGE(B10:B20). Correct Answer: =AVERAGE(B10:B20). Question 16 Multiple Choice 0 of 3 points You have created a worksheet and saved it as a Web page. You are viewing that page in Internet Explorer and notice an error. You click the Edit with Microsoft Excel button, which launches Excel and allows you to make changes to the document. The feature you have used is called: Selected Answer: the Save As Web Page command. Correct Answer: round trip HTML. Question 17 Multiple Choice 3 of 3 points The Web page format in which all elements of a Web page are saved as one file is called: Selected Answer: MHTML Correct Answer: MHTML Question 18 Multiple Choice 0 of 3 points If you enter a date into a cell, Excel stores the date as: Selected Answer: text with either a two-digit or four-digit year, depending on the format. Correct Answer: an integer. Question 19 Multiple Choice 3 of 3 points Which of the following requires an Internet connection? Selected Answer: Updating the values that are obtained through a Web query Correct Answer: Updating the values that are obtained through a Web query Question 20 Multiple Choice 3 of 3 points The capability that enables Excel to retrieve information from a Web site and display it in your worksheet is a: Selected Answer: Web query. Correct Answer: Web query. Question 21 Multiple Choice 0 of 3 points You created a worksheet on July 30 and entered the =Today() function in cell E17. You opened that worksheet again on August 31. What will be displayed in cell E17 on August 31?
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern