Computer Skills Assessment

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

• 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, colour scheme, and fonts for presentation?

• Content

• Format

• Normal

• Design

PowerPoint presentations are widely used as:

• Note outlines for teachers

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

• Numbers

• Letters

• Letters and Numbers

• Cells