USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Create a VLOOKUP function in cell N39 that finds the Bonus (Column 4) in the Employee Data worksheet for the Employee in N35 in the Dashboard worksheet. What do you do first?
|
|
click on the correct worksheet, select N39, formulas tab, function library button, insert function
|
|
|
select N39, formulas tab, function library button, insert function
|
|
|
click on the correct worksheet, select N30, formulas tab, function library button, insert function
|
|
|
all of the above
|
Explanation:
Detailed explanation-1: -In the Yearly Timesheet worksheet, add watches to cells I4, K4, and M4. In the Yearly Timesheetworksheet, in the Formulastab, go to the Formula Auditing group and click Watch Window. In the Watch Window dialog window, click Add Watch. Select cell I4 and click Add.
Detailed explanation-2: -On the Tools menu, click Options. If you use Microsoft Office Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Formulas. On the Error Checking tab or in the Error Checking rules area, ensure that the Formulas referring to empty cells check box is selected. Click OK.
There is 1 question to complete.