NSDA COP L-3 (New Tools-5)

In a computer spreadsheet, function which is used to count numbers of entries in given range is called

• Length    

• Counter     

• counting    

• count

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

• Filtering    

• Sorting    

• Formula     

• Pivot

A change in the appearance of a value or label in a cell.

• Alteration  

• Format    

• Indentation 

• Design

Which of these font effects is 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 presentation are widely used as:

• Note outlines for teachers

• Projects presentations by students

• Communication of Planning 

• All of the above

What is a motion path?

• A type of animation entrance effect

• A method of advancing slides  

• A method of moving items on a slide 

• All of above

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

• The cell content of selecte4d 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 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

• Numbers 

• Letters     

• Letters and Numbers

• Cells