Explain how to insert a hyperlink in to an Excel worksheet
and save a Word document as a Web page.



Explain how to insert a hyperlink in to an Excel worksheet and save a Word document as a Web page...

Answer / 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

More STL Interview Questions

How stl is different from the c++ standard library?

0 Answers  


Describe the My Computer and My Documents folders; identify the elements that are present in every Window.

0 Answers  


write a program to search and display the position of an element in a single-dimentional array using function.

1 Answers  


a program using one dimensional array that searches a number if it is found on the list of given input numbers given by the user and locate its exact location in the list.

0 Answers  


Is there any error below, its a code to delete all entires from a map #include <map> #include iostream.h int main() { int i =0; map <int, char> TestMap; while(i<3) { TesMap.insert(TestMap::value_type(i,Test)); i++; } typedef map<int, char> :: iterator mapIter =TestMap.begin(); if(mapIter!=TestMap.end()) { TestMap.erase(mapItrer); ++mapIter; } return 0; }

0 Answers  






Assume I have a linked list contains all of the alphabets from "A" to "Z?" I want to find the letter "Q" in the list, how does you perform the search to find the "Q?"

2 Answers  


write a program to convert a decimal number in to its equivalent binary number?

0 Answers  


Write a program in C++ to concatenate two strings into third string using pointers

5 Answers  


What are the different types of stl containers?

0 Answers  


draw a flowchart that accepts two numbers and checks if the first is divisible by the second.

0 Answers   Appin, NIIT,


Diffrernce Between Overloading and Overriding?

2 Answers   Wipro,


What is meant by stl in c++?

0 Answers  


Categories