To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
To create a formula, you can use:
Which of the following is not the correct method of editing the cell content?
You can use the formula pallette to
Which setting you must modify to print a worksheet using letterhead?
You can use the format painter multiple times before you turn it off by
A typical worksheet has . Number of columns
You can check the conditions against __________ when applying conditional formatting
In help menu of Excel, which of the following tabs are found?
Right clicking something in Excel:
How can you delete a record?
Documentation should include
To view a cell comment
Microsoft Excel is a powerful ...........
Which area in an excel window allows entering values and formulas
Which of the following methods cannot be used to enter data in a cell
Which function is not available in the Consolidate dialog box?
Which of the following is not a valid data type in Excel?
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Which of the following is the latest version of Excel
MS-EXCEL is based on .........?
A __________ is a grid with labeled columns and rows.
Which of the following formulas will Excel Not be able to calculate?
Ctrl + D shortcut key in Excel will
To remove the content of selected cells you must issue ______ command
Which of the following Excel screen components can NOT be turned on or off?
Which of the following is not a way to complete a cell entry?
How do you wrap the text in a cell?
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter