Standard 7 Practice

Word Processing and Presentation

Spreadsheet Software

Database Software

Social Media , Mobile Technologies, and Live Streaming

Data Interpretation

100

Which feature in word processing software allows you to create consistent formatting for headings and text?

A. Styles

B. Page Layout

C. Track Changes

D. Hyperlink

A. Styles

100

Which formula calculates the average of numbers in cells A1 to A5?

A. =COUNT(A1:A5)

B. =TOTAL(A1:A5)

C. =AVERAGE(A1:A5)

D. =SUM(A1:A5)

C. =AVERAGE(A1:A5)

100

In a database, which field uniquely identifies each record?

A. Column header

B. Primary key

C. Foreign key

D. Index

B. Primary key

100

Which metric measures user interaction with a social media post?

A. Upload speed

B. Slide transitions

C. Views

D. Engagement such as likes, comments, and shares

100

If a line graph shows a rising trend over months, what does it indicate?

A. Error

B. Increase

C. No change

D. Decrease

B. Increase

200

What is the primary purpose of using a table in a word document?

A. Change font color

B. Insert a header

C. Add animations

D. Organize data in rows and columns

200

Which chart is best for showing parts of a whole?

A. Pie chart

B. Line chart

C. Scatter plot

D. Bar chart

A. Pie chart

200

Which query type retrieves specific information from a database?

A. Report query

B. Form query

C. Select query

D. Action query

C. Select query

200

Which feature allows you to schedule social media posts in advance?

A. Filter

B. Story

C. Scheduler

D. Analytics

C. Scheduler

200

Which type of chart is best to compare sales of different products?

A. Scatter plot

B. Histogram

C. Pie chart

D. Bar chart

300

Which presentation feature helps you apply the same design to all slides?

A. Transition

B. Master Slide

C. Slide Sorter

D. Slide Layout

B. Master Slide

300

What is the purpose of a spreadsheet function like VLOOKUP?

A. Retrieve data from a table based on a value

B. Create animations

C. Insert images

D. Format text automatically

A. Retrieve data from a table based on a value

300

Which of the following is a benefit of using a database over a spreadsheet?

A. Automatically edits text

B. Creates slide shows

C. Easier to create animations

D. Better at storing large amounts of structured data

300

Which of these is a live streaming platform?

A. Microsoft Word

B. Excel

C. Access

D. YouTube Live

300

In a table, what does the intersection of a row and column represent?

A. A heading

B. A chart

C. A data value

D. A formula

C. A data value

400

Which of the following is an example of a multimedia element in a presentation?

A. Slide numbers

B. Bullet points

C. Images, audio, and video

D. Text boxes

C. Images, audio, and video

400

Which spreadsheet feature allows you to organize data alphabetically or numerically?

A. Pivot Table

B. Conditional Formatting

C. Filter

D. Sort

400

What is a report in a database?

A. A type of query

B. A formatted summary of data from tables or queries

C. A text document

D. A visual chart

B. A formatted summary of data from tables or queries

400

Which mobile feature helps you access your cloud documents anywhere?

A. Bluetooth

B. Camera

C. Cloud storage app

D. Wi-Fi

C. Cloud storage app

400

What is an outlier in a dataset?

A. A trend

B. A total sum

C. An average value

D. A value that is very different from the others

500

What is the function of the Track Changes feature in word processing software?

A. Insert a table of contents

B. Save files to the cloud

C. Monitor and display edits made by multiple users

D. Automatically correct spelling errors

C. Monitor and display edits made by multiple users

500

What is the correct formula to calculate total sales in column B?

A. =COUNT(B1:B10)

B. =SUM(B1:B10)

C. =TOTAL(B1:B10)

D. =ADD(B1:B10)

B. =SUM(B1:B10)

500

Which of these is an example of database software?

A. PowerPoint

B. Word

C. Excel

D. Microsoft Access

500

How can live streaming help a business?

A. Design reports

B. Broadcast events in real time and engage customers

C. Format text

D. Create spreadsheets

B. Broadcast events in real time and engage customers

500

What is the first step in analyzing data from a chart?

A. Add images

B. Insert new rows

C. Identify trends and patterns

D. Change colors

C. Identify trends and patterns