Week 8 Computer Skills Final Part 2.3

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 7,496
| Attempts: 57
SettingsSettings
Please wait...
  • 1/25 Questions

    A TABLE IS

    • USED TO RETRIEVE SPECIFIC DATA
    • A SET OF COLUMNS AND RECORDS
    • USED TO AUTOMATE TASKS
Please wait...
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.

Week 8 Computer Skills Final Part 2.3 - Quiz

Quiz Preview

  • 2. 

    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 SLIDE
    Explanation
    If you select a slide and click the delete command on the home tab, it will delete the slide.

    Rate this question:

  • 3. 

    A POWERPOINT PRESENTATION IS MADE UP OF A SERIES OF

    • SLIDES

    • LAYOUTS

    • PICTURES

    Correct Answer
    A. SLIDES
    Explanation
    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:

  • 4. 

    ACCESS IS CALLED A RELATIONAL DATABASE MANAGEMENT SYSTEM

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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. 

    ONCE YOU HAVE SELECTED DESIGN VIEW YOU CAN SWITCH TO ANY OTHER VIEW DURING THE CREATION OF YOUR DATABASE

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 6. 

    A RELATED LIST OF COLUMNS AND ROWS USED TO STORE INFORMATION IS A

    • TABLE

    • FIELD

    • NAVIGATION PANE

    Correct Answer
    A. TABLE
    Explanation
    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:

  • 7. 

    EXAMPLES OF A PAPER DATABASE ARE TELEpHONE AND ADDRESS BOOKS

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because telephone and address books are examples of paper databases. These books contain organized information about people's phone numbers and addresses, making them a form of database. While they may not be as advanced as electronic databases, they serve the purpose of storing and retrieving information in a physical format.

    Rate this question:

  • 8. 

    YOU CANNOT USE A TEMPLATE IS THE ONLY WAY  TO CREATE A TABLE IN ACCESS

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 9. 

    IT IS A GOOD IDEA TO THING OF A RELATIONSHIP AS HAVING 'SIDES' IN ACCESS

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 10. 

    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 VALUES
    Explanation
    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:

  • 11. 

    UNDO AND REDO DO NOT APPEAR ON THE QUICK ACCESS TOOLBAR

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 12. 

    OTHER SPREADSHEET SOFTWARE HAVE LIMITATIONS BECAUSE THEY

    • USE THIN DATA

    • ARE A FLAT FILE

    • JUST DON'T WORK

    Correct Answer
    A. ARE A FLAT FILE
    Explanation
    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:

  • 13. 

    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
  • 14. 

    PLACE HOLDERS ARE

    • DOTTED BORDERS

    • FRAMES

    • BOXES

    Correct Answer
    A. DOTTED BORDERS
    Explanation
    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:

  • 15. 

    YOU CANNOT CHANGE THE LAYOUT OF AN EXISTING SLIDE BY CLICKING CHART

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 16. 

    THE MAIN CONTROL CENTER FOR EACH DATABASE IS THE

    • NAVIGATION PANE

    • DATASHEET TAB

    • TOOLBAR

    Correct Answer
    A. NAVIGATION PANE
    Explanation
    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:

  • 17. 

    ACCESS ALLOWS YOU TO 

    • CONNECT UNRELATED DATA

    • SUMMARIZE, EXTRACT AND DUPLICATE

    • EXTRACT, ORGANIZE AND DUPLICATE

    Correct Answer
    A. EXTRACT, ORGANIZE AND DUPLICATE
    Explanation
    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:

  • 18. 

    WHICH MICROSOFT OFFICE PROGRAMS/SOFTWARES HAVE THE RIBBON

    • ALL OF THEM

    • WORD AND POWERPOINT

    • WORD, EXCEL, ACCESS, POWERPOINT

    Correct Answer
    A. WORD, EXCEL, ACCESS, POWERPOINT
    Explanation
    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:

  • 19. 

    EURO IS A 

    • FORMULA

    • CELL NAME

    • DATA TYPE

    Correct Answer
    A. DATA TYPE
    Explanation
    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:

  • 20. 

    WHICH DATABASE COMMAND BELOW ALLOWS YOU TO START FROM SCRATCH

    • NEW

    • CREATE

    • START

    Correct Answer
    A. CREATE
    Explanation
    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:

  • 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 ABOVE
    Explanation
    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. 

    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
  • 23. 

    IT IS IMPORTANT TO PLACE ALL YOUR DATA IN ONE TABLE

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 24. 

    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 OPTIONS
    Explanation
    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:

  • 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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 27, 2011
    Quiz Created by
    PCDAC
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.