Computer : : MS Excel Questions & Answers

  1. 3-D reference in a formula?

A. Spans worksheets

B. Only appears on summary worksheets

C. Limits the formatting options

D. Can not be modified

  1. Which among following is divide symbol in excel?

A. /

B. D

C. Div

D. \

  1. Which function in excel counts the numbers of characters in a cell?

A. Length

B. LGT

C. LT

D. LEN

  1. Shortcut to edit the selected cell?

A. F3

B. F8

C. F4

D. F2

  1. Merge cells option can be applied from?

A. Formatting toolbar

B. Format Cells dialog box Alignment Tab

C. Both of above

D. None of above