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
- To center worksheet titles across a range of cells, you must
- Which of the following you can paste selectively using Paste Special command?
- To view a cell comment
- Which is not the function of Edit, Clear command?
- You can use the horizontal and vertical scroll bars to
- Text formulas:
- While Finding and Replacing some data in Excel, which of the following statement is valid?
- What does COUNTA () function do?
- Documentation should include
- Which of the following is not a term of MS-Excel?
- When you copy a formula
- MS Excel provides the default value for step in Fill Series dialog box
- Ctrl + D shortcut key in Excel will
- How many worksheets can a workbook have?
- The active cell:
- Which language is used to create macros in Excel?
- How do you rearrange the data in ascending or descending order?
- Which of the following is not a valid data type in excel
- Which of the following is a correct order of precedence in formula calculation?
- Which area in an Excel window allows entering values and formulas?
- You can select a single range of cells by
- When you link data maintained in an excel workbook to a word document
- An Excel Workbook is a collection of .......
- When you want to insert a blank imbedded excel object in a word document you can
- Which of the following is not an example of a value?
- What symbol is used before a number to make it a label?
- Excel probably considers the cell entry January 1, 2000 to be a
- You can move a sheet from one workbook into new book by
- The auto calculate feature
- We can save and protect the workbook by