A chart on an existing worksheet is an embedded sheet and has no specific name. A chart on its on sheet is known as a chart sheet and will initially have the name Chart1, with Chart2 for the next one, Chart3 for the next one and so on. These names can be changed by the users.
If it is moved to be a chart on its own, that is known as a Chart Sheet, not a worksheet, and its name will be Chart1. A Chart sheet, unlike a worksheet, just has a chart and has no cells. Moving a chart from a worksheet will not affect that worksheet's name. So in this case, it would still be Sheet1. If you move a chart to another worksheet, embedding it there, that does not affect the name of that worksheet. So it could b embedded on Sheet2 or Sheet3 or whatever name may have been given to it.
I believe it is Book1
In Excel it is indicated using the sheet name and the range in an absolute format. For example: =Sheet1!$Q$15:$Q$18 It will be automatically picked up if you select your cells and then insert a chart. You can also enter them manually.
yes
Microsoft Excel will give a default name to a newly created but not yet saved worksheet that is in line with how the rest of the world works. You can save an existing worksheet under a different name. These are the ways experience says will work
name box
A chart or graph.
xlsx
Name box
Right click on the sheet tab and select "Rename" from the menu options. Type your new name.
&[Tab] is the code that is used.
Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21