MS Excel MCQs

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

A. Contents

B. Objects

C. Scenarios

D. All of above

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

A. Cell names

B. Column numbers and row letters

C. Column letters and row numbers

D. Cell locator coordinates

A. Choose required color form Patterns tab of Format Cells dialog box

B. Choose required color on Fill Color tool in Formatting toolbar

C. Choose required color on Fill Color tool in Drawing toolbar

D. All of above

A. Counts cells having alphabets

B. Counts empty cells

C. Counts cells having number

D. Counts non-empty cells

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

A. Ctrl + C

B. Ctrl + Enter

C. Ctrl + Page Up

D. Ctrl + Space Bar

A. The cell content of selected cells disappear from cell and stored in clipboard

B. The cells selected are marked for cutting

C. The selected cells are deleted and the cells are shifted left

D. The selected cells are deleted and cells are shifted up

A. Shows the name of workbook currently working on

B. Shows the name of worksheet currently working on

C. Shows the name of cell or range currently working on

D. None of above