Page 442 - TP_IT_V1.0_C10_flipbpookl
P. 442
Q2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. What is a style in LibreOffice Writer?
a. A method of typing b. A collection of all formatting information
c. A tool for drawing shapes d. A spell-check feature
ii. Which of the following is an example for absolute cell referencing?
a. C5 b. $C$5 c. $C d. #C
iii. Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened?
a. Entries b. Background c. Styles d. Type
iv. Which of the following is true about Track Changes feature of Writer?
a. You cannot record a change made in the document.
b. A comment of a particular author only can be deleted
c. Any change made to the document is permanent.
d. None of the above
v. 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?
a. By creating separate charts for each region’s data.
b. By using the Consolidate function to combine information from all regional sheets into one summary sheet.
c. By manually copying and pasting data from each region’s sheet into a new sheet.
d. By deleting unnecessary data from each region’s sheet.
vi. Sore lower back is caused due to.
a. reaching forward frequently b. no lumbar support
c. no upper back support from chair d. reaching forward for long periods
Q3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. What is the extension of spreadsheet file in Calc?
a. .odb b. .odt c. .odg d. .ods
ii. Which of the following is the shortcut key to open the Templates dialog box?
a. Ctrl+Alt+N b. Ctrl+Shift+N c. Ctrl+Alt+T d. Shift+Alt+T
iii. Which style category would you use to format a section containing text, graphics, and lists?
a. Page Style b. Paragraph Style c. Character Style d. Frame Style
iv. 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.
a. Wrap Text b. Anchoring c. Alignment d. BookMark
v. Which of the following is an invalid Macro Name?
a. 1formatword b. format word c. format*word d. Format_word
vi. A fresh food cafeteria helps to maintain the of the employee.
a. Health b. Morale c. Productivity d. Engagement
Q4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in
LibreOffice Calc?
a. Macro b. Hyperlink c. connect d. Copy
ii. Which of the following operations cannot be performed using LibreOffice Calc?
a. Store and manipulate data b. Create graphical representation of data
c. Analysis of data d. Mail merge
440 Trackpad Information Technology (Ver. 1.0)-X

