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
You have a new application that is taking full advantage of the features of your smartphone, including the touch screen and an embedded gps receiver. what kind of application is this?
Answers (1)
About how long did it take to photograph Daguerre's photograph of the street?
Answers (1)
Which source is not valid for a Lookup list? query table custom list report
Answers (1)
You have been asked to write a two-page report that explains the extent to which the IT department can configure the cryptographic features of Word 2010. What is the process involved in configuring encryption?
Answers (1)
A 2-dimensional 3x3 array of ints, has been created and assigned to tictactoe. Write an expression whose value is true if the elements of the diagonal that includes the first element of the first row are all equal.
Answers (1)
New Questions in Computers & Technology
To ignore all tracked changes in a document you should select the
Answers (1)
Windows live skydrive is an example of what storage
Answers (1)
A variable must have its type declared but it is not required to be initialized prior to first use. a) TRUE b) FALSE
Answers (1)
Se dau lungimile a N cuvinte (0 < N ≤ 5 000), formate din cel puțin un caracter. Să se afișeze lungimea minimă necesară R a unui rând dintr-o pagină, astfel încât pe fiecare rând lungimea cumulată a cuvintelor să fie exact R (fără spații între ele).
Answers (1)
My iPod won't turn on ... and its 100% charged how do I fix it?
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?