Page 349 - Computer - 9(A&B)

comments related to product quality issues. Which mechanism should you use to selectively display
these relevant comments?
a. Sorting b. Searching c. Filtering d. Validating

ii. How can one calculate the total of values entered in a worksheet column of?
a. By manual entry b. By auto-sum c. By formula d. By sum function
iii. If we move a cell containing a formula having reference to another cell in the worksheet hat will
happen to the cell numbers used in the formula?
a. The cell row and columns are changed at destination.
b. The cell row change at destination.
c. The cell columns are changed at destination.
d. No change will occour.

iv. Cell A1 contains the number 10 and B1 contains 2. What will be the contents of cell C1, if the formula
=A1+B1*2^3 is entered in cell C1?
a. 32 b. 96 c. 26 d. 64

v. Which of the following options when selected deletes all data validation?
a. Delete formatting b. Delete all
c. Delete formula d. Delete me
vi. A function should start with__________________.
a. ‘=’ sign b. alphabets c. numbers d. All of the these

Q. 5. Answer any 5 out of the given 6 questions (1x 5= 5 marks)
i. Which of the following is not a part of main Impress window?
a. Slides pane b. Workspace c. Work pane d. Task pane

ii. In the Sidebar of your presentation software, you want to apply slide transitions to all slides uniformly.
Which option should you select after opening the Slide Transition section?
a. Apply to Selected Slides b. Apply to All Slides

c. Modify Transition d. Loop until Next Sound
iii. Which of the following feature is used to progress the slide show automatically while speaking on
the topic?
a. Custom Animation b. Rehearse Timing c. Slide Transition d. Either (a) or (b)
iv. Maria is preparing a presentation on renewable energy sources using LibreOffice Impress. She wants
to ensure that her slides have consistent formatting and that she can easily update slide content
without affecting the overall layout. Which characteristics of LibreOffice Impress would best help
Maria achieve this?
a. Dynamic slide transitions and animations b. Slide master and layout templates
c. Integration with online collaboration tools d. Real-time audience feedback monitoring

v. The keyboard shortcut key to start slide show from current slide is _____________.
a. Shift+ F5 b. F5 c. Ctrl+ F5 d. Esc+F5
vi. Which of the following features is used to create a new slide show with the current slides but
presented in a different order?
a. Rehearsal b. Custom Slide show c. Slide Show Setup d. Slide Show View

211
211