How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
You can check the conditions against __________ when applying conditional formatting
You can check the conditions against __________ when applying conditional formatting
Which menu option can be used to split windows into two?
Which menu option can be used to split windows into two?
What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?
What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?
While Finding and Replacing some data in Excel, which of the following statement is valid?
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can auto fit the width of column by
You can auto fit the width of column by
MS-EXCEL is based on .........?
MS-EXCEL is based on .........?
Which of the following you can paste selectively using Paste Special command?
Which of the following you can paste selectively using Paste Special command?
To remove the content of selected cells you must issue ______ command
To remove the content of selected cells you must issue ______ command
In the formula, which symbol specifies the fixed columns or rows?
In the formula, which symbol specifies the fixed columns or rows?
Which key do you press to check spelling?
Which key do you press to check spelling?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
How do you display current date only in MS Excel?
How do you display current date only in MS Excel?
Which of the following series type is not valid for Fill Series dialog box?
Which of the following series type is not valid for Fill Series dialog box?
Comments can be added to cells using ......
Comments can be added to cells using ......
-
-
-
-
Where can you change automatic or manual calculation mode in Excel?
Where can you change automatic or manual calculation mode in Excel?
Which is not the function of "Edit, Clear" command?
Which is not the function of "Edit, Clear" command?
We can save and protect the workbook by
We can save and protect the workbook by
What are the tabs that appear at the bottom of each workbook called?
What are the tabs that appear at the bottom of each workbook called?
What is the correct way to refer the cell A10 on sheet3 from sheet1?
What is the correct way to refer the cell A10 on sheet3 from sheet1?
Which of the cell pointer indicates that you can fill series?
Which of the cell pointer indicates that you can fill series?
To select an entire column in MS-EXCEL, press?
To select an entire column in MS-EXCEL, press?
The active cell:
The active cell:
Which of the following is not the correct method of editing the cell content?
Which of the following is not the correct method of editing the cell content?
Concatenation of text can be done using
Concatenation of text can be done using
You can move a sheet from one workbook into new book by
You can move a sheet from one workbook into new book by
Which tool you will use to join some cells and place the content at the middle of joined cell?
Which tool you will use to join some cells and place the content at the middle of joined cell?
What happens when you press Ctrl + X after selecting some cells in Excel?
What happens when you press Ctrl + X after selecting some cells in Excel?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Microsoft Excel is a powerful ...........
Microsoft Excel is a powerful ...........
When a row of data is to be converted into columns
When a row of data is to be converted into columns
How do you rearrange the data in ascending or descending order?
How do you rearrange the data in ascending or descending order?
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
Which command will you choose to convert a column of data into row?
Which command will you choose to convert a column of data into row?
What does COUNTA () function do?
What does COUNTA () function do?
It is acceptable to let long text flow into adjacent cells on a worksheet when
It is acceptable to let long text flow into adjacent cells on a worksheet when
Which of the following methods cannot be used to enter data in a cell
Which of the following methods cannot be used to enter data in a cell
In help menu of Excel, which of the following tabs are found?
In help menu of Excel, which of the following tabs are found?
Which language is used to create macros in Excel?
Which language is used to create macros in Excel?
What do you mean by a Workspace?
What do you mean by a Workspace?
To record a sequence of keystrokes and mouse actions to play back later we use:
To record a sequence of keystrokes and mouse actions to play back later we use:
The short cut key Ctrl + R is used in Excel to
The short cut key Ctrl + R is used in Excel to
How can you show or hide the gridlines in Excel Worksheet?
How can you show or hide the gridlines in Excel Worksheet?
How many worksheets can a workbook have?
How many worksheets can a workbook have?
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Ctrl + D shortcut key in Excel will
Ctrl + D shortcut key in Excel will
Getting data from a cell located in a different sheet is called ......
Getting data from a cell located in a different sheet is called ......
Which of the cell pointer indicate that you can move the content to other cell?
Which of the cell pointer indicate that you can move the content to other cell?
Which of the following is invalid statement?
Which of the following is invalid statement?
Which of the following is not a term of MS-Excel?
Which of the following is not a term of MS-Excel?
Long text can be broken down into many lines within a cell. You can do this through
Long text can be broken down into many lines within a cell. You can do this through
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
The first cell in EXCEL worksheet is labeled as
The first cell in EXCEL worksheet is labeled as
What is the short cut key to replace a data with another in sheet?
What is the short cut key to replace a data with another in sheet?
A numeric value can be treated as label value if ...... precedes it.
A numeric value can be treated as label value if ...... precedes it.
How do you display current date and time in MS Excel?
How do you display current date and time in MS Excel?
The Cancel and Enter buttons appear in the:
The Cancel and Enter buttons appear in the:
You can use the formula pallette to
You can use the formula pallette to
When a range is selected, how can you activate the previous cell?
When a range is selected, how can you activate the previous cell?
The spelling dialog box can be involved by choosing spelling from ________ menu.
The spelling dialog box can be involved by choosing spelling from ________ menu.
Which of the following is not true about Find and Replace in Excel
Which of the following is not true about Find and Replace in Excel
Where can you set the shading color for a range of cells in Excel?
Where can you set the shading color for a range of cells in Excel?
Which of the following is not true regarding Conditional Formatting?
Which of the following is not true regarding Conditional Formatting?
Which of the following is not a valid data type in Excel?
Which of the following is not a valid data type in Excel?
A __________ is a grid with labeled columns and rows.
A __________ is a grid with labeled columns and rows.
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Which area in an Excel window allows entering values and formulas?
Which area in an Excel window allows entering values and formulas?
How do you wrap the text in a cell?
How do you wrap the text in a cell?
Tab scroll buttons are place on Excel screen
Tab scroll buttons are place on Excel screen
An Excel Workbook is a collection of .......
An Excel Workbook is a collection of .......
The Delete key of keyboard is assigned to which command in Excel?
The Delete key of keyboard is assigned to which command in Excel?
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Multiple calculations can be made in a single formula using .......
Multiple calculations can be made in a single formula using .......
The Name box on to the left of formula bar
The Name box on to the left of formula bar
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
In Excel, the Fill Color button on the Formatting toolbar is used for what?
In Excel, the Fill Color button on the Formatting toolbar is used for what?
MS Excel provides the default value for step in Fill Series dialog box
MS Excel provides the default value for step in Fill Series dialog box
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?
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?
Which of the following action removes a sheet from workbook?
Which of the following action removes a sheet from workbook?
Which Chart can be created in Excel?
Which Chart can be created in Excel?
How can you remove borders applied in cells?
How can you remove borders applied in cells?
What is the short cut key to highlight the entire column?
What is the short cut key to highlight the entire column?
Which function is not available in the Consolidate dialog box?
Which function is not available in the Consolidate dialog box?
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
Which of the following option is not available in Paste Special dialog box?
Which of the following option is not available in Paste Special dialog box?
Which would you choose to create a bar diagram?
Which would you choose to create a bar diagram?
Excel displays the current cell address in the ........
Excel displays the current cell address in the ........
Edit >> Delete command
Edit >> Delete command
Which of the cell pointer indicates you that you can make selection?
Which of the cell pointer indicates you that you can make selection?
In Excel, a Data Series is defined as what?
In Excel, a Data Series is defined as what?
What is represented by the small, black square in the lower-right corner of an active cell or range?
What is represented by the small, black square in the lower-right corner of an active cell or range?
The command Edit >> Fill Across Worksheet is active only when
The command Edit >> Fill Across Worksheet is active only when
B7:B9 indicates:
B7:B9 indicates:
Which elements of a worksheet can be protected from accidental modification?
Which elements of a worksheet can be protected from accidental modification?
Which setting you must modify to print a worksheet using letterhead?
Which setting you must modify to print a worksheet using letterhead?
You can set Page Border in Excel from
You can set Page Border in Excel from
Which of the following Excel screen components can NOT be turned on or off?
Which of the following Excel screen components can NOT be turned on or off?
