Microsoft Excel MCQs for Competitive Exams

1701

Regarding gridlines in Excel:

A May be turned on or off for printing B May be turned off for display but on for printing C May be turned off for both display and printing D a, b, and c

Answer & Solution Discuss Save Report

1702

What does the VLOOKUP function do in Excel?

A Finds related records B Looks up text containing the letter "V" C Checks if text in one cell matches the next D All of above

Answer & Solution Discuss Save Report

1703

In spreadsheets, how is data arranged?

A Rows and columns B Height and width C Lines and spaces D Layers and planes

Answer & Solution Discuss Save Report

1704

What types of charts can Excel create?

A Bar charts, line graphs, and pie charts B Line graphs and pie charts only C Only line graphs D Bar charts and line graphs only

Answer & Solution Discuss Save Report

1705

Why is each Excel file called a "workbook"?

A Because it can hold many sheets, including worksheets and chart sheets B Because you have to work hard to create it C Because it can be modified D Because it can contain text and data

Answer & Solution Discuss Save Report

1706

To access the Consolidate dialog box, choose Consolidate from which menu?

A Data B Tools C Format D Insert

Answer & Solution Discuss Save Report

1707

From which menu are macros executed in Excel?

A Tools B Insert C Data D Format

Answer & Solution Discuss Save Report

1708

Besides which function, do logical function formulas display "TRUE" or "FALSE" as results?

A IF B NOT C OR D AND

Answer & Solution Discuss Save Report

1709

If you insert an Excel file into Word, the content is:

A Embedded B Hyperlinked C Placed as a Word table D Linked

Answer & Solution Discuss Save Report

1710

Which function turns row data into column data or vice versa?

A Index B Hyperlink C Transpose D Rows

Answer & Solution Discuss Save Report