USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Fill Handle
|
|
|
Auto Fill
|
|
|
Fast Fill
|
|
|
Flash List
|
Detailed explanation-1: -AutoFill in Excel is quite a time-saving command which automatically fills the value to all selected cells. To use autofill, first select the data which we need to fill down below and then drag the pointer, which is there at the bottom right corner, to all subsequent cells.
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.
Detailed explanation-3: -In Microsoft Excel, AutoFill is a feature that allows the user to extend a series of numbers, dates, or even text to the necessary range of cells. This little option gives you plenty of possibilities. Use Flash Fill in Excel, autofill dates and numbers, populate numerous cells, and get custom list values.
Detailed explanation-4: -AutoFill is one of Excel’s most powerful and useful features. With AutoFill, you can quickly and easily fill in a range of cells with a series of values without entering them one at a time. This tutorial will show you how to use AutoFill in Excel.
Detailed explanation-5: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed.