10th IT 402 || Information Technology || Database Spreadsheet MCQ Questions!

 

IT 402

Digital Spreadsheet

1. _________ allows you to gather together your data from separate worksheets into a master worksheet.
   Options:

Styles	Data Tool
Data Consolidation	None of these

2. _________ is a function listed under the Mathematical category when you use the Function Wizard
   Options:

Data Consolidation	Subtotal
Mathematical Function	None of these

3. How to use subtotal?
   Options:

Data > Consolidation	Insert > Function
Insert > Mathematics > Function	None of these

4. Consolidate option is available under the _________ menu.
   Options:

View	Tool
Insert	Data

5. We can consolidate data by ________.
   Options:

Row label	Column label
Both of the above	None of the above

6. Which of the following functions are available in consolidate window?
   Options:

Max	Min
Count	All of the above

7. In which option we have to specify the target range(Where we want the result to be displayed)
   Options:

Source data range	Copy results to
Need result at	target range

8. Scenarios are a tool to test ______ questions.
   Options:

What-if	Who
How-to	None of the above

9. If you select ________ then any values modified in the source range are automatically updated in the target range.
   Options:

Link to source data	Link to sheet data
Link to original data	Link to the source range

The answer sheet is at the end of this post

10. From where can we find Goal Seek option
    Options:

Insert Menu	Target Menu
View	Tool menu

11. Which of the following options are not visible in tools menu
    Options:

Goal Seek	Solver
Consolidate	Scenarios

12. Range option is available under the ________ menu.
    Options:

Data	Tools
Insert	None of the above

13. We can not insert a new sheet in Spreadsheet by
    Options:

Select Insert > Sheet from the menu bar

Shortcut key Ctrl + Shift + N

Click in an empty space at the end of the line of sheet tabs

Right-click on the tab and select Insert Sheet

14. A __________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want a formula to calculate.

Options:

Data Consolidation	Solver
Cell Reference	Cell Consolidation

 

15. The text in the row label or column label must be identical, otherwise, _________ .
    Options:

No actions would take place

Labels will not be shown

a new row or column will be inserted during data consolidation.

None of the above

16. In a spreadsheet Numerical value of cell is denoted to
    Options:

Column	Block
Rows	Cell

17. Absolute reference looks like –
    Options:

B3	$B$3
B$3	$B3

18. What is the format of Open Office Spreadsheet?
    Options:

*.odt	*.odf
*.ods	*.xlsx

19. To create a range, which of the following options is used?
    Options:

Insert → Names → Rang

Insert → Names → Define

Insert → Range

None of the above

 

The answer sheet is at the end of this post

20. Which of the following button is used to define a range after typing name?
    Options:

Add	OK
More	Delete

 

Electronic Spreadsheet True/False

Spreadsheet True/False Questions

1. You cannot combine more than one worksheet cell data into different sheets and use the formula. (T/F)
2. SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard.
3. The function option in consolidate dialog box allows to select the function in the destination cells.
4. Scenarios are a tool to test “how-if” questions.
5. Once ranges are added to consolidated dialog cannot be deleted.
6. Reference option allows you to select the reference from another sheet having data.
7. Consolidate means to combine a number of things into a single unit.
8. The Source Data range option is used to update the value in consolidated worksheet formula cell automatically when the user changes data in source cell.
9. The format of Open Office Calc is *.oss .
10. Data can be consolidated from two sheets only.

Electronic Spreadsheet MCQ Solution

1. C
2. B
3. B
4. D
5. C
6. D
7. B
8. A
9. A
10. D
11. C
12. A
13. B
14. C
15. C
16. C
17. B
18. C
19. B
20. A

Electronic Spreadsheet True/False Solution

1. F
2. T
3. T
4. F
5. F
6. T
7. T
8. F
9. F
10. F

 

10th IT 402 || Information Technology || Digital Documentation MCQ Questions!

 
IT 402
Digital Documentation

 

1.      Which of the following style is used to change the line spacing and borders in Open Office Writer?
Options:

Character Style	Paragraph Style
Page Style	Frame Style

2. Which style can I use for Borders in cells in Open Office?
   Options:

Character Style	Cell Style
Page Style	Graphic Style

3. What is the shortcut key for opening Styles and Formatting window in Open Office?
   Options:

Ctrl + Shift + S	Ctrl + F5
F11	No Shortcut Key

4. Fill Format mode is used for?
   Options:

It is used to colour the page with particular colour

It is used for Mathematical Calculations

Tool for Filling all the cells in a table

It is used to apply a style to many different areas quickly

5. How can we NOT insert an image in Open Office Writer?
   Options:

Drag and Drop method

Copy link of the image and paste the link from the clipboard in Writer

Inserting An Image From The Clipboard (Copy-Paste)

Via Insert Picture Dialog

6. Which tools are not available in Open Office Writer?
   Options:

Cropping images	Rotating a picture
Use Full Screen mode	Apply filters to the image.

7. Transparency tool is used to ____________?
   Options:

Reduce Transparency of image	Making system transparent
Wrapping the image over text	It is an open office filter

8. You can group Images/pictures and _______?

Options:

Tools	Shapes
Drawing objects	Navbar of Open Office

9. Shortcut for Grouping objects is ___________?
   Options:

Shift + G	Ctrl + Shift + G
Ctrl + G	Ctrl + G + O

 

10. What are elements which are not saved in a template from the following options?
    Options:

Styles	Basic Layout
Header And Footer	File Location

11. Which of the following is a way to make a template in Open Office Writer?
    Options:

Styles and Formatting window	Using Wizard
By visiting Openoffice.org	By saving a file using Ctrl + S

12. What is the advantage of using a template?
    Options:

Simplify document creation	Learning about the use of Wizard
Easy email marketing	No need to save files once using templates.

13. How to open a Template Management Dialog?
    Options:

Ctrl + Shift + T	Files > Organise Templates
File > Templates > Organize	Right click > Organise Templates

14. What is use of E# in TOC (Table of Content)?

Options:

Page Number	Chapter Number
Tab Stop	Entry Text

15. What is use of # in TOC (Table of Content)?

Options:

Page Number	Chapter Number
Tab Stop	Entry Text

16. What is use of E in TOC (Table of Content)?

Options:

Page Number	Chapter Number
Tab Stop	Entry Text

17. What is use of T in TOC (Table of Content)?

Options:

Page Number	Chapter Number
Tab Stop	Entry Text

18. Which database set can be used for Mail Merge?

Options:

Any website	Microsoft Azure
Amazon AWS	Microsoft Access

19. Mail Merge can be used for __________?

Options:

Write letters sent from the bank to customers	Writing long paragraphs automatically
Learn to use Website Designing	Make Tables and TOC

20. Which of the following are filters in open office writer?
    Options:

Transparency	Invert Colour
Crop and Resize	Keep Scale

21. Styles and Formatting Window is available in the ______ menu.
    Options:

Format	View
Insert	Tools

22. Which among the following is not a valid type of alignment ?
    Options:

Right	Middle
left	Justified

23. The default tab space is ………
    Options:

1	1.25
2	0.5

24. Name the Key which on pressing closes the header section .
    Options:

F11	Esc
Tab	Alt + C

25. The ……………………… button in the Manage Style dialog box helps in editing any predefined style.
    Options:

Edit style	Styles And Formating
Modify	None of these

 

 True/False Questions

1. Fill Format mode help to apply styles to many different areas quickly.(T/F)
2. We can quickly change the appearance of documents by applying styles.(T/F)
3. A style is a predefined combination of various formatting features and types.(T/F)
4. Right type of alignment places the text evenly between the left and the right margins.
5. Footer can be used to insert the title at the top of each page.

Fill in the blanks

1. The term ______ refers to a preset format for a document or file.
2. _______ are used to break continuous text to one or more sentences.
3. When Fill Format mode is active, _____ click undo last Fill Format action.
4. To quit Fill Format mode press the _______ key.
5. If you would like to start a new page in a document, you can use the option ______ .

Digital Documentation Class 10 MCQ with answers

Solution for Digital Documentation MCQ

1. B
2. B
3. C
4. D
5. B
6. C
7. A
8. C
9. C
10. D
11. B
12. A
13. C
14. B
15. A
16. D
17. C
18. D
19. A
20. B
21. A
22. B
23. D
24. D
25. C

True/False Solution

1. True
2. True
3. True
4. False
5. False

Fill in the blanks solution

1. Template
2. Text Wrapping
3. Right
4. Esc
5. Page Break