OFFICE AUTOMATION

Which chart will be suitable to show the share of three partners in a business?

• line chart

• bar chart

• graph chart

• pie chart

The software that is used for accounting purpose is:

• MS word

• MS excel

• MS PowerPoint

• MS access

The software that is used to format a document is:

• MS word

• MS PowerPoint

• MS excel

• MS access

The special character that initiates the formula mode in a cell is:

• /

• =

• -

• *

The function which is used to re-arrange data according to specific criteria is called:

• Filtering

• Sorting

• Organizing

• Grouping

If we want to change the overall design of a word document , we should use:

• themes

• page layout

• watermark

• margins

The correct formula to calculate the total in the given table is:

• =B2+C2+D2+E2

• =B2+C2

• =sum (B2TOE2)

• =sum (B2fromE2)

The correct formula to calculate the percentage in the given table is:

• =B2+C2+D2+E2 /400*100

• =B2+C2+D2+E2 *100

• =(B2+C2+D2+E2) / 400*100

• =(B2+C2+D2+E2) /100*400

Charts are basically used to

• design tables

• Organize data in tables

• Sort data in different columns

• show the quantities and their relationships graphically

To apply the table of contents automatically, the most important task is to properly define

• levels of heading

• page numbering

• page layout

• themes