Q. Getting data from a cell located in a different sheet is called ......

View solution

Q. Which of the following is not a valid data type in Excel?

View solution

Q. Which elements of a worksheet can be protected from accidental modification?

View solution

Q. A numeric value can be treated as label value if ...... precedes it.

View solution

Q. Concatenation of text can be done using

View solution

Q. Which area in an Excel window allows entering values and formulas?

View solution

Q. Multiple calculations can be made in a single formula using .......

View solution

Q. An Excel Workbook is a collection of .......

View solution

Q. What do you mean by a Workspace?

View solution

Q. MS-EXCEL is based on .........?

View solution

Q. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

View solution

Q. To select an entire column in MS-EXCEL, press?

View solution

Q. To return the remainder after a number is divided by a divisor in EXCEL we use the function?

View solution

Q. Which function is not available in the Consolidate dialog box?

View solution

Q. Which is not the function of “Edit, Clear” command?

View solution

Q. Microsoft Excel is a powerful ...........

View solution

Q. How do you rearrange the data in ascending or descending order?

View solution

Q. Which Chart can be created in Excel?

View solution

Q. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?

View solution

Q. What happens if you press Ctrl + Shift + F8?

View solution