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.
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
How many characters can be typed in a single cell in Excel?
While Finding and Replacing some data in Excel, which of the following statement is valid?
To delete an embedded objects, first
You can copy data or formulas
You can auto fit the width of column by
A worksheet range is a
Which of the following is an absolute cell reference?
When a label is too long to fit within a worksheet cell, you typically must
Which button do you click to add up a series of numbers?
Which of following is Not one of Excels what-if function?
Which function is not available in the Consolidate dialog box?
What are the tabs that appear at the bottom of each workbook called?
The Name box on to the left of formula bar
Which of the following formulas is not entered correctly?
What is the short cut key to replace a data with another in sheet?
You can use the formula palette to
To record a sequence of keystrokes and mouse actions to play back later we use:
Each excel file is called a workbook because
Which area in an excel window allows entering values and formulas
The command Edit >> Fill Across Worksheet is active only when
Documentation should include
Which of the following series type is not valid for Fill Series dialog box?
Where can you change automatic or manual calculation mode in Excel?
Where can you set the shading color for a range of cells in Excel?
How do you insert a row?
You can select a single range of cells by
You can use drag-and-drop to embed excel worksheet data in a word document
The autofill feature
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter