Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
Also checkout these categories
Phylum - Amphibia MCQ Design of Masonry Structures MCQ Current Affairs April 2017 MCQ Numbers MCQ Adobe Flash MCQ Human reproductive system MCQ Relationship based problems MCQ Compressors, Gas Turbines & Jet Engines MCQ Advanced Surveying MCQ Current Affairs June 2017 MCQ Computer Architecture MCQ Alphabetical Series MCQ
- Which area in an Excel window allows entering values and formulas?
- How do you rearrange the data in ascending or descending order?
- To center worksheet titles across a range of cells, you must
- The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
- Which menu option can be used to split windows into two?
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- Excel displays the current cell address in the ........
- Long text can be broken down into many lines within a cell. You can do this through
- In help menu of Excel, which of the following tabs are found?
- Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
- Which of the following is invalid statement?
- The short cut key Ctrl + R is used in Excel to
- Which would you choose to create a bar diagram?
- Multiple calculations can be made in a single formula using .......
- Excel worksheet cells work very similarly to what common element of the windows graphical user interface
- To remove the content of selected cells you must issue ______ command
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- The autofill feature
- What will be the output if you format the cell containing 5436.8 as #,##0.00'?
- We can save and protect the workbook by
- To return the remainder after a number is divided by a divisor in EXCEL we use the function?
- MS Excel provides the default value for step in Fill Series dialog box
- Which of the cell pointer indicates you that you can make selection?
- Which function is not available in the Consolidate dialog box?
- Multiple calculations can be made in a single formula using
- How do you select an entire column?
- Tab scroll buttons are place on Excel screen
- Which of the following is not a basic step in creating a worksheet?
- What is the short cut key to highlight the entire column?
- To view a cell comment