Ask Question
Computers & TechnologyComputers & Technology
3 June, 07:30

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)

+3
Answers (1)
  1. 3 June, 11:27
    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?
Get 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 there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
There is no way to see how another project in Scratch was made. True False
Answers (1)
The Internet was created by university computer science departments. select one: A) true B) false
Answers (2)
An unauthorized program typically contained within a legitimate program is known as a. Worm. Macro. Trojan. Spartan.
Answers (1)
Let's say that you handle the IT systems administration for your company. There's a server inside of your organization that checks how often client machines access it.
Answers (1)
How do I select cells A3 through F3 in Excel 2013
Answers (1)
New Questions in Computers & Technology
A monochrome monitor produces millions of different colors true or false
Answers (1)
What is the first step in devising security services and mechanisms?
Answers (2)
Identify the correct way to cite the Occupational Outlook Handbook's "How to Become a Dentist" web page. A. Occupational Outlook Handbook. "How to Become a Dentist." Bureau of Labor Statistics and US Department of Labor, 2012. B.
Answers (1)
Design aPayrollclass that has fields for an employee'sname, ID number, hourly pay rate, and number of hours worked. Write theappropriate accessor and mutator methods and a constructor that accepts theemployee's name and ID number as arguments.
Answers (1)
What is the data transmission time, assuming no errors or overhead, to send a 2 GByte file over a link with a 2 Gbps line rate? Remember that the 'G' in GByte and Gbps have slightly different meanings. Round your answer to the nearest 0.
Answers (1)
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?