Computer Science, asked by ss5866177, 8 months ago

What
is the purpose of sheet reference?

Answers

Answered by sumansharma9402

Answer:

you can use INDIRECT with SHEET, to show the sheet numbers in a list of sheet names. The screen shot below shows a menu sheet, with all the sheet names in the workbook. In the adjacent column, this formula calculates the sheet name. =SHEET(INDIRECT("'" & $B3 & "'!Oct 25, 2018

Explanation:

hope this helps

Answered by barthwalkiran4

Answer:

The purpose of sheet reference is it can be used in a formulae related to Microsoft office excel.To find the data and formulae related to calculate it.

MARK ME BRAINLIEST.....

THANK YOU....

Previous Question

Next Question

Similar questions

Math, 4 months ago

1/8 fractional number to percent fr ...

Social Sciences, 4 months ago

द्रव अधातु का नाम व संकेत लिखकर अधातु के तीन रासायनिक गुण लिखिए...

Social Sciences, 4 months ago

B. Match the following: 1. Socrates 2. Abraham Lincoln 3. Mahatma Gandhi (a) President of the USA (b) Communist Manifesto (c) Civil rights activist (d) Plato (e) Hindu-Muslim unity 4. Karl Marx Martin Luther King Jr. 5.

History, 8 months ago