61. Which was the computer conceived by Babbage?
- a) Analytical Engine
- b) Arithmetic Machine
- c) Donald Kunth
- d) All of the above
Answer: A - The Analytical Engine, conceived by Charles Babbage, is considered the first general-purpose computer design.
62. How do you rearrange the data in ascending or descending order?
- a) Data >> Sort
- b) Data, Form
- c) Data >> Table
- d) Data >> Subtotals
Answer: A - The "Data >> Sort" option is used to rearrange data in ascending or descending order.
63. How do you select an entire column?
- a) Select Edit > Select > Column from the menu
- b) Click the column heading letter
- c) Hold down the shift key as you click anywhere in the column.
- d) Hold down the Ctrl key as you click anywhere in the column
Answer: B - Clicking the column heading letter selects the entire column in Excel.
64. How does a reference to a range appear in the Consolidate dialog box?
- a) SheetName!B3:D7
- b) SheetName!B3!:D7!
- c) SheetName!$B$3:$D$7
- d) SheetName$B3$:D7
Answer: C - The correct format for referencing a range is `SheetName!$B$3:$D$7`.
65. How many characters can be typed in a single cell in Excel?
- a) 256
- b) 1024
- c) 32000
- d) 65535
Answer: D - A single Excel cell can hold up to 65,535 characters.
66. How many data types are there in Visual FoxPro?
Answer: D - Visual FoxPro supports 13 different data types.
67. How many steps are there between Start and Finish in AutoContent Wizard?
Answer: A - The AutoContent Wizard has 3 steps between Start and Finish.
68. How many types of Page Orientation are there in MS-Word?
Answer: B - MS-Word supports two types of page orientation: Portrait and Landscape.
69. How many types of Paragraph Alignment are there in MS Word?
Answer: D - MS Word supports four types of paragraph alignment: Left, Right, Center, and Justify.
70. How many types of Tab are available in MS-Word?
Answer: D - MS-Word does not have predefined types of tabs; they are customizable.
71. How many ways you can save a document?
Answer: A - There are three ways to save a document: File > Save, Ctrl + S, and the Save icon.
72. In FoxPro, default date format is________
- a) yy/dd/mm
- b) yy-dd-mm
- c) mm/dd/yy
- d) mm-yy-dd
Answer: C - The default date format in FoxPro is `mm/dd/yy`.
73. In FoxPro, default date format is________
- a) yy/dd/mm
- b) dd/mm/yy
- c) mm/dd/yy
- d) mm-yy-dd
Answer: C - The default date format in FoxPro is `mm/dd/yy`.
74. In Microsoft PowerPoint, two kinds of sound effects files that can be added to the presentation are________
- a) .wav files and .mid files
- b) .wav files and .gif files
- c) .wav files and .jpg files
- d) .jpg files and .gif files
Answer: A - PowerPoint supports `.wav` (waveform audio) and `.mid` (MIDI) sound files.
75. In MS-Word, By default we get _________ number of Columns
Answer: C - By default, MS-Word provides a single column layout.
76. In slide layout panel, how many layouts are available for text layout by default?
- a) 4
- b) 7
- c) 12
- d) None of above
Answer: A - There are 4 default text layouts in the slide layout panel.
77. 'LIST' Command shows________
- a) All the records at a time
- b) Only specific record
- c) Only 2nd record
- d) Display only 2nd and the record without record number
Answer: A - The `LIST` command displays all records in the database.
78. Memory Unit is a part of________
- a) Input device
- b) Control unit
- c) Output device
- d) Central Processing Unit
Answer: D - The Memory Unit is a component of the Central Processing Unit (CPU).
79. Objects on the slide that hold text are called________
- a) Placeholders
- b) Object holders
- c) Auto layouts
- d) Text holders
Answer: A - Placeholders are used to hold text or objects on a slide.
80. One can find "Autosum" option under________
- a) Data tab
- b) View tab
- c) Insert tab
- d) Home tab
Answer: D - The "Autosum" option is located under the Home tab in Excel.