1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
san4es73 [151]
3 years ago
12

How can you best integrate a website into a excel spreadsheet and allow it to link back to the website

Computers and Technology
1 answer:
Ivahew [28]3 years ago
8 0
To import and connect a website in an Excel sheet, you can do as these:

1. Click Data > From Web.
doc import connect website 1

2. Then in the New Web Query dialog, type the website address you want to import into Address textbox, and click Go to display the website.
doc import connect website 2

3. Click Import, and the Import Data dialog pops out for selecting a cell or a new sheet to place the webpage content. See screenshot:
doc import connect website 3

4. Click OK. Now all webpage content excluding images have been imported in the sheet.
doc import connect website 4

5. Then select the whole worksheet, and then click Data > Properties in the Connections group. See screenshot:
doc import connect website 5

6. In the External Data Range Properties dialog, check the options as you need in Refresh control section and click OK.
doc import connect website 6

7. Also you can refresh the sheet contents by manually clicking on Refresh All > Refresh All/Refresh.
You might be interested in
Yall like portal 1 or 2
balu736 [363]

yessir i like 2 better cause the plot is better

8 0
3 years ago
You wish to enter your exam scores in a spreadsheet. Which function will help you find how each subject’s score relates to the o
tester [92]

Answer:

Its the VLookup and the HLOOKUP.

Explanation:

And it depends upon the manner in which the marks are mentioned. If they are mentioned in row then we use Hlookup, and if in columns then we use vlookup.

And the syntax for vlookup is :

vlookup(lookup value, range containing the lookup value, column number in range containing the return value, approximate 0 or exact value 1)

8 0
3 years ago
_________ is the most popular high-level Java API in Hadoop Ecosystem. Cascading Scalding Cascalog None of the options
pochemuha

Answer:

The answer is Cascading

8 0
3 years ago
Dialogue is not a characteristic of functional text because...
kumpel [21]
It is b,<span>dialogue it's speech between characters, and there are no characters and functional text </span>
4 0
3 years ago
EIPP:________.
nikdorinn [45]

Answer:

D. All of these choices are correct

Explanation:

Electronic invoice presentment and payment, otherwise known as EIPP are business-to-business systems that combine e-invoicing and e-payment processes for the purpose of sending invoices to customers via Web portal or via a secure network by the use of a third party service provider. They are also used for receiving payer-initiated, third-party-processed, and ACH-network-settled wire transfers.

4 0
3 years ago
Read 2 more answers
Other questions:
  • Look at the following form. Which input method is the form using to receive the user's favorite activity? What is your favorite
    12·2 answers
  • What will happen if Sam goes to the View menu, clicks Toolbars, and then clicks Picture?
    12·2 answers
  • Write a function shampoo_instructions() with parameter num_cycles. If num_cycles is less than 1, print "Too few.". If more than
    7·1 answer
  • When performing conflict management, it is important to identify your;
    6·1 answer
  • Dit View
    5·2 answers
  • The memory unit of a computer has 256k words of 32 bits each. The computer has an instruction format with 4 fields: an opcode fi
    15·1 answer
  • A customer has a computer for a home business, but wants to have another computer as a web server. What would be the best soluti
    11·2 answers
  • A website for a certain political party or candidate is likely to have unbiased
    6·1 answer
  • Write Tic tac toe program in python for beginners pls
    10·1 answer
  • 30 Points!!
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!