USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Freezing
|
|
|
Locking
|
|
|
Selecting
|
|
|
Fixing
|
Detailed explanation-1: -Explanation: The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called freezing. To freeze rows: Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.
Detailed explanation-2: -Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
Detailed explanation-3: -The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.
Detailed explanation-4: -A table has records (rows) and fields (columns). Fields have different types of data, such as text, numbers, dates, and hyperlinks.
Detailed explanation-5: -If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.