Microsoft Exam MOS-E2E – Excel 2000 Expert

Microsoft Exam Excel 2000 Expert

Description of the document:

Exam : MOS-E2E
Title : Excel 2000 Expert
Ver : 02.13.07


Example Questions out of 30 Questions:

QUESTION 1:
Import the tab-delimited text file “Spare parts” from the C:\ Certkiller \MyDocuments.

Answer:

Step 1: Click Data->Get External Data->Import Text File. Navigate to C:\ Certkiller \MyDocuments
Step 2: Select the Spare parts text file and click Import. Click Next twice.
Step 3: Click Finish.
Step 4: Select Existing Worksheet. Click OK

 

QUESTION 2:
Create a new database query that will import the “Prices by Manufacturer” query from the “Car tracker” database in the C:\ Certkiller \MyDocuments folder. Return the data to the current worksheet.

Answer:

Step 1: Choose Data->Get External Data->New Database Query.
Step 2: On the Databases tab, select MS Access Database. Click OK.
Step 3: Select the CarTracker.mdb database. Click OK.
Step 4: In the Available tables and column list, select Prices by Manufacturer. Click the > button.
Step 5:.Click Next three times.
Step 6: Select Return Data to Microsoft Excel. Click Finish. Select Existing worksheet and click OK.

Download Microsoft Exam MOS-E2E – Excel 2000 Expert:

» Download Link



Kata pencarian untuk artikel ini: makalah microsoft excel, artikel microsoft excel
PERHATIAN: Harap download file TANPA DOWNLOAD MANAGER karena kemungkinan besar akan gagal. Jika tidak bisa download via alternatif link, silakan dicoba kembali.

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *