21. 1 Nibble equals to______
- a) 8 bits
- b) 16 bits
- c) 4 bits
- d) 5 bits
Answer: C - A nibble is a unit of data equal to 4 bits.
22. Formatting a cell in Number format you can't set______
- a) Decimal Places
- b) Use 1000 separator
- c) Negative numbers
- d) Currency Symbol
Answer: D - Currency symbols are set in the Currency format, not the Number format.
23. You can edit a cell by______
- a) Clicking the formula button
- b) Double clicking the cell to edit it in-place
- c) Selecting Edit > Edit Cell from the menu
- d) None of above
Answer: B - Double-clicking a cell allows you to edit its content directly.
24. PowerPoint presentations are widely used as______
- a) note outlines for teachers
- b) project presentations by students
- c) communication of planning
- d) All of above
Answer: D - PowerPoint is versatile and used for teaching, presenting projects, and planning.
25. Computer is an______device
- a) Eltron
- b) Proton
- c) Eletric
- d) Electronic
Answer: D - A computer is an electronic device that processes data.
26. How many different positions can you set for Drop Cap?
Answer: B - Drop Cap can be set in two positions: Dropped or In Margin.
27. Predict the output of the following function: power(5,2)______
- a) 32
- b) 25
- c) 10
- d) Incorrect function use
Answer: B - The `power(5,2)` function calculates 5 raised to the power of 2, which is 25.
28. Getting data from a cell located in a different sheet is called ?
- a) Accessing
- b) Referencing
- c) Updating
- d) Functioning
Answer: B - Referencing is the process of accessing data from another sheet.
29. Check the odd term out________
- a) Internet
- b) Linux
- c) Unix
- d) Windows
Answer: A - Internet is a network, while the others are operating systems.
30. Closing a Database refers to which command ?
- a) EXIT
- b) QUIT
- c) CLOSE DATABASE
- d) CLOSE FILE
Answer: C - The `CLOSE DATABASE` command is used to close a database.
31. Columns Dialog Box 2003 can be opened from________
- a) Format menu, Columns submenu
- b) Double click on column space in ruler
- c) Press Alt + O + C
- d) All of these
Answer: D - All the mentioned methods can open the Columns Dialog Box in Word 2003.
32. Command used to copy data from a Visual FoxPro table to a file in a different format.________
- a) Export to filename [type]
- b) Send to filename [type]
- c) Add to filename [type]
- d) Both (a) and (b).
Answer: A - The `export to filename [type]` command is used for this purpose.
33. Comments can be added to cells using________
- a) Edit > Comments
- b) Review > Comments
- c) File > Comments
- d) View > Comments
Answer: B - Comments are added using the Review > Comments option in Excel.
34. Computer is an ________device
- a) Electron
- b) Proton
- c) Electric
- d) Electronic
Answer: D - A computer is an electronic device that processes data.
35. Copy and Xcopy are same in the sense________
- a) Both are internal commands of DOS
- b) Both are external commands of DOS
- c) Both can be used to copy file or group of files
- d) Both (a) and (b).
Answer: C - Both commands are used to copy files or groups of files.
36. Create command creates________
- a) Table
- b) Row
- c) Column
- d) Index
Answer: A - The `CREATE` command is used to create a table in databases.
37. CTOD stands for _________
- a) Character of Date
- b) Character to Date
- c) Character for Digit
- d) None of These
Answer: B - CTOD stands for "Character to Date," a function to convert strings to dates.
38. Data can be arranged in ascending or descending order by using________
- a) Sort command from Table menu
- b) Sort command from Data
- c) Sort command from Tools menu
- d) None of these
Answer: B - The Sort command is found under the Data menu in Excel.
39. Databases store information in the form of________
- a) Reports
- b) Forms
- c) Tables
- d) None of These
Answer: C - Databases store data in tables, which consist of rows and columns.
40. DBF' stands for________
- a) Data British File
- b) Digit Base File
- c) Digit Base File
- d) Database File
Answer: D - DBF stands for "Database File," a file format used by database systems.
CITA MCQs - Master Computer Fundamentals & IT Applications | PCBooks
🚀 Preparing for your Youth Computer CITA Exam? PCBooks offers comprehensive free practice MCQs covering computer basics, MS Office, databases, and IT concepts. Perfect for:
✔️ Youth Computer Exam Certificate preparation
✔️ School/College IT courses
✔️ Basic computer literacy development
✔️ Office productivity skills enhancement
💻 Computer Fundamentals MCQs
👉 Input/Output devices and their functions
👉 Computer hardware components
👉 Operating systems basics
👉 Networking fundamentals
📝 MS Office Application MCQs
🎯 Microsoft Word formatting and features
- Page layout and document design
- Mail merge and templates
🎯 Microsoft Excel essentials
- Formulas and basic functions
- Charts and data presentation
🎯 PowerPoint presentation skills
🗄️ Database Concepts MCQs
👉 Visual FoxPro basics (as per CITA syllabus)
👉 Simple database operations
👉 Data types and table structures
👉 Basic queries and commands
🏆 Trusted by 75,000+ students nationwide for Youth Computer Exam preparation!