Chennai Laptop Service
Laptop Repair Service In Chennai
Call 8681030184 ; 8754598732
Revision Exercise 5
-- Create a new „notepad‟ document [enter your favorite color in this text document] and save it on the desktop by the name „COLOUR‟. Close this document once done.
-- Reopen the Excel Document we created in Exercise 1.
-- Insert a worksheet and rename it „Hyperlinks‟.
-- On this worksheet go to cell A1.
-- Insert a „hyperlink‟ in Cell A1 to the Text document „COLOUR‟. Name this hyperlink „My favorite color‟.
-- Now go to cell A3.
-- Insert a „hyperlink‟ in Cell A3 to the website „www.google.com‟.
-- Now go to cell A5.
-- Insert a „hyperlink‟ in Cell A5 to sheet AB3. Name this hyperlink „Weekly Sales‟.
-- Now go to cell A7.
-- Insert a „hyperlink‟ in Cell A7 to a new text document (notepad). Name this hyperlink „My favorite actor‟. [This function allows you to insert a hyperlink to a document that does not already exist]. In this document type „NEW Document: Favorite actor XXX‟. Now save this document on the desktop by the first name of your favorite actor. Close the text document.
-- Now edit the name of the hyperlink in Cell A7 to „ACTOR‟. Save this.
-- Now open all documents/worksheets/webpages using the hyperlinks you just created.
-- Now remove the hyperlinks in Cell A1 and A5.
-- Save and close this excel document.
-- Now close all windows and reopen the excel document.
-- Explore the „Print preview‟ and „Print‟ options.
[If you have access to a Printer, try the following]
-- Print only worksheet AB1 & AB3.
-- Print only worksheet AB2 in „Landscape‟ page orientation.
-- Now print all 4 worksheets in the „Portrait‟ page orientation.
-- Explore other options in the „Page Setup‟ group >Page Layout tab.
-- Once done, close the excel document.