subject

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,!Sheet2A10) =SUM(F2:F5,_Sheet2A10)

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 00:00
Sam is a data analyst at an advertising firm. he often uses a spreadsheet that contains media ratings details. he would like to filter the spreadsheet data based on different filter criteria. which operators can he use to specify the combination of filter criteria? sam can use the ( blank ) operators to specify a combination of filter criteria.
Answers: 3
question
Computers and Technology, 22.06.2019 06:50
Type the correct answer in the box. spell all words correctly. which view of report creation allows you to customize the report before the database program creates it? creating a report in allows you to customize the report before the database program creates it. pl asap
Answers: 1
question
Computers and Technology, 22.06.2019 15:30
When creating a budget, log fixed expenses before income. after income. after savings. at the top.
Answers: 1
question
Computers and Technology, 22.06.2019 23:30
What are some ways to use a range name in a formula? check all that apply. in the defined names group, click use in formula, and then select the desired name. begin typing the name in the formula, select a name from the autocomplete list, and use the arrow keys and tab key to enter the name in the formula. begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. right-click one of the cells in the range. click formula options, and use the dialog box to add the name.
Answers: 1
You know the right answer?
Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for...
Questions
question
Mathematics, 10.10.2019 16:30
question
Mathematics, 10.10.2019 16:30
question
Business, 10.10.2019 16:30
Questions on the website: 13722362