TExES Tech Apps Quiz: Office Productivity!

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 Jholland
J
Jholland
Community Contributor
Quizzes Created: 7 | Total Attempts: 8,991
| Attempts: 891
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/27 Questions

    How would you get a title to appear on every page in a document?

    • Use a header
    • Insert a text box
    • Insert a recursive text box
    • Use a title field tag
Please wait...
About This Quiz

This quiz covers portions of the exam that pertains to Office Productivity. The TExES series is a group of exams conducted by the State Board for Educator Certification (SBEC) and managed by the Educational Testing Service (ETS). This quiz has been created to test your knowledge and the basic understanding of about
office productivity questions.

TExES Tech Apps Quiz: Office Productivity! - Quiz

Quiz Preview

  • 2. 

    To center an object on screen in a desktop publishing document, it is best to use...

    • Tabs

    • Tags

    • Center justification

    • Rulers

    Correct Answer
    A. Center justification
    Explanation
    To center an object on screen in a desktop publishing document, it is best to use center justification. Center justification aligns the object in the center of the page both horizontally and vertically, ensuring it is evenly balanced and visually appealing. This method is preferred over using tabs, tags, or rulers, as it provides a more precise and consistent centering of the object on the screen.

    Rate this question:

  • 3. 

    To sum or average numbers in a spreadsheet, the data must be listed as what data type?

    • Text

    • Number

    • Currency

    • Accounting

    • Custom

    Correct Answer
    A. Number
    Explanation
    To sum or average numbers in a spreadsheet, the data must be listed as the "Number" data type. This is because mathematical operations like addition and averaging can only be performed on numerical values. Listing the data as text, currency, accounting, or custom data types would not allow for these calculations to be accurately performed.

    Rate this question:

  • 4. 

    A spreadsheet can be considered a "flat" database.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Flat databases are those that have only one table- as opposed to relational databases that have multiple, linked tables.

    Rate this question:

  • 5. 

    The effects that are displayed between slides in a slideshow are called...

    • Tweens

    • Animations

    • Advancements

    • Transitions

    Correct Answer
    A. Transitions
    Explanation
    Transitions are the effects that are displayed between slides in a slideshow. They help to create a smooth and visually appealing flow between different slides. Transitions can include various effects such as fade, dissolve, slide, or zoom, which enhance the visual experience for the audience. By using transitions, presenters can make their slideshows more engaging and professional-looking.

    Rate this question:

  • 6. 

    To manage student data in a school with hundreds of students, which type of productivity application would be most suitable?

    • Spreadsheet

    • Gradebook

    • Database

    • Project Manager

    • Concept Mapping

    Correct Answer
    A. Database
    Explanation
    A database would be the most suitable productivity application for managing student data in a school with hundreds of students. Databases are designed to efficiently store and organize large amounts of data, making it easier to manage and retrieve specific information about students. They allow for the creation of tables and relationships between different types of data, such as student information, grades, attendance records, and more. Additionally, databases offer features like search and filtering capabilities, which are essential for efficiently managing and analyzing student data in a school setting.

    Rate this question:

  • 7. 

    Words or short phrases at the end or beginning of paragraphs that are left to sit alone at the top or bottom of a column that is separated from the rest of the paragraph are called...

    • Residual text

    • Misplaced modifiers

    • Stray cats

    • Widows & orphans

    Correct Answer
    A. Widows & orphans
    Explanation
    Widows & orphans refers to words or short phrases at the end or beginning of paragraphs that are left alone at the top or bottom of a column, separated from the rest of the paragraph. This term is commonly used in typesetting and publishing to describe the layout issue where a paragraph is visually disrupted by having a single line or word isolated from the rest of the text.

    Rate this question:

  • 8. 

    A spreadsheet or database that has both the first and last names in the same field violates the rules of normalization.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    First and last name data should always be stored in separate fields.

    Rate this question:

  • 9. 
    The large "O" in this text is called a... - ProProfs

    The large "O" in this text is called a...

    • Drop Cap

    • Leading Serif

    • Docked Cap

    • Printer's Cap

    • Shakespeare Mark

    Correct Answer
    A. Drop Cap
    Explanation
    A drop cap is a large capital letter at the beginning of a paragraph or section of text that is used to visually enhance the layout and draw attention to the start of the content. It is often used in books, magazines, and other printed materials to add a decorative element and improve readability.

    Rate this question:

  • 10. 

    Linking data to a graph rather than copying and pasting the graph is advantageous because...

    • It displays more detail.

    • It provides more accurate data.

    • It is easier to read.

    • It allows for future changes.

    Correct Answer
    A. It allows for future changes.
    Explanation
    Linking data to a graph instead of copying and pasting the graph is advantageous because it allows for future changes. When data is linked to a graph, any updates or modifications made to the original data will automatically be reflected in the graph. This ensures that the graph is always up to date and eliminates the need to manually update the graph every time the data changes. This not only saves time and effort but also reduces the chances of errors or inconsistencies in the graph. Therefore, linking data to a graph provides flexibility and adaptability for future changes.

    Rate this question:

  • 11. 

    For most database applications, which command would you use to share data with other individuals or applications?

    • Copy

    • Export

    • Link

    • Backup

    • Import

    Correct Answer
    A. Export
    Explanation
    Most databases exchange data using the Export function. This can create data in several types of file formats such as .csv, .txt, .tab, and others.

    Rate this question:

  • 12. 
    What type of font face is this? - ProProfs

    What type of font face is this?

    • Serif

    • Sans Serif

    • Block

    • Open Text

    Correct Answer
    A. Serif
    Explanation
    Serif is the correct answer because serif fonts have small decorative lines or strokes at the ends of characters. These lines help guide the eye along the text and make it easier to read. Examples of serif fonts include Times New Roman and Georgia.

    Rate this question:

  • 13. 

    To print a poster across multiple pages, it may be necessary to use...

    • Rasterization

    • Tiling

    • Gutter expansion

    • Print to fit

    Correct Answer
    A. Tiling
    Explanation
    Tiling is the correct answer because when printing a poster across multiple pages, tiling refers to dividing the poster into smaller sections or tiles that can fit on individual pages. This allows for easier printing and assembly of the final poster. By using tiling, each tile can be printed separately and then pieced together to recreate the complete poster.

    Rate this question:

  • 14. 

    The hyphen that appears in the following text is called a(n)... 8:00-9:00

    • Em dash

    • En dash

    • Elipse

    • Tilde

    Correct Answer
    A. En dash
    Explanation
    Remember that an "en dash" shows duration.

    Rate this question:

  • 15. 

    When a paragraph has all but the first line indented, it is said to have a...

    • Negative indent

    • Trailing indent

    • Widowed indent

    • Hanging indent

    • Cross-tab indent

    Correct Answer
    A. Hanging indent
    Explanation
    A hanging indent refers to a formatting style where all lines of a paragraph are indented except for the first line. This is commonly used in academic papers, bibliographies, and references. The purpose of a hanging indent is to visually separate and highlight each entry, making it easier for readers to identify and locate specific information.

    Rate this question:

  • 16. 
    The highlighted section of the graphic represents the... - ProProfs

    The highlighted section of the graphic represents the...

    • Binding column

    • Gutter

    • Spinal margin

    • Mirror

    • Publishing slice

    Correct Answer
    A. Gutter
    Explanation
    The highlighted section of the graphic represents the gutter. The gutter is the space between two facing pages in a book or magazine, where the pages are bound together. It allows for the binding of the pages and ensures that the content is properly aligned and centered. The gutter is an important aspect of book design and layout, as it affects the readability and overall appearance of the publication.

    Rate this question:

  • 17. 

    The character used to separate pieces of data in a data file is called a...

    • Delimiter

    • Separator

    • Monospace

    • Pica

    • Tilde

    Correct Answer
    A. Delimiter
    Explanation
    A delimiter is a character used to separate pieces of data in a data file. It acts as a boundary or marker between different sections of data within the file. Delimiters are commonly used in various file formats, such as CSV (Comma-Separated Values) files, where commas are used as delimiters to separate different data values. They help in organizing and structuring data in a file, making it easier to read and process by software applications.

    Rate this question:

  • 18. 

    A relational database that is set up in such a way that changing data in one table also changes that same data stored in another table is said to have...

    • Complete autonomy

    • Cross-tab security

    • Referential integrity

    • Double-check automation

    Correct Answer
    A. Referential integrity
    Explanation
    Referential integrity is a property of a relational database where relationships between tables are enforced. It ensures that any foreign key values in one table must match a primary key value in another table. This means that if data is changed in one table, the corresponding data in another table will also be automatically updated or deleted to maintain consistency and prevent orphaned records. Therefore, a relational database that has referential integrity set up will ensure that changing data in one table also changes that same data stored in another table.

    Rate this question:

  • 19. 
    Which of the following would you drag to change the location of the tab stop? - ProProfs

    Which of the following would you drag to change the location of the tab stop?

    • Choice A

    • Choice B

    • Choice C

    • Choice D

    • None of the Above

    Correct Answer
    A. Choice D
    Explanation
    To change the location of the tab stop, you would typically drag the tab stop marker on the ruler. However, since none of the choices provided are specific markers or tools for adjusting tab stops, the correct answer is "None of the Above".

    Rate this question:

  • 20. 

    While a spreadsheet could be used to track student grades, using electronic grade books are more advantageous because...

    • They have complex formulas and calculations built into them.

    • They are more reliable.

    • They have better color schemes.

    • They have more flexibility in reporting options.

    Correct Answer
    A. They have complex formulas and calculations built into them.
    Explanation
    Electronic grade books have complex formulas and calculations built into them, which makes it easier for teachers to calculate and analyze student grades. These formulas can automatically calculate averages, weighted scores, and generate reports. This saves time and reduces the chances of human error. Additionally, electronic grade books can provide more detailed and accurate data analysis compared to spreadsheets.

    Rate this question:

  • 21. 

    Which type of productivity software would be best for analyzing tasks and breaking them down into their individual components?

    • Database

    • Spreadsheet

    • Concept Mapping

    • Word Processor

    • Email

    Correct Answer
    A. Concept Mapping
    Explanation
    Concept mapping software is the best type of productivity software for analyzing tasks and breaking them down into their individual components. Concept mapping allows users to visually organize and connect ideas, making it easier to understand the relationships between different components of a task. It is particularly useful for brainstorming, planning, and problem-solving. With concept mapping software, users can create diagrams, flowcharts, and mind maps to break down complex tasks into manageable parts and identify the connections between them. This helps in improving productivity and efficiency by providing a clear overview and structure for task analysis.

    Rate this question:

  • 22. 

    Which type of font is best for readability of body copy?

    • Serif

    • Sans serif

    • Roundhand

    • Monospace

    Correct Answer
    A. Serif
    Explanation
    Serif fonts are considered the best for readability of body copy because they have small lines or strokes at the ends of characters, which helps guide the reader's eyes along the text. The serifs create a clear distinction between each letter, making it easier for the reader to recognize and differentiate them. This enhances legibility, especially in longer passages of text. Sans serif fonts, on the other hand, lack these small lines and are often used for headlines or titles, as they are considered more modern and sleek. Roundhand and monospace fonts are not typically used for body copy due to their unique and specific design characteristics.

    Rate this question:

  • 23. 

    In a database with multiple tables, tables are linked through a...

    • Query

    • Primary key

    • Hyperlink

    • Dependent annotation

    Correct Answer
    A. Primary key
    Explanation
    In a database with multiple tables, tables are linked through a primary key. The primary key is a unique identifier for each record in a table, and it is used to establish relationships between tables. By linking tables through the primary key, data can be retrieved and combined from multiple tables using queries. This ensures data integrity and allows for efficient data management and retrieval in a relational database system.

    Rate this question:

  • 24. 

    The text stored in separate fields in a database or spreadsheets can be combined into one text string using which function?

    • Demarkation

    • Concatenation

    • Join

    • Summation

    Correct Answer
    A. Concatenation
    Explanation
    Concatenation is the process of combining separate text strings into one. It is commonly used in databases or spreadsheets to merge data from different fields into a single text string. The other options, demarkation, join, and summation, do not accurately describe this process. Demarkation refers to marking boundaries or divisions, join typically refers to combining tables in a database, and summation is the process of adding numbers together. Therefore, concatenation is the correct answer for combining separate fields into one text string.

    Rate this question:

  • 25. 
    Refer to the following graphic and select the statement that best describes the graphic. - ProProfs

    Refer to the following graphic and select the statement that best describes the graphic.

    • Paragraph 1 has less kerning than paragraph 2.

    • Paragraph 2 has greater vertical tracking than paragraph 1.

    • Paragraph 2 has less aliasing than paragraph 1.

    • Paragraph 1 has less leading than paragraph 2.

    Correct Answer
    A. Paragraph 1 has less leading than paragraph 2.
    Explanation
    Leading is synonymous with line spacing (or space between lines of text).

    Rate this question:

  • 26. 

    Tables in a relational database that are built in such a way that duplicate data is kept at a minimum are said to be...

    • Normalized

    • Minimalized

    • Secured

    • Indexed

    Correct Answer
    A. Normalized
    Explanation
    Tables in a relational database that are built in such a way that duplicate data is kept at a minimum are said to be normalized. Normalization is a process that involves organizing data in a database to eliminate redundancy and improve data integrity. By minimizing duplicate data, normalized tables help to reduce storage space, improve data consistency, and make data manipulation more efficient.

    Rate this question:

  • 27. 
    This graphic has which type of word wrapping? - ProProfs

    This graphic has which type of word wrapping?

    • In front of text

    • Behind text

    • In line with text

    • Tight

    Correct Answer
    A. Tight
    Explanation
    Tight word wrapping refers to a formatting option where the text wraps around an object closely, without leaving much space between the object and the text. In this graphic, the word wrapping is tight, meaning that the text is wrapped closely around the object depicted in the graphic.

    Rate this question:

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
  • Nov 03, 2008
    Quiz Created by
    Jholland
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.