FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Button that appears after using the fill handle to copy cell contents
A
Auto Fill Option Button
B
Paste Options Button
C
Formula Auto Complete
D
Auto Fill
Explanation: 

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?

There is 1 question to complete.
Previous
Next