NEW
Font size
WorksheetsClass 10AB TERM I
Total questions: 80
Worksheet time: 48mins
The receiver’s response to the message
a) Encoding
b) Decoding
c) Feedback
d) Advice
……………communication is the act of using photographs ,videos etc
a)Non –Verbal
b)Visual
c)Verbal
d)Oral
The ………………..barriers relate to the factors that are personal to the sender and receiver.
a)semantic
b) personal
c)cultural
d)Gender
One of the 7 c’s of communication. It uses specific facts and figures.
a)clarity
b) concreteness
c)courtesy
d)consideration
.....………….. is the body's reaction to any change that requires an adjustment or response.
a)Self- management
b) stress
c)self- reliance
d)stress management
The shortcut key Ctrl +C represents
a) copy
b) paste
c) cut
d) undo
------- enables exchange of feelings, ideas etc between two or more persons.
a) Leadership
b) Co-ordination
c) Communication
d) Controlling
Which of the following function is not performed using a mouse?
a) Turn on
b) Hover
c) Right click
d) Drag and drop
----- operating system runs on a set of computers that are interconnected by a network.
a) Real time
b) Distributed
c) Multi user
d) Single user
. A group of words that just gives some hint of the idea contained in a message is a:
a) phrase
b) clause
c) sentence
d) paragraph
Which of the following helps us in enhancing our mindfulness.
a) Yoga
b) Meditation
c) Exercise
d) None of these
Which of the following enables you to develop your own idea about ‘what is appropriate behavior’ and ‘what is inappropriate behavior’ in a given social condition.
a) Self –Motivation
b) Self-discipline
c) Self-Awareness
d) Self-Regulation
Grooming is a term associated with ------
a) Time management
b) Problem solving
c) Neat and clean appearance
d) Self-management
What makes you complete work or studies without others cheering you?
(a) Self-confidence
(b) Communication
(c) Self-motivation
(d) Self-esteem
Which of the following is not included in 7 C’s of communication?
a) Clarity
b) Courtesy
c) Correctness
d) Command
What is the importance of effective communication in a workplace?
Reducing office expenses
Enhancing team collaboration and productivity
Increasing employee vacation days
Improving office aesthetics
High expectations from self can leave with chronic anxiety and stress, thus leading to _____________stress.
Physical
Emotional
Social
Financial
Imagine you are working on a challenging project for your studies, and you have a tight deadline. No one is around to cheer you on or offer encouragement, but you need to push through and complete the work. What will make you complete work without others cheering you?
Self-confidence
Communication
Self-motivation
Self-esteem
Which organization has adopted the Sustainable Development Goals.
UNICEF
League of Nations
United Nations
World Health Organization
What should you do to ensure secure online transactions?
Lock your computer
Give credit card or bank details only on safe websites
Use anti-virus
Do not use pirated software
What is the style in LibreOffice Writer?
A method of typing
A collection of all formatting information
A tool for drawing shapes
A spell-check feature
Which of the following is an example for absolute cell referencing?
C5
$C$5
$C
#C
Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened?
Entries
Background
Styles
Type
Which of the following is true about Track Changes feature of Writer?
You cannot record a change made in the document.
A comment of a particular author only can be deleted
Any change made to the document is permanent.
None of the above
Imagine you are a financial analyst tasked with analyzing quarterly sales data for a multinational corporation. The data is stored in separate sheets within an Excel workbook, each representing sales figures from different regions (e.g., North Zone, East Zone, South Zone). How can you efficiently view and compare quarterly sales data from multiple regions in a single spreadsheet to identify trends and relationships?
By creating separate charts for each region's data.
By using the Consolidate function to combine information from all regional sheets into one summary sheet.
By manually copying and pasting data from each region's sheet into a new sheet.
By deleting unnecessary data from each region's sheet.
Sore lower back is caused due to.
Reaching forward frequently
No lumbar support
No upper back support from chair
Reaching forward for long periods
What is the extension of spreadsheet file in Calc?
.odb
.odt
.odg
.ods
Which of the following is the shortcut key to open the Templates dialog box?
Ctrl +Alt +N
Ctrl +Shift +N
Ctrl +Alt +T
Shift +Alt +T
Which style category would you use to format a section containing text, graphics, and lists?
Page Style
Paragraph Style
Character Style
Frame Style
It is a reference point for the graphics which is created while positioning any image. This point could be the page, or frame where the object is either a paragraph, or even a character in a word processor.
Wrap Text
Anchoring
Alignment
Bookmark
Which of the following is a valid Macro Name?
1formatword
format word
format*word
Format_word
A fresh food cafeteria helps to maintain the _____________of the employee.
Health
Morale
Productivity
Engagement
Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?
Macro
Hyperlink
Connect
Copy
Which of the following operations cannot be performed using LibreOffice Calc?
Store and manipulate data
Create graphical representation of data
Analysis of data
Creating Table of content.
We can insert the new Sheet in Calc by clicking on ________ menu.
Format
Insert
Sheet
Tool
Scenarios are tools to test _____________ questions.
What-else
what-if
If-else
if
Statement 1: The print icon appears on standard toolbar
Statement 2: The printed copy of a document is called a hard copy
Both Statement 1 And Statement 2 Are Correct.
Both Statement 1 And Statement 2 Are Incorrect.
Statement 1 Is Correct but Statement 2 Is Incorrect
Statement 1 Is Incorrect but Statement 2 Is Correct
The Share Workbook option is available under the ______________ tab.
View
Tools and Review
Data
Insert
Nisha wants to create a customer database for her small business. She wants to ensure each customer's email address is unique. Which key should she use in LibreOffice Base?
Foreign Key
Composite Key
Unique Key
Primary Key
Ravi is building a relational database in LibreOffice Base and wants to connect two tables so that every entry in the 'Orders' table corresponds to a valid entry in the 'Customers' table. What feature should he use?
Primary Key
Foreign Key
Table Design
Relationships
Which type of query in LibreOffice Base allows you to combine data from multiple tables?
Action Query
Select Query
Crosstab Query
Update Query
To enforce referential integrity between two tables, which of the following should be used?
Primary Key
Foreign Key
Unique Key
Index
Which type of relationship between tables ensures that every record in one table is associated with one or more records in another table?
One-to-One
One-to-Many
Many-to-Many
Self-Referencing
Assertion-Reasoning Question: Assertion (A): A report in LibreOffice Base is used to display formatted data. Reason (R): Reports cannot include data from multiple tables.
Both A and R are true, and R is the correct explanation of A.
Both A and R are true, but R is not the correct explanation of A.
A is true, but R is false.
A is false, but R is true.
Which component of LibreOffice Base helps in creating queries without writing SQL code?
SQL Command
Query Design View
Report Wizard
Macro
You need to ensure that a column in a table does not have duplicate values. Which constraint should be applied?
Primary Key
Foreign Key
Unique Key
Check Constraint
Which SQL statement is used to delete all records from a table in LibreOffice Base?
DELETE * FROM table_name;
DROP TABLE table_name;
DELETE FROM table_name;
REMOVE FROM table_name;
What is a database?
An organized collection of data stored electronically
A collection of unprocessed facts
A type of software
A method of data analysis
What is the purpose of a query in a database?
To retrieve, update, or manipulate data
To store data
To create tables
To delete data
What is the purpose of linking spreadsheets in Libre Calc?
The purpose of linking spreadsheets in Libre Calc is to reference and consolidate data across multiple spreadsheets.
To print multiple spreadsheets at once.
To format cells in a specific style.
To create a backup of the original spreadsheet.
How do you create a link to another spreadsheet in Libre Calc?
Use the formula =Sheet1!A1 to link to a cell in another spreadsheet.
Click on 'Insert' and select 'Link' to create a link to another spreadsheet.
Drag and drop the file into the current spreadsheet to link it.
Use the formula ='[OtherSpreadsheet.ods]Sheet1'!A1 to link to a cell in another spreadsheet.
What is the difference between linking and copying data in Libre Calc?
Linking updates automatically with changes; copying creates a static duplicate.
Linking and copying are the same process in Libre Calc.
Linking creates a static duplicate; copying updates automatically.
Copying requires internet access while linking does not.
·Which of the following is an valid Macro Name?
1formatword
format word
format*word
Format_word
What is the primary purpose of using Macros in software applications?
to automate repetitive tasks
to create complex graphics
to enhance security features
to manage user permissions
Macro Recordings can be enabled from the ________ option in the menu bar.
Sheet
Data
Tools
Window
Identify which of the following is a programming Language?
Calc
BASIC
Writer
Macro.
The Module can be executed from the IDE by pressing _________________. (a) (b) (c) (d)
F3
F4
F5
F6
Which of the following is the default name of the Macro _______________.
Default
Main
Macro1
Macro
Macro is a group of instructions executing a single instruction.
False
True
It is not possible to stop recording of a Macro
True
False
A macro once created can be edited later.
True
False
Which menu path enables macro recording?
Tools > Macro > Enable
Tools > Options > LibreOffice > Advanced
File > Options > LibreOffice > Advanced
Edit > Options > Enable Macro
In which applications does the macro recorder work?
Calc and Writer
Calc and Impress
Base and Draw
Writer and Base
What does the term 'keystrokes' refer to in the context of macros?
Keyboard inputs
Screen touches
Mouse clicks
Voice commands
Which actions are NOT recorded by the macro recorder?
Keyboard selections
Switching of windows
Applying formulas
Applying formatting features
What is a Library in the context of macros?
A collection of users
A collection of spreadsheets
A collection of modules
A collection of data entries
Which character is allowed in the name of a Macro, Module, or Library?
Underscore
Space
Dash
Period
Which feature in LibreOffice Calc would you use to find an optimal solution by adjusting multiple variables?
Goal Seek
Solver
Data Consolidation
Filter
Ravi wants to find the maximum sales amount from a list of sales data. Which function should he use?
MAX
MIN
AVERAGE
SUM
Which feature in LibreOffice Calc allows multiple users to edit the same spreadsheet at the same time?
Goal Seek
Solver
Share Workbook
Track Changes
Which option in LibreOffice Calc allows you to group multiple worksheets into one consolidated summary?
Data Table
Sheet Reference
Data Consolidation
AutoFilter
Shweta is working with a large dataset in LibreOffice Calc and wants to view only the data that meets certain criteria, such as sales above $10,000. Which feature should she use?
Sorting
Filtering
Subtotal
Goal Seek
Arun wants to automate the process of applying a specific formula across all sheets in his workbook. What is the best method to achieve this in LibreOffice Calc?
Use AutoFill
Create a Macro
Use a Template
Copy and Paste the formula
Rita needs to quickly find out what the break-even point is for her business. She wants to know the exact value of sales required to cover her costs. Which feature of LibreOffice Calc should she use?
Goal Seek
Solver
Data Validation
Filters
Deepak wants to compare different sales scenarios for his store using LibreOffice Calc. Which feature should he use to create multiple versions of his sales data?
Conditional Formatting
Scenario Manager
Data Consolidation
Pivot Table
Which function in LibreOffice Calc can be used to count the number of cells that contain numbers?
COUNTA()
COUNTIF()
COUNT()
COUNTBLANK()
What is a "Style" in LibreOffice Writer?
A collection of formatting settings saved for reuse
A type of font
A page layout tool
A table design feature
Which keyboard shortcut opens the Styles menu in Writer?
F5
F11
Ctrl+S
Alt+F4
How do you import styles from a template?
File → "Load Styles from Template"
Styles Action button → "Load Styles"
Copy-paste the template into a new document
Use the "Template Manager"
Which file format is commonly used for text documents?
.html
.docx
.txt
