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?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
Correct Answer :
A. Custom List
Related Questions
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
How many worksheets can a workbook have?
3
8
255
none of above
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which symbol must all formula begin with?
=
+
(
@
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
To view a cell comment
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
When you insert an excel file into a word document. The data are
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells