DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
auto fill
|
|
|
fill handle
|
|
|
series
|
|
|
wrap text
|
Detailed explanation-1: -Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
Detailed explanation-2: -The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the following example, we created an array that’s 4 rows tall by 5 columns wide with =SEQUENCE(4, 5).
Detailed explanation-3: -Date(from, to, by, length. out, along. with) to define sequences of dates. The by parameter can be “day”, “week”, “month”, “quarter” or “year” with a positive or negative integer preceding it and a space. Also a number that is taken as days.