To add total sales from two worksheets-cell B10 of the Domestic worksheet and cell B8 of the International worksheet-you would enter the formula ____.
A)=Domestic;B10 + International;B8
B)=Domestic"B10 + International"B8
C)=Domestic!B10 + International!B8
D)=Domestic?B10 + International?B8

Question

Quizplus · Accepted Answer

To reference a cell in another worksheet, you need to use the worksheet name followed by an exclamation point(!) before the cell reference. Therefore, the correct formula to add the two cells from different worksheets would be Domestic!B10 + International!B8. Option A, B, and D are incorrect as they either use the wrong punctuation or syntax for referencing cells in another worksheet.

To Add Total Sales from Two Worksheets-Cell B10 of the Domestic