Explain how to insert a hyperlink in to an Excel worksheet
and save a Word document as a Web page.
- 1 Answers
- 6289 Views
- I also Faced
- E-Mail Answers
Answer Posted / saba
Hyperlink creates a shortcut or jump that opens a document
stored on a network server, an intranet, or the Internet.
When you click the cell that contains the HYPERLINK
function, Microsoft Excel opens the file stored at link
location.
HYPERLINK (link_location, friendly_name)
Link_ location is the path and file name to the document
to be opened as text. Link_location can refer to a place in
a document — such as a specific cell or named range in an
Excel worksheet or workbook, or to a bookmark in a
Microsoft Word document. The path can be to a file stored
on a hard disk drive, or the path can be a universal naming
convention (UNC) path on a server (in Microsoft Excel for
Windows) or a Uniform Resource Locator (URL) path on the
Internet or an intranet.
• Link_location can be a text string enclosed in
quotation marks or a cell that contains the link as a text
string.
• If the jump specified in link_location does not
exist or cannot be navigated, an error appears when you
click the cell.
Friendly_name is the jump text or numeric value that is
displayed in the cell. Friendly_name is displayed in blue
and is underlined. If friendly_name is omitted, the cell
displays the link_location as the jump text.
• Friendly_name can be a value, a text string, a
name, or a cell that contains the jump text or value.
• If friendly_name returns an error value (for
example, #VALUE!), the cell displays the error instead of
the jump text. .
Examples:-
The following example opens a worksheet named Budget
Report.xls that is stored on the Internet at the location
named example.microsoft.com/report and displays the
text "Click for report":
=HYPERLINK ("http://example.microsoft.com/report/budget
report.xls", "Click for report")
The following example creates a hyperlink to cell F10 on
the worksheet named Annual in the workbook Budget
Report.xls, which is stored on the Internet at the location
named example.microsoft.com/report. The cell on the
worksheet that contains the hyperlink displays the contents
of cell D1 as the jump text:
=HYPERLINK ("[http://example.microsoft.com/report/budget
report.xls]Annual!F10", D1)
(B)Save a Word document as a Web page:-
To save a word document as a web page following steps are
involved.
1. On the File menu, click Save as Web Page.
2. If you want to save the document in a different
folder, locate and open the folder.
3. In the File name box, type a name for the document.
4. Click Save
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What do stl stand for?
What are the components of stl?
Is string part of stl?
write a program to convert a decimal number in to its equivalent binary number?
Here are the questions and paper pattern from a Birlasoft previous placement paper held at Kolkata, West Bengal. There are two sections 1. Technical questions - 20 2. Aptitude questions - 25 Birlasoft Technical Multiple Choice Questions: Largest integer can be written from 8 bits is a. 256 b. 255 c. 8 d. 10 Change a hexadecimal no to octal How many address lines needed to pass 1MB of data. What is the function of the modulus operator in most language. a) Sets a system environmental value to either base 10 ,base 8 or base 16 b) Returns the remainder after dividing one number by another c) Returns the first argument raised to the second argument power d) Prints out the actual code written to standard output rather than executing the code class professor{} class teacher: public virtual professor{}; class researcher: public virtual professor {} class myprofessor :public teacher,public researcher {}; Referring to the sample code above ,if an object of class myprofessor were created ,how many instances of professor will it contain? a) 0 b) 1 c) 2 d) 3 Modern RDBMS s perfom the following the following functionc except _______. a) Force column values in one table to match any of the values in a column of another table b) Automatically replicate data on another server c) Automatically create new indexes based on query history d) Prevent unauthorized users from accessing data at the firls level RDBMS triggers are typically bound to a _________and one or more a) Table,SQL statement types b) SQL statement type,user c) Column,rows d) User, table What relationship is resolved by an intersecting or associative entity ? a) Recursive b) Mandatory one to one c) Many to Many d) One to One Make a copy of file upper in the directory two levels up . a) jump -2 upper b) cp upper ../..(answer) c) cp upper -2/ d) None of the above i = 0; j = 0; for(j=1;j<10;j++) i=i+1; In the (generic) code segment above what will be the value of the variable i at completion ? a) 0 b) 1 c) 3 d) 9 e) 10 Which of the following statements is true when a derivation inherits both a virtual and non-virtual instance of a base class ? a) Each derived class object has base objects only from the non virtual instance b) Each base class object has derived objects only from the non-virtual instance c) Each derived class object has base objects only from the virtual instance d) Each derived class object has a base object from the virtual instance and a base object from non-virtual instance. class Word { public: Word(const char*,int = 0); }; Referring to the sample code above what is the minimum number of arguments required to call the constructor ? a) 0 b) 1 c) 2 d) 3 What is the function of the modulus operator in most languages ? a) Sets a system environmental value to either base 10 ,base 8 or base 16 b) Returns the remainder after dividing one number by another c) Returns the first argument raised to the second argument power d) Prints out the actual code written to standard output rather than executing the code lass professor{} class teacher: public virtual professor{}; class researcher: public virtual professor {} class myprofessor :public teacher,public researcher {}; Referring to the sample code above ,if an object of class ? myprofessor? were created ,how many instances of professor will it contain? a) 0 b) 1 c) 2 d) 3 Modern RDBMS?s perfom the following the following functionc except a) Force column values in one table to match any of the values in a column of another table b) Automatically replicate data on another server c) Automatically create new indexes based on query history d) Prevent unauthorized users from accessing data at the firls level Which is not the characteristics of a view ? a) Consumes Disk space for data b) Multiple tables c) Multiple rows d) Updateable Technical Questions for computer science engineering students placement paper - cse branch tech / technical interview and written test paper questions from sql, rdbms, queries, c language, programming, etc. The questions are multiple choice / objective type. RDBMS triggers are typically bound to a ________and one or more ________ a) Table,SQL statement types b) SQL statement type,user c) Column,rows d) User, tables What relationship is resolved by an ?intersecting? or ? associative? entity ? a) Recursive b) Mandatory one to one c) Many to Many d) One to One Make a copy of file ?upper? in the directory two levels up . a) jump -2 upper b) cp upper ../.. c) cp upper -2/ d) None of the above Birlasoft Aptitude Section Questions: Question like A is engg. B is doctor C is artist etc then few condition related to them you have give answer to 4 or 5 qs on these conditions . same as above with different data and conditions. 3 qs onfinding error in english sentences If father is three times as old as son . 5 years ago he was 4 times age of his son what is son age. Same as above but now daughter and mother joined in and age in question is that of daughter. A figure is given find no of traingles in this figure Same as above but figure is diffrent and find no of squares and triangles. See other latest free online Birlasoft India placement exam test papers here with technical hr interview candidate real experiences from all over india - submitted by college freshers and company campus recruitment drives.
Is stl open source?
What is stl language?
what is template and type convertion
please visit this site you'll find my question this is my homework please answer it if you can http://easyscience.org/ib/lofiversion/index.php/t36168.html
What does stl stand for in basketball?
Why should a c++ programmer be interested in stl?
To modify an, existing worksheet. What steps are involved for: 1. Inserting and deleting rows and columns. 2. Printing cell formulas 3Jld displayed values 3. Using the page setup command
What is a stl vector?
How stl is different from the c++ standard library?
What is a standard template library (stl)?
