When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
- Which of the following is not an example of a value?
- We can save and protect the workbook by
- Which of the following is not a way to complete a cell entry?
- Which of the following is the latest version of Excel
- It is acceptable to let long text flow into adjacent cells on a worksheet when
- Which elements of worksheet can be protected from accidental modification
- Which of the following is not a term of MS-Excel?
- In a worksheet you can select
- Files created with Lotus 1-2-3 have an extension
- The Name box on to the left of formula bar
- Which Chart can be created in Excel?
- Which of the following action removes a sheet from workbook?
- How can you print three copies of a workbook?
- Each excel file is called a workbook because
- You can use the formula pallette to
- In the formula, which symbol specifies the fixed columns or rows?
- The Paste Special command lets you copy and paste:
- You can use the format painter multiple times before you turn it off by
- Which of the following is not a basic step in creating a worksheet?
- If you need to remove only the formatting done in a range (numbers and formula typed there should not…
- Documentation should include
- You can auto fit the width of column by
- Excel worksheet cells work very similarly to what common element of the windows graphical user interface
- In Excel, the Fill Color button on the Formatting toolbar is used for what?
- Which of the cell pointer indicate that you can move the content to other cell?
- How can you find specific information in a list?
- Comments can be added to cells using
- To copy formatting from one area in a worksheet and apply it to another area you would use:
- Which is used to perform what if analysis?
- Which button do you click to add up a series of numbers?