Microsoft Excel Set-28

271. How do you display current date and time in MS Excel?
     a. date ()
     b. Today ()
     c. now ()
     d. time ()
272. How do you display current date only in MS Excel?
     a. date ()
     b. Today ()
     c. now ()
     d. time ()
273. How do you wrap the text in a cell?
     a. Format, cells, font
     b. Format, cells, protection
     c. format, cells, number
     d. Format, cells, alignment
274. What does COUNTA () function do?
     a. counts cells having alphabets
     b. counts empty cells
     c. counts cells having number
     d. counts non-empty cells
275. What is the short cut key to highlight the entire column?
     a. Ctrl+C
     b. Ctrl+Enter
     c. Ctrl+Space Up
     d. Ctrl+Space Bar
276. In the formula, which symbol specifies the fixed columns or rows?
     a. $
     b. *
     c. %
     d. &
277. Excel displays the current cell address in the ……….
     a. Formula bar
     b. Status Bar
     c. Name Box
     d. Title Bar
278. What is the correct way to refer the cell A10 on sheet3 from sheet1?
     a. sheet3!A10
     b. sheet1!A10
     c. Sheet3.A10
     d. A10
279. Which language is used to create macros in Excel?
     a. Visual Basic
     b. C
     c. Visual C++
     d. Java
280. Which of the following is not a term of MS-Excel?
     a. Cells
     b. Rows
     c. Columns
     d. Document

______________________________________________________________________________________________