FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Feature of Excel’s fill function creates a series by multiplying each cell in series by step value.
A
Linear
B
Growth
C
Date
D
Auto Fill
Explanation: 

Detailed explanation-1: -Fill Series is a helpful feature in Excel that improves efficiency in creating spreadsheets. It allows instant filling of values in selected cells based on the intervals, type, units and step values specified by the user.

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.

Detailed explanation-3: -In a growth series, the starting value is multiplied by the step value to get the next value in the series. The resulting product and each subsequent product are then multiplied by the step value.

Detailed explanation-4: -Answer: Excel’s Fill Handle is a cool tool used inside the worksheet. When you select your starting cells and hover the mouse over the lower right corner of the cell range, the Fill Handle, a plus sign, appears.

There is 1 question to complete.
Previous
Next