quizz bank 9 - True/false 25.excelappendsfile/...

Info icon This preview shows page 1. Sign up to view the full content.

True / false 25. excel appends file:/ to the beginning of the address to indicate that the address points to a  file saved on disk 26. the convert text to columns wizard can be used only when a range that includes a single  column is selected. 27. when the range is transposed the first row of the selected range becomes the first row of the  destination range and so on 28. the technique of replicating the formulas after completing the import is necessary because  the total number of records to be imported usually is unknown. 29. sharing should be used only for the purpose of viewing the contents of worksheet data 30.to print the comments where they appear on the worksheet click show all comments on the 
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: review tab on the ribbon move and resize the comments as necessary and then print the worksheet. 31. after a shared workbook is protected no one can unprotect or change it except the owner 32. to open a workbook and review tracked changes press ALT+T, G, C. 33.the default chart type for a pivotchart is a clustered column chart. 34. if you are not sure of the time period that will elapse before you merge workbooks that you send out for changes set a small number of days for keeping the change history. 35. to add a trend line to a chart, press ALT+JA, CTRL+M 36. when a worksheet is printed its background would also be printed....
View Full Document

  • Spring '11
  • MikeCooper
  • worksheet data, default chart type, worksheet click

{[ 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