Interested to Buy Any Domain ? << Click Here >> for more details...
Explain how to insert a hyperlink in to an Excel worksheet
and save a Word document as a Web page.
- 1 Answers
- 6954 Views
- I also Faced
- E-Mail Answers
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 |
Name the different types of stl containers.
how to making game in c++ ?
What is a list in c++ stl?
What is stl language?
What is stl in c++ with example?
Give the output of the following program main() {char *p='a'; int *i=100/*p; } what will be the value of *i= 1
How the STL's are implemented, What the difference between templates and STL?
What do stl stand for?
Question 1)Read the data from one file and remove all the duplicated words and generate an output file containg only using words.Program should also print number of occurance of each words on standard output.(Program must be use STL and iostream object). Question 2)Write a program to convert the lower case contents of file to upper case using STL. Question 3)What is the output of this problem. int i=12; int &r =i; r+r/4; int +p =&r; int *p = &r; P+=r; return 1; Answer :a)12 b)17 c) 30 d)24 E)15 Question 4) #include #include #include void main() { char srcstr[30],desstr[30]; int i,len; clrscr(); cout<<"\nenter the string\n"; cin>>srcstr; len=strlen(srcstr); for(i=0;srcstr[i]!='\0';i++) { desstr[--len]=srcstr[i]; } desstr[i]='\0'; cout<<"\nreversed string is\n"; for(i=0;desstr[i]!='\0';i++) { cout< } getch(); } Answer : A) string output b)tuptuo gnirts c) string d)output Question 5) Class Test { static const Tk=LEN; int q; public: foo(intx =LEN):q(x){}; TGet Q() const { return q:} void call test Foo<long :9> foo(10); std::const<< foo.Getq(); Answer: 7,8,9,10,11 question 6) class A { int a; char b; }; class B:public A { char b; int a; }; What is the size? Answer a)5 bytes for class A and 5 bytes class B b)4 bytes for class A and 8 bytes class B. c).... d)....
what is electronic software
i wanted to know about questions about c,c++ , which is required for placements.... im a fresher
why we are using the fork command?.. how it works?
STL 
