Advanced Diploma in Microsoft Excel.docx NEW NEW.docx

If a workbook is finished with no further changes

This preview shows page 19 - 24 out of 37 pages.

40)If a Workbook is finished, with no further changes required and needs to be considered Final, what option should accessed on the File/Info Window? A.PropertiesB.The Protect Workbook button (Correct Answer)C.Inspect Workbook buttonD.Versions button
Image of page 19

Subscribe to view the full document.

E.Browser View Options button (Your Answer)Incorrect 41)What dictates the colour of Range Finders? The Function being used 42)When a Workbook is protected, what option cannot be used with any of the Worksheets?
Image of page 20
43)When a Function is inserted inside another Function, this is called? 44)How do the arguments in the Lookup function work? A.B.It searches for all text valuesC.It searches for a given value in a given range then returns a matching value in another range (Your Answer)D.It returns the value for a given cellE.It returns the values of all cells where a numerical sort has been usedCorrect It searches for any ascending numerical values
Image of page 21

Subscribe to view the full document.

45)Which statement is true for 'Locked' and 'Hidden' when protecting cells? 46)To define monetary data inside a cell as '£' (Pound Sterling), what format should be used for the cell?
Image of page 22
47)If the COUNT function returns the number of cells that contain numbers, what does the COUNTA function return?
Image of page 23

Subscribe to view the full document.

Image of page 24
  • Fall '19

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