IT Professional Knowledge Quiz for IBPS SO Mains 2023- 26th January

Q1.Which of the following key is used to open the START menu?
(a) Ctrl+Esc
(b) Shift+Esc
(c) Alt+F4
(d) Alt+Enter
(e) None of these

Q2.You can organize your bookmarks using __________.
(a) structures
(b) containers
(c) folders
(d) menus
(e) Chart

Q3. Which of the following tools is used to tell the database management system that a specific attribute contains numbers only?
(a) Data category
(b) Data type
(c) Data dictionary
(d) Data definition
(e) None of these

Q4. Queries in Access can be used as __________.
(a) View, change and analyze data in different ways
(b) A source of records for forms and reports
(c) to access internet
(d) Both a and b
(e) None of these

Q5. Primary Memory stores:
(a) Result
(b) Data
(c) Programs
(d) All of these
(e) None of these

Q6.Which key is representing relationship between tables?
(a) Primary Key
(b) Secondary Key
(c) Foreign Key
(d) Candidate key
(e) None of these

Q7. To move to the next worksheet in a workbook press______
(a) Ctrl + page down
(b) Ctrl + page up
(c) Ctrl + Home
(d) Ctrl + End
(e) None

Q8. What does dots per inch (DPI) measure?
(a) number of bits it takes to represent each color
(b) density of the pixels on a computer screen
(c) the density of bits on a disk
(d) density of graphic files stored on a hard disk
(e) None of these

Q9. How many rows are there in latest version of MS Excel?
(a) 65536
(b) 16,384
(c) 1,048,576
(d) 1,050,000
(e) 2,001,000

Q10. Which of the following characteristics is used to compute dynamically the results from Excel data?
(a) Go to
(b) Table
(c) Chart
(d) Diagram
(e) Formula and Function

Solutions

S1. Ans.(a)
Sol. Ctrl+Esc key is used to open the START menu

S2.Ans.(c)
Sol. you can organize your bookmark into folders by topic or task etc.

S3. Ans.(b)
Sol. Data type is used to tell the database management system that a specific attribute contains numbers only.

S4. Ans.(d)
Sol. Using a query makes it easier to view, add, delete, or change data in your Access database. Some other reasons for using queries:
Find specific quickly data by filtering on specific criteria (conditions), Calculate or summarize data
Automate data management tasks, such as reviewing the most current data on a recurring basis.

S5. Ans. (d)
Sol. All of these can be stored by primary memory.

S6. Ans.(c)
Sol. A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

S7.Ans.(a)
Sol. To move to the next worksheet in a workbook press ctrl+ page down

S8.Ans.(b)
Sol. Dots per inch (DPI) measure density of the pixels on a computer screen.

S9. Ans.(c)
Sol. In latest version there are 1,048,576 rows by 16,384 columns.

S10. Ans. (e)
Sol. Functions are predefined formulas and are already available in Excel. They are used to compute dynamically the results from Excel data.