Mike looks at Imelda's files and sees that she was using four different spreadsheets to record production line and employee information. Mike immediately recognizes he can save time entering data if he were to integrate the sheets and use the software to print an automated report. Mike has experience integrating spreadsheets and does not need any technical advice.

Should Mike work on the spreadsheets and if so, how should he do it? How should Mike proceed?

Question

Tango

Business

5 April, 20:12

Mike looks at Imelda's files and sees that she was using four different spreadsheets to record production line and employee information. Mike immediately recognizes he can save time entering data if he were to integrate the sheets and use the software to print an automated report. Mike has experience integrating spreadsheets and does not need any technical advice.

Should Mike work on the spreadsheets and if so, how should he do it? How should Mike proceed?

+2

Answers (1)

Know the Answer?

Zion Livingston · Answer 1

Yes, he should do it.

Explanation:

Mike can integrate the different spreadsheet by following the steps below:

step 1 : Start creating a formula that will include a value from a cell or cell range on another worksheet.

Step 2: Click the sheet tab of the worksheet with the cell or cell range you want to include in the formula.

step 3: Select the cell or cells to include in the formula.

Press Enter.