Advance Excel Training In Chandigarh

MICROSOFT EXCEL Q and A

1. What is Microsoft excel expectations?

Ans. Microsoft excel expectations is a case of electronic spreadsheet and it can be utilized to make diverse kinds of archives such (Mark Sheet, Result Sheet, Sales and Purchase Invoice, Balance Sheet, and so on.

2. What is macro ?

Ans. In Microsoft exceed expectations,macro is a strategy that is utilized to record a specific errand or equation which need to rehash soon after brief time

3. How to shroud page break line?

Ans. As a matter of course Microsoft exceed expectations sheet demonstrate page break lines soon after print review and these page break signs can be stow away by following the underneath steps.

1. Tap on "Document" menu

2. Tap on "Alternatives"

3. Select "Progress"

4. Presently select "Show page breaks" under "Show alternatives for this worksheet"

4. Instructions to embed Indian Rupee sign in MS-Excel?

1. Open the control board by utilizing "Control" run charge 2. Tap on "Clock, Region and Language" 3. Tap on "Locale and Language" 4. Presently change design in English (India)

5. Depict a wide range of cell reference in MS-Excel?

Ans. In Microsoft exceed expectations, cell reference can be characterized in two classifications. I. Relative Cell Address: These kinds of cell address alter concurring the chose cells amid duplicate an equation. (Illustrations: A1, B1, C1, and so forth.) II. Outright Cell Address: These kinds of cell address does not change concurring the chose cells amid duplicate an equation (Examples: $A$1, A$1, and so forth.)

6. What is the utilization of Pivot Table and Pivot Chart?

Ans. Turntable: This alternative is utilized to make a rotate table with chose information things and subsequent to making a turntable

we can without much of a stretch play out the accompanying undertaking.

1. Channel information

2. Cover up and unhide any information thing.

3. Sort information in rising and diving request. Rotate Chart: This choice is utilized to make the two articles (Pivot table and Pivot Chart) and any impact in one question will likewise naturally in the second protest.

Advance Excel training in Chandigarh. Microsoft Excel is a spreadsheet establish by Microsoft for Windows, macOS, Android and iOS. Its main function is calculation, graphing tools, pivot tables, and a macro programming language.

Facebook Google Twitter More

• Pinterest
• Linkedin
• Tumblr

January 03, 2018

Subscribe by Email

Follow Updates Articles from This Blog via Email