Which command will you choose to convert a column of data into row?
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
Which of the following methods can not be used to edit the contents of a cell?
To view a cell comment
You want to track the progress of the stock market on a daily basis. Which type of chart should you…
How many worksheets can a workbook have?
To record a sequence of keystrokes and mouse actions to play back later we use:
Which of the following is not information you can specify using the solver?
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
You can copy data or formulas
Files created with Lotus 1-2-3 have an extension
Which of the following is invalid statement?
What do you call the chart that shows the proportions of how one or more data elements relate to another…
The auto calculate feature
If you need to remove only the formatting done in a range (numbers and formula typed there should not…
Multiple calculations can be made in a single formula using .......
Microsoft Excel is a powerful ...........
Excel files have a default extension of
In help menu of Excel, which of the following tabs are found?
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
Comments put in cells are called .....
To save a workbook, you:
Which of the following is an absolute cell reference?
Which menu option can be used to split windows into two?
MS-EXCEL is based on .........?
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
When you insert an excel file into a word document. The data are
Documentation should include
You can use the formula pallette to
To select an entire column in MS-EXCEL, press?
Which area in an excel window allows entering values and formulas
A worksheet can have a maximum of . Number of rows
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter