Formative MCQ & Written-02

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 (s) according to specified criteria?

• Filtering

• Sorting

• Formula

• Pivot

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

• Alteration

• Format

• Normal

• Design

Which of this font effect is NOT available in the PowerPoint font dialogue box?

• Shadow

• Strikethrough

• Underline

• 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 teacher

• Project presentation by students

• Communication of planning

• All of above

What is a motion path?

• A type of animation entrance effect

• A method of advancing slides

• A method of moving item on slide

• All of above

What happens when you click 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 the 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 presented by_

• Numbers

• Letters

• Letters and Number

• Cells