Week 8 Computer Skills Final Part 2.3
-
EXAMPLES OF A PAPER DATABASE ARE TELEPHONE AND ADDRESS BOOKS
-
True
-
False
-
About This Quiz
WEEK 8 COMPUTER SKILLS FINAL PART 2.3 assesses knowledge on databases, including paper and relational types, spreadsheet software limitations, and basic components of PowerPoint presentations. It tests practical understanding relevant for learners in IT fields.
Quiz Preview
- 2.
UNDO AND REDO DO NOT APPEAR ON THE QUICK ACCESS TOOLBAR
-
True
-
False
Correct Answer
A. FalseExplanation
The statement is false because Undo and Redo do appear on the Quick Access Toolbar. The Quick Access Toolbar is a customizable toolbar in Microsoft Office applications that allows users to quickly access commonly used commands. Undo and Redo are two commonly used commands that are typically included on the Quick Access Toolbar to provide users with the ability to undo or redo their actions.Rate this question:
-
- 3.
OTHER SPREADSHEET SOFTWARE HAVE LIMITATIONS BECAUSE THEY
-
USE THIN DATA
-
ARE A FLAT FILE
-
JUST DON'T WORK
Correct Answer
A. ARE A FLAT FILEExplanation
Other spreadsheet software have limitations because they are a flat file. This means that they are unable to handle complex data structures and relationships. A flat file system stores data in a simple, tabular format, without any hierarchical or relational structure. As a result, it becomes difficult to organize and analyze data efficiently. In contrast, a non-flat file system, such as a database, allows for more advanced data organization and manipulation. Therefore, the fact that other spreadsheet software are flat file systems explains their limitations.Rate this question:
-
- 4.
ACCESS IS CALLED A RELATIONAL DATABASE MANAGEMENT SYSTEM
-
True
-
False
Correct Answer
A. TrueExplanation
Access is called a relational database management system (RDBMS) because it is a software application that allows users to create, manage, and manipulate relational databases. Access follows the relational model of organizing data into tables with rows and columns, and it supports the use of SQL (Structured Query Language) for querying and manipulating the data. As an RDBMS, Access provides a structured and efficient way to store and retrieve data, ensuring data integrity and facilitating data analysis and reporting.Rate this question:
-
- 5.
A TABLE IS
-
USED TO RETRIEVE SPECIFIC DATA
-
A SET OF COLUMNS AND RECORDS
-
USED TO AUTOMATE TASKS
Correct Answer
A. A SET OF COLUMNS AND RECORDSExplanation
A table is a set of columns and records. In a database, a table is used to organize and store data in a structured manner. The columns represent different attributes or characteristics of the data, while the records represent individual instances or entries of the data. By organizing data into tables, it becomes easier to retrieve and manipulate specific data based on certain criteria.Rate this question:
-
- 6.
A POWERPOINT PRESENTATION IS MADE UP OF A SERIES OF
-
SLIDES
-
LAYOUTS
-
PICTURES
Correct Answer
A. SLIDESExplanation
A PowerPoint presentation is made up of a series of slides. Each slide contains information, such as text, images, and multimedia, that is presented to the audience in a sequential manner. Slides are the building blocks of a presentation and allow the presenter to organize and convey their message effectively. By using slides, the presenter can break down their content into manageable sections and visually enhance their presentation with various design elements.Rate this question:
-
- 7.
PLACE HOLDERS ARE
-
DOTTED BORDERS
-
FRAMES
-
BOXES
Correct Answer
A. DOTTED BORDERSExplanation
Dotted borders are a type of border style that consists of a series of small dots. They are often used to visually separate or highlight elements on a webpage or document. Dotted borders can be applied to various elements such as images, text boxes, or div containers. They provide a subtle and decorative way to add emphasis or structure to the design.Rate this question:
-
- 8.
YOU CANNOT CHANGE THE LAYOUT OF AN EXISTING SLIDE BY CLICKING CHART
-
True
-
False
Correct Answer
A. TrueExplanation
This statement is true because clicking on a chart in an existing slide will not allow you to change the layout of the slide. The layout of a slide refers to the arrangement of placeholders, text, images, and other elements on the slide. While clicking on a chart may allow you to edit or modify the chart itself, it does not give you the ability to change the overall layout of the slide. To change the layout of a slide, you would need to use the slide layout options available in the presentation software.Rate this question:
-
- 9.
IF I SELECT A SLIDE AND CLICK THE DELETE COMMAND ON THE HOME TAB
-
IT WILL COPY THE SLIDE
-
IT WILL PASTE THE SLIDE
-
IT WILL DELETE THE SLIDE
Correct Answer
A. IT WILL DELETE THE SLIDEExplanation
If you select a slide and click the delete command on the home tab, it will delete the slide.Rate this question:
-
- 10.
ACCESS ALLOWS YOU TO
-
CONNECT UNRELATED DATA
-
SUMMARIZE, EXTRACT AND DUPLICATE
-
EXTRACT, ORGANIZE AND DUPLICATE
Correct Answer
A. EXTRACT, ORGANIZE AND DUPLICATEExplanation
The correct answer is "EXTRACT, ORGANIZE AND DUPLICATE". Access is a database management system that allows users to extract data from multiple sources, organize it in a structured manner, and duplicate it as needed. This feature is particularly useful for creating reports, analyzing data, and maintaining data integrity.Rate this question:
-
- 11.
THE MAIN CONTROL CENTER FOR EACH DATABASE IS THE
-
NAVIGATION PANE
-
DATASHEET TAB
-
TOOLBAR
Correct Answer
A. NAVIGATION PANEExplanation
The navigation pane is the main control center for each database because it allows users to easily navigate through different objects and features within the database. It provides a hierarchical view of the objects, such as tables, queries, forms, and reports, allowing users to quickly access and manage these elements. Additionally, the navigation pane also provides search and filtering options, making it a powerful tool for database management.Rate this question:
-
- 12.
ONCE YOU HAVE SELECTED DESIGN VIEW YOU CAN SWITCH TO ANY OTHER VIEW DURING THE CREATION OF YOUR DATABASE
-
True
-
False
Correct Answer
A. TrueExplanation
Once you have selected design view in the creation of your database, you have the flexibility to switch to any other view such as datasheet view, form view, or report view. This allows you to easily switch between different views to perform various tasks and make changes to your database as needed.Rate this question:
-
- 13.
YOU CANNOT USE A TEMPLATE IS THE ONLY WAY TO CREATE A TABLE IN ACCESS
-
True
-
False
Correct Answer
A. FalseExplanation
The statement is false. Access provides various ways to create a table, and using a template is one of those options. Templates in Access are pre-designed table structures that can be used as a starting point for creating a new table. They can save time and effort by providing a structure that is commonly used for a specific purpose or industry.Rate this question:
-
- 14.
A RELATED LIST OF COLUMNS AND ROWS USED TO STORE INFORMATION IS A
-
TABLE
-
FIELD
-
NAVIGATION PANE
Correct Answer
A. TABLEExplanation
A table is a related list of columns and rows used to store information. It is a common data structure in databases and spreadsheets, where each column represents a specific attribute or field, and each row represents a separate record or entry. Tables are organized in a tabular format, making it easy to search, sort, and manipulate data. They provide a structured and organized way to store and retrieve information, making them an essential component in data management systems.Rate this question:
-
- 15.
EURO IS A
-
FORMULA
-
CELL NAME
-
DATA TYPE
Correct Answer
A. DATA TYPEExplanation
The correct answer is "DATA TYPE" because the question is asking for the classification or category that the term "EURO" belongs to. "DATA TYPE" refers to the type of data that the term represents, indicating that "EURO" is a specific type of data rather than a formula or cell name.Rate this question:
-
- 16.
YOU CAN CHANGE THE VIEW BY
-
ACTIVATE THE HOME TAB
-
CLICK THE UP-ARROW UNDER THE VIEW BUTTON
-
USING THE MICROSOFT BUTTON
Correct Answer
A. ACTIVATE THE HOME TAB -
- 17.
HOW MANY WAYS CAN YOU VIEW OBJECTS IN A DATABASE
-
ONE
-
TWO
-
FIVE
-
NONE OF THE ABOVE
-
ALL OF THE ABOVE
Correct Answer
A. NONE OF THE ABOVE -
- 18.
WHICH DATABASE COMMAND BELOW ALLOWS YOU TO START FROM SCRATCH
-
NEW
-
CREATE
-
START
Correct Answer
A. CREATEExplanation
The CREATE command in a database allows you to start from scratch by creating a new database or table. It is used to define the structure of the database and create new objects within it. This command is commonly used when setting up a new database or when starting a new project where no existing data or tables are present. The CREATE command provides the ability to create a fresh database or table, providing a blank slate to work with.Rate this question:
-
- 19.
IT IS A GOOD IDEA TO THING OF A RELATIONSHIP AS HAVING 'SIDES' IN ACCESS
-
True
-
False
Correct Answer
A. TrueExplanation
In Access, it is indeed a good idea to think of a relationship as having "sides". This means that when creating a relationship between two tables, one table is considered the "one" side and the other table is considered the "many" side. The "one" side is the table that has a primary key, and the "many" side is the table that has a foreign key referencing the primary key of the "one" side. This concept helps in understanding and managing the relationship between the tables effectively.Rate this question:
-
- 20.
WHAT MUST YOU DO TO CREATE A ONE-TO-ONE RELATIONSHIP IN ACCESS
-
ENABLE REFERENTIAL INTEGRITY
-
TURN OFF INDEXING FOR THE FOREIGN KEY FIELD
-
TURN ON INDEXING IN THE FOREIGN KEY FIELD WITHOUT ALLOWING DUPLICATE VALUES
Correct Answer
A. TURN ON INDEXING IN THE FOREIGN KEY FIELD WITHOUT ALLOWING DUPLICATE VALUESExplanation
To create a one-to-one relationship in Access, you need to turn on indexing in the foreign key field without allowing duplicate values. This means that each value in the foreign key field must be unique and indexed to ensure data integrity. By doing so, you can establish a direct and unique relationship between two tables in Access.Rate this question:
-
- 21.
TO ENCRYPT AND DECRYPT YOUR DATABASE YOU USE THE
-
PRIMARY KEY
-
FOREIGN KEY
-
BOTH
-
NONE OF THE ABOVE
Correct Answer
A. NONE OF THE ABOVEExplanation
The correct answer is "NONE OF THE ABOVE" because encryption and decryption of a database typically involve the use of encryption algorithms, encryption keys, and cryptographic functions, rather than primary keys or foreign keys. Primary keys and foreign keys are used for establishing relationships between tables in a database, but they do not directly relate to the encryption and decryption of the database.Rate this question:
-
- 22.
IT IS IMPORTANT TO PLACE ALL YOUR DATA IN ONE TABLE
-
True
-
False
Correct Answer
A. TrueExplanation
Placing all data in one table is important because it allows for efficient organization and retrieval of information. By having all data in one place, it becomes easier to analyze and make connections between different data points. It also reduces the risk of data duplication and inconsistencies. Additionally, having one table simplifies data management and maintenance tasks, such as backups and updates. Therefore, it is important to place all data in one table to ensure data integrity and streamline data operations.Rate this question:
-
- 23.
HOW MANY TABLES SHOULD A SPREADSHEET HAVE?
-
AS MANY AS NECESSARY
-
ONE
-
FIVE
-
ALL OF THE ABOVE ARE OPTIONS
-
NONE OF THE ABOVE ARE OPTIONS
Correct Answer
A. NONE OF THE ABOVE ARE OPTIONSExplanation
The question asks how many tables a spreadsheet should have, and the given options do not provide a correct answer. The correct answer would depend on the specific requirements and purpose of the spreadsheet. It could vary from one table to multiple tables, depending on the complexity and organization of the data being managed. Therefore, none of the options provided are suitable as a correct answer.Rate this question:
-
- 24.
WHICH MICROSOFT OFFICE PROGRAMS/SOFTWARES HAVE THE RIBBON
-
ALL OF THEM
-
WORD AND POWERPOINT
-
WORD, EXCEL, ACCESS, POWERPOINT
Correct Answer
A. WORD, EXCEL, ACCESS, POWERPOINTExplanation
All of the Microsoft Office programs/software have the ribbon. The ribbon is a graphical control element that displays various commands and options in a tabbed format. It was introduced in Microsoft Office 2007 and has been used in Word, Excel, Access, and PowerPoint ever since. The ribbon provides a more organized and intuitive way to access the different features and functionalities of these programs.Rate this question:
-
- 25.
1. CLICK THE LINK BELOW 2. READ THROUGH THE LESSON 3. FOLLOW THROUGH AND USE THE EXAMPLES TO CREATE A SLIDE IN POWERPOINT (USE YOUR OWN IMAGINATION FOR ONE SLIDE) AND BE SURE TO ADD A FOOTER 4. PRINT THE SLIDE YOU CREATED 5. SAVE THE SLIDE AS FINAL IN YOUR MY DOCUMENTS FOLDER 6. COMPLETE THE SELF-TEST 7. PRINT THE SELF-TEST http://office.microsoft.com/en-us/powerpoint-help/add-slide-numbers-and-other-footers-to-slides-RZ010258800.aspx
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 27, 2011Quiz Created by
PCDAC
Back to top