Ask Question
Computers & TechnologyComputers & Technology
17 September, 18:52

What character is used to separate the sheet name from the cell address within a formula containing a sheet reference?

+1
Answers (1)
  1. 17 September, 19:10
    0
    The character used to separate the sheet name from the cell addres within a formula containing a sheet reference is!

    For example:

    Formula without sheet reference: = A1.

    Formula with reference to another sheet in the same book: = Sheet1! A1

    Formula with reference to a sheet in other book: = = '[Name_of_the_sheet]'! A1

    That character is inserted automately so you do not have to write it.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What character is used to separate the sheet name from the cell address within a formula containing a sheet reference? ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
You want to deploy a software package that's available to all users in the domain if they want to use it, but you don't want the package to be installed unless a user needs it. How should you configure the software installation policy
Answers (1)
Which C99 function can be used to convert a string to a double?
Answers (1)
You have a large company, and it is important to your business that your employees' work is backed up regularly. Which network would provide you with the most security? Centralized Client server GUI Peer-to-peer
Answers (1)
Frances is rearranging her furniture. (1) Also, she is moving the heavy oak bookcase to the back bedroom. (2) She has decided to put the coat rack by the front door. (3) In the living room, Francis is moving the sofa against the west wall.
Answers (2)
Oracion con punto focal
Answers (1)
New Questions in Computers & Technology
Which statement about the Sun is correct? O A. Some of the waves that the Sun gives off is in the form of water. O B. Some of the energy that the Sun gives off is in the form of light. O C.
Answers (1)
What is the model for 2017 Ford Mustang v6
Answers (1)
Write the definition of a function reverse, whose first parameter is an array of integers and whose second parameter is the number of elements in the array. The function reverses the elements of the array. The function does not return a value.
Answers (1)
Which is a real-world example of a procedure?
Answers (1)
When compared to traditional desktop customers, why are mobile phone users much more likely to book a room or airline reservation for the same day?
Answers (1)
Home » Computers & Technology » What character is used to separate the sheet name from the cell address within a formula containing a sheet reference?
Sign Up Forgot Password?