Computer : : MS Excel Questions & Answers

  1. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

A. C1:10H

B. C1:H10

C. C1:H-10

D. C1:H:10

  1. You can convert existing Excel worksheet data and charts to HTML document by using the?

A. Intranet Wizard

B. Export Wizard

C. Internet Assistant Wizard

D. Import Wizard

  1. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

A. Pivot Table Report

B. Pivot Table List

C. Pivot Table Field List

D. HTML

  1. VLOOKUP function used to?

A. Finds related records

B. Looks up text that contain "v"

C. Check if two cells are identical

D. None of above

  1. How do you change column width to fit the contents?

A. Single-click the boundary to the left to the column heading

B. Double click the boundary to the right of the column heading

C. Press Alt and single click anywhere in the column

D. All of above