NSDA COP L-3 (New Tools-1)

Type of chart is good for a single series of a data?

• Column chart

• Cone Chart

• Line Chart

• Pie Chart

What is an Excel feature that displays only the data in columns according to specified criteria ?

•  Filtering

• Sorting   

• Formula  

• Pivo

Excel function returns TRUE of FALSE based on two of more conditions.

• =AVERAGEIFS  

• =CONCAT  

• =COUNTA   

• =AND

Which of these font effects in NOT available in the PowerPoint Font dialogue box?

• Shadow  

• Underline  

• Strikethrough  

• Emboss

Which types of templates provides all the users with a design concept, color scheme and fonts for presentation?

• Content   

• Format  

• Normal   

• Design

PowerPoint presentations are widely used as:

• Note outlines for teachers  

• Project presentations by student

• Communication of planning  

• All of above

What is a motion path?

• A type of animation entrance effect

• A method of moving items on a slide

• A Method of advancing slides

• All of the above

What happens when you clivk on CTRL+ X after selecting some cells in Excel?

• The cell content of selected cells disappears from the cell and is stored in a clipboard

• Value in the cells selected is marked for cutting

• The selected cells are deleted and the cells are shifted left

• The selected cells are deleted and cells are shifted up

A numeric data analysis tool that allows us to create a computerized ledger-

• Word processing package   

• Spreadsheet package

• Graphics package

• Mathematical package

In Google sheet, columns are represented by

• Number  

• Letters   

• Letters and Numbers  

• Cells