ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Programming Languages  >>  C++  >>  STL
 
 


 

 
 STL interview questions  STL Interview Questions
 OOPS interview questions  OOPS Interview Questions
 C++ General interview questions  C++ General Interview Questions
Question
Explain how to insert a hyperlink in to an Excel worksheet 
and save a Word document as a Web page.
 Question Submitted By :: Msansari00
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explain how to insert a hyperlink in to an Excel worksheet and save a Word document as a Web page.
Answer
# 1
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 ?    0 Yes 0 No
Saba
 

 
 
 
Other STL Interview Questions
 
  Question Asked @ Answers
 
write a piece of c++ code which allocate memory to the 50 object of type CObj  2
What is the STL? HP2
Explain how to insert a hyperlink in to an Excel worksheet and save a Word document as a Web page.  1
Give the output of the following program main() {char *p='a'; int *i=100/*p; } what will be the value of *i= 1 Sun-Microsystems3
I am doing my BS.c MATHS CAN I ABLE TO JOIN IN NIIT?  1
What is 2*2?  3
what's the difference between function overloading and function overiding?  2
What is Template Specialization? Lucent1
what is a template? BITS2
Which data structure gives efficient search? A. B-tree B. binary tree C. array D. linked list Sun-Microsystems14
How the STL's are implemented, What the difference between templates and STL? Symphony1
What is Object Oriental Progam  1
What is the disadvantage of templates ? Symphony2
what is an algorithm in terms of STL? Wipro1
how to swap two numbers in a linked list without exchanging the data but only the links? Wipro2
if 4-5 year old brother is standing on d roof with me and watching d moon, suddenly moon coverd by cloud then how will i explain d hiding of moon to my brother. MBT6
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
what's the difference between abstract class and concreate class? what's the meaning of standard template library(STL)?  3
c# support late binding or early binding.  3
Find the error in the following program struct point {struct point *next; int data; } x; main() {int...data; } x; main() {int i; for(x=p;x!=0;) x=x->next,x++; freelist(x); } freelist(x) {free(x); return } Sun-Microsystems1
 
For more STL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com