Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
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 menu option can be sued to split windows into two
You can use the formula pallette to
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
You can convert existing excel worksheet data an charts to an HTML document by using
Which of the following is not an example of a value?
How do you rearrange the data in ascending or descending order?
Which button do you click to add up a series of numbers?
You can check the conditions against __________ when applying conditional formatting
What do you call the chart that shows the proportions of how one or more data elements relate to another…
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
Concatenation of text can be done using
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
Which area in an excel window allows entering values and formulas
How many characters can be typed in a single cell in Excel?
How can you delete a record?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
Getting data from a cell located in a different sheet is called ......
A numeric value can be treated as label value if ...... precedes it.
Which of the following is an absolute cell reference?
When a range is selected, how can you activate the previous cell?
If you need to remove only the formatting done in a range (numbers and formula typed there should not…
Which of the following option is not available in Paste Special dialog box?
Which of the following formulas is not entered correctly?
The spelling dialog box can be involved by choosing spelling from ________ menu.
Excel probably considers the cell entry January 1, 2000 to be a
In help menu of Excel, which of the following tabs are found?
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
MS-EXCEL is based on .........?
You cannot link excel worksheet data to a word document