Câu 25: 70-779: Analyzing and Visualizing Data with Microsoft Excel

DRAG DROP -You have a workbook query that retrieves data from a table named Users. Users contains a column named PhoneNumber. The following is a sample of the data in PhoneNumber.514 555 01601 (11) 500 555-0122128 555-0148819 555-01861-996-555-0192+1 138-555-0156556-555-0192You need to create a custom column that contains the data in PhoneNumber in the format of 999-999-9999. The following is a sample of the desired data.514-555-0160500-555-0122128-555-0148819-555-0186996-555-0192138-555-0156556-555-0192How should you complete the Query Editor formula? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point. Select and Place:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại