WorksheetsComputer Applications Mastery
Total questions: 10
Worksheet time: 5mins
What is the primary function of word processing software?
To analyze data and create spreadsheets.
To design graphics and illustrations.
To manage databases and store information.
To create and edit text documents.
Which formula would you use to calculate the average of a range of cells in a spreadsheet?
=SUM(range)
=COUNT(range)
=AVERAGE(range)
=MAX(range)
What feature in presentation software allows you to add visual effects to slides?
Image Editing
Text Formatting
Transitions and Animations
Slide Layouts
In database management, what is the purpose of a primary key?
A primary key is meant to group similar records together.
The primary key serves as a backup for data recovery.
The purpose of a primary key is to uniquely identify each record in a database table.
A primary key is used to store large amounts of data.
Which graphic design application is commonly used for vector graphics?
Adobe Illustrator
Sketch
CorelDRAW
Inkscape
What is the shortcut key for saving a document in most word processors?
Shift + S
Ctrl + D
Alt + S
Ctrl + S
How can you create a chart in a spreadsheet application?
Select data, go to 'Insert', choose 'Chart', select type, and insert.
Mark data, access 'Tools', click 'Plot', choose format, and generate.
Choose range, navigate to 'Data', select 'Diagram', pick design, and create.
Highlight cells, click 'Format', select 'Graph', pick style, and apply.
What is the difference between a relational database and a non-relational database?
Relational databases store data in JSON format; non-relational databases use fixed schemas and SQL.
Relational databases are designed for unstructured data; non-relational databases require strict data types.
Relational databases use structured tables and SQL; non-relational databases use flexible formats and various query methods.
Relational databases use key-value pairs; non-relational databases rely on complex joins and transactions.
Which tool in graphic design software is used to manipulate images?
Brush Tool
Crop Tool
Text Tool
Edit Tool
What is the function of the 'Slide Master' in presentation software?
The 'Slide Master' adds animations to slides.
The 'Slide Master' manages speaker notes for presentations.
The 'Slide Master' controls the overall design and layout of slides.
The 'Slide Master' edits individual slide content.
