Ask Question
Computers & TechnologyComputers & Technology
25 January, 16:26

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

=SUM (F2:F5, Sheet2A10)

SUM (F2:F5, Sheet2! A10)

=SUM (F2:F5, ISheet2A10)

O ESUM (F2:F5,_Sheet2A10)

+1
Answers (1)
  1. 25 January, 16:49
    0
    =SUM (F2:F5, Sheet2! A10)

    Explanation:

    There is an error in all the options, = SUM (F2:F5, Sheet2A10) this is the more and less correct.

    If we want to make a reference on another worksheet, Anna has to add the symbol!, between the worksheet's name and the cell that wants to make the reference.

    If we don't add the symbol = at the beginning is not a formula.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation? =SUM (F2:F5, Sheet2A10) ...” 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
Which type of architecture recognizes that the VPN is vulnerable to attack if placed directly in the Internet, and therefore places the Internet-facing VPN connection behind a firewall?
Answers (1)
Which company invented the Android operating system? Apple Nokia Google Microsoft'
Answers (2)
You are setting up a desktop computer for an AutoCAD specialist who needs a minimum of 125GB of RAM. Which operating system below would be best-suited for his needs?
Answers (1)
Your time machine is capable of going forward in time up to 24 hours. the machine is configured to jump ahead in minutes.
Answers (1)
Which css property configures multiple lines in a flex container?
Answers (1)
New Questions in Computers & Technology
What type of operating system allows two or more programs or apps to reside in memory at the same time?
Answers (1)
Select the examples that best demonstrate likely employers for Journalism and Broadcasting workers. Check all that apply. a telecommunications company a radio station a newspaper a television network a movie studio a publishing company
Answers (1)
Which of the following is considered an IT career
Answers (1)
Implement a Python function with the signature Transfer (S, T) that transfers all elements from the ArrayStack instance S onto the ArrayStack instance T, so that the element that starts at the top of S is the first to be inserted onto T, and the
Answers (1)
Writing a story with a proper sequence and orginization is important because what?
Answers (2)
Home » Computers & Technology » Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation? =SUM (F2:F5, Sheet2A10) SUM (F2:F5, Sheet2! A10) =SUM (F2:F5, ISheet2A10) O ESUM (F2:F5,_Sheet2A10)
Sign Up Forgot Password?