NEW
Font size
WorksheetsFormative Assesment6 new 2025
Total questions: 30
Worksheet time: 15mins
Programs or a set of electronic instruments that tell a computer what is called?
Software
Hardware
Menu
Monitor
Which of the following is not an essential component to create mail merge?
Main document
Data source
Merge fields
Word fields
In Excel, Column are labelled as ------
A, B, C
1, 2, 3
A1, B1, C1
A1: C1
refers to forward the object one level or to the front of all objects.
Bring to front
Rotate
Send to back
Align
When you cut and paste something, it is temporarily transferred to---
Another partition on the hard drive
Virtual memory
Swap File
Clipboard
Workbook is a Collection of
Page setup
Worksheet
Hotlines
Diagrams
Press -------- to Close an open menu or submenu, dialog boxes or message window--
Tab+Ctrl+6
Esc
Alt+S
Ctrl+[
To remove the content of selected cells you must issue-----------------------------command?
Delete
Clear Content
Clear All
Clear Delete
The background style of Powerpoint presentation is known as;
Animation
Theme
Transition
Effects
Which is a valid file format in Powerpoint?
.PPTX
PowerPT
.docx
One of the text functions to join two or more text strings into one string
CONCATENATE
COUNTA
COUNT
INT
Which of the following provides a printed copy of your presentation?
Outline
Speaker notes
Audience Handouts
All
Which of the following is not an example of application software?
MS Powerpoint
Linux
MS Word
Ms Excel
The clock rate of a processor is measured in--
Megahertz or gigahertz
Nanosecond
Micro Hertz
Millisecond
In Microsoft Powerpoint, two kinds of sound effects files that can be added to the presentation is----
.jpg files and .gif files
.wav files and .jpg files
.wav files and .gif files
.wav files and .mid files
To create an ID card using word processing software. Which is most important?
Insert & Modify Shape
Page Layout
Insert Header & Footer & Modify
Insert and Modify Picture
Which format represents the numbers with the dollars ( )sign?[Forexample, 1,000.00]
Automatic
Number
Currency
Time
A list of various coded instruction is known as;
Flowchart
Utility Programs
Algorithm
Computer Program
View displays the text of the slide only?
Bullet View
Notes View
Text View
Outline View
20. ---- is not a function in Excel.
SUM
AVERAGE
subtract
COUNT
Mention the use of Snipping Tool.
The Snipping Tool is a built-in feature in Windows operating systems that allows users to capture screenshots of any part of their screen. It provides a range of keyboard shortcuts and options to customize the screenshot-taking experience.
The Snipping Tool is used to edit videos and add special effects.
The Snipping Tool is a program for creating and managing spreadsheets.
The Snipping Tool is used to browse the internet and download files.
Which Command is used to bring the user directly to the first slide of the presentation?
Ctrl+Home
Ctrl+End
Alt+Home
Shift+Home
Why transitions are useful in PowerPoint?
The purpose of applying transitions in PowerPoint is to make presentations more engaging and professional by creating a smoother flow between slides.
Transitions are used to add background music to each slide automatically.
Transitions are necessary to insert images into slides.
Transitions are used to change the font style of all text in the presentation.
How to change the date & time of the system?
Go to Setting > Time & Language and change the date & time. Or go to control panel > date & Time to Change the date & time.
Restart the computer and the date & time will update automatically.
Change the date & time from the task manager.
Install a new software to change the date & time.
Write down 5 (Five) Antivirus software Name?
Eset, AVG, Norton, Kaspersky, Panda
Photoshop, Illustrator, CorelDraw, Blender, Maya
Chrome, Firefox, Safari, Opera, Edge
Excel, Word, PowerPoint, Access, OneNote
What is the COUNT () function in Excel normally used for?
The COUNT () is generally used to count a range of cells containing numbers or dates excluding blank cells and text.
The COUNT () is used to sum all the values in a range of cells.
The COUNT () is used to find the average of a range of cells.
The COUNT () is used to count only the blank cells in a range.
Which Excel function removes the irregular spacing, leaving one space between each value?
TRIM()
CONCATENATE()
REPLACE()
PROPER()
What is google Docs?
Google Docs is a web-based application developed by Google that allows users to create, edit, and collaborate on documents online.
Google Docs is a hardware device used for printing documents.
Google Docs is a video streaming platform owned by Google.
Google Docs is a social networking site for sharing photos.
Which Excel function removes the irregular spacing, leaving one space between each value?
The TRIM function in Excel is used to remove irregular spacing, leaving one space between each value.
The CONCATENATE function in Excel is used to remove irregular spacing, leaving one space between each value.
The UPPER function in Excel is used to remove irregular spacing, leaving one space between each value.
The PROPER function in Excel is used to remove irregular spacing, leaving one space between each value.
What does it means install software on a computer?
Installing software involves copying program files from a distribution source to the computer’s storage, configuring it for use, and creating necessary shortcuts or links for easy access.
Installing software means deleting all files from the computer to make space for new programs.
Installing software is the process of changing the computer’s hardware components.
Installing software means only updating the computer’s operating system.
