Microsoft Excel Mcqs

With which of the following all formulas in excel starts ?A. /
B. *
C. $
D. =

 

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?

A. Smart tip
B. Soft Tip
C. Web Tip
D. Cell Tip

In MS Excel to delete duplicate values which menu is used?

A. Data
B. Tools
C. Formatting
D. Layout

How many rows are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

How many columns are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

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

You can use “Pivot table” field list to select and move field list. HTML and Pivot Table List are irrelevant options. Pivot Table Report is the web component which helps the user to create both simple and complex report.

 

Which among following is not associated with spelling dialogue box?A. Edit
B. Ignore All
C. Ignore
D. Change