Correct answer copying the contents of a cell to

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

View Full Document Right Arrow Icon
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:
Image of page 2

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

View Full Document Right Arrow Icon
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?
Image of page 3
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern