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 | Questions: 27
Please wait...
Question 1 / 27
0 %
0/100
Score 0/100
1. How would you get a title to appear on every page in a document?

Explanation

To get a title to appear on every page in a document, you would use a header. A header is a section of a document that appears at the top of each page. It typically contains information such as the document title, page numbers, or the author's name. By inserting the title into the header, it will automatically appear on every page, ensuring consistency and easy navigation throughout the document.

Submit
Please wait...
About This Quiz
TExES Tech Apps Quiz: Office Productivity! - 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... see more(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.
see less

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

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.

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

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.

Submit
4. A spreadsheet can be considered a "flat" database.

Explanation

Flat databases are those that have only one table- as opposed to relational databases that have multiple, linked tables.

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

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.

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

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.

Submit
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...

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.

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

Explanation

First and last name data should always be stored in separate fields.

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

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.

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

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.

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

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.

Submit
12. What type of font face is this?

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.

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

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.

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

Explanation

Remember that an "en dash" shows duration.

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

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.

Submit
16. The highlighted section of the graphic represents the...

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.

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

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.

Submit
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...

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.

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

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".

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

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.

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

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.

Submit
22. Which type of font is best for readability of body copy?

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.

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

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.

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

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.

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

Explanation

Leading is synonymous with line spacing (or space between lines of text).

Submit
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...

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.

Submit
27. This graphic has which type of word wrapping?

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.

Submit
View My Results

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
Cancel
  • All
    All (27)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
How would you get a title to appear on every page in a document?
To center an object on screen in a desktop publishing document, it is...
To sum or average numbers in a spreadsheet, the data must be listed as...
A spreadsheet can be considered a "flat" database.
The effects that are displayed between slides in a slideshow are...
To manage student data in a school with hundreds of students, which...
Words or short phrases at the end or beginning of paragraphs that are...
A spreadsheet or database that has both the first and last names in...
The large "O" in this text is called a...
Linking data to a graph rather than copying and pasting the graph is...
For most database applications, which command would you use to share...
What type of font face is this?
To print a poster across multiple pages, it may be necessary to use...
The hyphen that appears in the following text is called a(n)......
When a paragraph has all but the first line indented, it is said to...
The highlighted section of the graphic represents the...
The character used to separate pieces of data in a data file is called...
A relational database that is set up in such a way that changing data...
Which of the following would you drag to change the location of the...
While a spreadsheet could be used to track student grades, using...
Which type of productivity software would be best for analyzing tasks...
Which type of font is best for readability of body copy?
In a database with multiple tables, tables are linked through a...
The text stored in separate fields in a database or spreadsheets can...
Refer to the following graphic and select the statement that best...
Tables in a relational database that are built in such a way that...
This graphic has which type of word wrapping?
Alert!

Advertisement