DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
External data
|
|
|
Imported content
|
|
|
Matching sheets
|
|
|
Exported files
|
|
|
Access database
|
Detailed explanation-1: -Imported content in a worksheet that originated in another program or format is called: External Data. An Excel command that recognizes a pattern and duplicates it is: Flash Fill.
Detailed explanation-2: -Importing data refers to the task of obtaining data from another Excel worksheet file.
Detailed explanation-3: -Arranging data in a specific order is called Sorting.
Detailed explanation-4: -Excel Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identifies a pattern.
Detailed explanation-5: -Import data from ClassSchedule table in the Registration Access database into a new worksheet. On the Data tab, in the Get and Transform group, click the Get Data button. Point to From Database, and click From Microsoft Access Database. Click the Registration database file, and then click the Import button.