DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It is the easiest method to fill data in cells automatically.
|
|
|
It makes entering a long, repetitive series of data faster and less boring.
|
|
|
It allows us to create various types of number series very easily.
|
|
|
It fills different colours in the cells.
|
Detailed explanation-1: -Autofill covers anything from dates, days of the week, to months of the year and more… Excel will automatically fill in the series. this can save so much time and reduce data entry errors. For example, I want to create a quick timetable with the days of the week using Autofill.
Detailed explanation-2: -What is AutoFill? Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.
Detailed explanation-3: -First, make sure that the cells you’re trying to fill are actually selected. If they’re not, the fill color won’t show up. Next, check the fill color palette to see if the color you’re trying to use is actually available. If it’s not, you won’t be able to use it.