USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The difference between cells and tables in Ms. Excel is____
|
|
data type
|
|
|
sort function
|
|
|
Border
|
|
|
Color
|
Explanation:
Detailed explanation-1: -The SORT function sorts the contents of a range or array. In this example, we’re sorting by Region, Sales Rep, and Product individually with =SORT(A2:A17), copied across cells F2, H2, and J2.
Detailed explanation-2: -In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.
Detailed explanation-3: -In contrast to the SORT function, the SORTBY function allows users to sort data at multiple levels. You can define multiple arrays and sort orders within the same formula to have your data organized at multiple levels.
There is 1 question to complete.