Category Archives: MS Excel MCQs

To edit in an embedded, excel worksheet object in a word document?

A. Use the Excel menu bar and toolbars inside the word application
B. Edit the hyperlink
C. Edit the data in a excel source application
D. Use the word menu bar and toolbar

In MS Excel, if a numeric value starts with _______ then this value can be treated as label?

A. Hash
B. Equal Sign
C. Apostrophe
D. Tide

Which of the following way cannot be used to link excel worksheet data to word document?

A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste button on the standard toolbar

In MS Excel, which function automatically total a column or row of values?

A. TOTAL
B. ADD
C. SUM
D. AVG

In MS Excel, we cannot edit the contents of a cell by?

A. Pressing the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell

in MS excel 2016, which of the following can be used to split windows into two?

A. Format > Window
B. View > Window> Spilt
C. Window > Spilt
D. View > Spilt

Columns in MS Excel are called?

A. Fields
B. Groups
C. data
D. Chart

To insert blank imbedded word object in Excel?

A. Click the object command on the insert menu
B. Click the link button on standard toolbar
C. Click the link button on Format Painter
D. None of these

With which of the following all formulas in excel starts?

A. /
B. *
C. =
D. #

When typing character search criteria, Excel matches fields based on?

A. Alphabetical order
B. capitalization
C. Spelling
D. Primary records