FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?
A
Convert Text to Column Wizard
B
Split View
C
View Side-by-Side
D
Comma Delimited
Explanation: 

Detailed explanation-1: -The most commonly used way to select multiple cells is to click and drag. You need to click on a cell and drag it over the spreadsheet. Press on a cell.

Detailed explanation-2: -Using the Fixed-Width Method Click on the column letter to highlight the entire column you want to convert. On the Data tab, click on Text to Columns. Click on the Fixed width radio button. Click Next.

Detailed explanation-3: -You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note: Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column.

Detailed explanation-4: -Column: Columns run vertically on the spreadsheet screen. An Excel spreadsheet contains 256 columns that are labeled with the letters of the alphabet.

There is 1 question to complete.
Previous
Next