Câu 11: 77-602: MOS: Using Microsoft Office Excel 2007

You work as a Sales Manager for Media Perfect Inc. You have created a sales report in a workbook in Excel 2007. You want to display the file name with complete path of the current document in A1 cell as shown in the image below: Which of the following steps will you take to accomplish the task?

1. A. Insert the following formula in cell A1: =filename("A1")
2. B. Click the Header & Footer option in the Text group of the Insert tab. Select the Footer section.Click the File Name option in the Header & Footer Elements group of the Design tab.
3. C. Click the Header & Footer option in the Text group of the Insert tab. Select the Header section.Click the File Name option in the Header & Footer Elements group of the Design tab.
4. D. Insert the following formula in cell A1: =cell("filename") — đáp án hiện tại