Excel displays the current cells address in the __________?

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.

 

In Ms Excel Ready made templates are available under _______ tab ?

A. File
B. Insert
C. Design
D. None of Above

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

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

Which Shortcut keys are used to strikethrough highlighted selection in Excel?

A. Ctrl+4
B. Ctrl+5
C. Ctrl+6
D. None of the above.

Excel strikethrough shortcut
Want to have the job done as quickly as possible? Press a hotkey or key combination.
Here’s the keyboard shortcut to strikethrough in Excel: Ctrl + 5
The shortcut can be used on an entire cell, certain part of the cell contents, or a range of cells.
To apply the strikethrough format to a cell, select that cell, and press the shortcut:

In a computer spreadsheet rows are labeled ________ ?

A. by letters
B. by numbers
C. by cell references
D. by symbols