MS Excel MCQs

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. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

A. Press Ctrl + Home

B. Press Home

C. Press Shift + Home

D. Press Alt + Home

A. ” ( quote )

B. = ( equal )

C. _ ( underscore )

D. ‘ ( apostrophe )

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

A. You can use the format painter button on ly one time when you click it

B. Double clicking the format painter button

C. Pressing the Ctrl key and clicking the format painter button

D. Pressing the Alt key and clicking the format painter button