DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Auto Fill Option Button
|
|
|
Paste Options Button
|
|
|
Formula Auto Complete
|
|
|
Auto Fill
|
Detailed explanation-1: -It’s an irreplaceable part of the AutoFill option. Fill handle is a small square that appears in the bottom-right corner when you select a cell or range.
Detailed explanation-2: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Note: This article explains how to automatically fill values into other cells. It does not explain how to enter data manually or simultaneously across multiple worksheets.
Detailed explanation-3: -After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. In the formula =D1+C1/F3, which calculation will be performed first?