USING MICROSOFT EXCEL
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: -A cell style is a predefined set of formatting options, such as cell borders, fonts, font sizes and number formats. Using cell styles allows you to apply multiple format options in one step and also offers an easy approach to achieve consistency in cell formatting.