WorksheetsNSDA COP L-3 (New Tools-1)
Total questions: 20
Worksheet time: 10mins
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
Which sign is used in the formula to use absolute reference?
Underscore(_)
Dollar ($)
Equal(=)
Colon (:)
Which feature allows you to narrow down the data in your worksheet ?
Filters
Reporting
Sorting
Statics
Which format represents the numbers with the dollars ($) sign? [For example, $1,000.00]
Automatic
Number
Currency
Time
A List of various coded instructions is known as:
Flowchart
Algorithm
Utility programs
Computer program
What is a URL?
An acronym for unlimited Resources for Learning
The address of a document or “page” on the World Wide Web
a type of programming object
a computer software program
Which of the following is not an operating system?
UNIX
MS-DOS
CP/M
PASCAL
Which is used to store firmware?
EPROM
ROM
RAM
PROM
Documents can be ____ with MS Word?
Created
Edited
Saved
All of the above
Which of the following tab is the default in MS Word?
Home
Insert
Page Layout
Reference
Which of the following is automatically counted in MS Word?
Number of words
Number of Pages
Number of characters
all of the above
