You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Auto Fill Options
Fill Across Worksheet
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
The name box
Which function is not available in the Consolidate dialog box?
If you need to remove only the formatting done in a range (numbers and formula typed there should not…
You can use the drag and drop method to
Paste Special allows some operation while you paste to new cell. Which of the following operation is…
How can you find specific information in a list?
The chart wizard term data series refers to
The autofill feature
To view a cell comment
Which of the following series type is not valid for Fill Series dialog box?
If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
Which of the following methods can not be used to edit the contents of a cell?
When you want to insert a blank imbedded excel object in a word document you can
Rounding errors can occur
Which is not the function of Edit, Clear command?
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Which area in an excel window allows entering values and formulas
Which language is used to create macros in Excel?
Which Chart can be created in Excel?
You can edit a cell by
How do you insert a row?
To remove the content of selected cells you must issue ______ command
An excel workbook is a collection of
Which key do you press to check spelling?
The spelling dialog box can be involved by choosing spelling from ________ menu.
You want to track the progress of the stock market on a daily basis. Which type of chart should you…
How can you remove borders applied in cells?ACC
When integrating word and excel, word is usually the
You can use drag-and-drop to embed excel worksheet data in a word document