Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 224
Q3041:
Which tab on the Excel ribbon contains the Sort & Filter button?
A. Home
B. Insert
C. Data
D. View
Correct Answer:
A
Chapter: 224
Q3042:
To sort data in descending order, which button should you click?
A. Sort Ascending
B. Sort Descending
C. Filter
D. Custom Sort
Correct Answer:
B
Chapter: 224
Q3043:
Fill in the blank: To execute a basic sort, you first need to ________ the cells that will be sorted.
A. Highlight
B. Delete
C. Copy
D. Paste
Correct Answer:
A
Chapter: 224
Q3044:
Which function does not belong to Sorting and Filtering in Excel?
A. Sort Ascending
B. Sort Descending
C. Apply Formula
D. Custom Sort
Correct Answer:
C
Chapter: 225
Q3045:
What is a database?
A. A collection of files
B. A programming language
C. A type of spreadsheet
D. A type of software
Correct Answer:
A
Chapter: 225
Q3046:
In MS Access, information in tables is organized in the form of which two components?
A. Cells and Formulas
B. Fields and Records
C. Sheets and Rows
D. Pages and Sections
Correct Answer:
B
Chapter: 225
Q3047:
What does SQL stand for?
A. Standard Query Language
B. Simple Query Language
C. Structured Query Language
D. System Query Language
Correct Answer:
C
Chapter: 225
Q3048:
Which of the following is the most commonly used syntax for querying a relational database?
A. HTML
B. SQL
C. XML
D. CSS
Correct Answer:
B
Chapter: 225
Q3049:
In the office cleric analogy, what does the filing cabinet represent?
A. DBMS
B. Database
C. SQL
D. Table
Correct Answer:
B
Chapter: 225
Q3050:
In the office cleric analogy, who or what does the office cleric represent?
A. SQL
B. Table
C. DBMS
D. Database
Correct Answer:
C
Chapter: 225
Q3051:
Which ribbon tabs are unique to MS Access compared to MS Word and MS Excel?
A. Insert, Design, Review
B. Home, Insert, Data
C. Create, External Data, Database Tools
D. File, View, Tools
Correct Answer:
C
Chapter: 225
Q3052:
To create a new database in MS Access, which option should you select first?
A. New Database
B. Create Database
C. Blank Database
D. Open Database
Correct Answer:
C
Chapter: 225
Q3053:
Fill in the blank: SQL is used to ________ data from the database.
A. Retrieve
B. Delete
C. Format
D. Store
Correct Answer:
A
Chapter: 225
Q3054:
Which of the following is not a function of DBMS?
A. Organizing files
B. Storing data
C. Retrieving data
D. Editing documents
Correct Answer:
D
Chapter: 225
Q3055:
What is the final step to create a new database in MS Access?
A. Click Save
B. Type Database Name
C. Browse to Location
D. Click Create
Correct Answer:
D
Chapter: 225
Q3056:
Fill in the blank: In MS Access, fields and records are stored in ________.
A. Tables
B. Files
C. Ribbons
D. Documents
Correct Answer:
A
Chapter: 225
Q3057:
What is the purpose of the "Create" tab in MS Access?
A. To create new documents
B. To create new databases and database objects
C. To create new folders
D. To create new spreadsheets
Correct Answer:
B
Chapter: 225
Q3058:
Which analogy best describes the relationship between a database and DBMS?
A. Book and Author
B. Filing Cabinet and Office Cleric
C. Computer and Software
D. Website and Browser
Correct Answer:
B
Chapter: 226
Q3059:
Which tab in the Ribbon provides a quick and easy way to create tables, forms, reports, and queries in MS Access?
A. Home
B. Insert
C. Create
D. Design
Correct Answer:
C
Chapter: 226
Q3060:
What is the purpose of the Tables group in MS Access?
A. To create new databases
B. To store data in a structured format
C. To manage database relationships
D. To print reports
Correct Answer:
B