USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When creating a table in Excel, what will clicking the drop-down arrows in the headings allow you to do?
|
|
Filter the data
|
|
|
Format the cells
|
|
|
Fill the column with color
|
|
|
Hide the column
|
Explanation:
Detailed explanation-1: -Show or hide the Header Row On the Home tab on the ribbon, click the down arrow next to Table and select Toggle Header Row. Click the Table Design tab > Style Options > Header Row.
Detailed explanation-2: -Use the AutoFilter feature to find, show, or hide values-in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don’t meet the filtering criteria.
There is 1 question to complete.