Q. In MS-Excel all worksheet formula

View solution

Q. How do you display current date only in MS Excel?

View solution

Q. How do you wrap the text in a cell?

View solution

Q. What does COUNTA () function do?

View solution

Q. What is the short cut key to highlight the entire column?

View solution

Q. In the formula, which symbol specifies the fixed columns or rows?

View solution

Q. Excel displays the current cell address in the ........

View solution

Q. What is the correct way to refer the cell A10 on sheet3 from sheet1?

View solution

Q. Which language is used to create macros in Excel?

View solution

Q. Which of the following is not a term of MS-Excel?

View solution

Q. How many worksheets can a workbook have?

View solution

Q. Which would you choose to create a bar diagram?

View solution

Q. Which setting you must modify to print a worksheet using letterhead?

View solution

Q. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

View solution

Q. The spelling dialog box can be involved by choosing spelling from ________ menu.

View solution

Q. Which key do you press to check spelling?

View solution

Q. To record a sequence of keystrokes and mouse actions to play back later we use:

View solution

Q. We can save and protect the workbook by

View solution

Q. The first cell in EXCEL worksheet is labeled as

View solution

Q. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

View solution