USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select cell N39, formulas tab, function library group, insert function, search Vlookup
|
|
|
Select cell N38, formulas tab, function library group, insert function, search Vlookup
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -In the Employee Records worksheet, in cell F7, add a function that counts how many people work in the Maine office. Click the Employee Records worksheet and select cell F7. In the Formulas tab, locate the Function Library group and select Insert Function.
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.
Detailed explanation-3: -The median of a data set is the middle value when the values are written in numerical order. If a data set has an even number of values, the median is the mean of the two middle values.
Detailed explanation-4: -Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found.