TExES Tech Apps Quiz: Office Productivity!
(173).jpg "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 (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.
Questions and Answers
- 1.
Which type of productivity software would be best for analyzing tasks and breaking them down into their individual components?
- A.
Database
- B.
Spreadsheet
- C.
Concept Mapping
- D.
Word Processor
- E.
Email
Correct Answer
C. Concept MappingExplanation
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:
-
- 2.
For most database applications, which command would you use to share data with other individuals or applications?
- A.
Copy
- B.
Export
- C.
Link
- D.
Backup
- E.
Import
Correct Answer
B. ExportExplanation
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:
-
- 3.
When a paragraph has all but the first line indented, it is said to have a...
- A.
Negative indent
- B.
Trailing indent
- C.
Widowed indent
- D.
Hanging indent
- E.
Cross-tab indent
Correct Answer
D. Hanging indentExplanation
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:
-
- 4.
Which of the following would you drag to change the location of the tab stop?
- A.
Choice A
- B.
Choice B
- C.
Choice C
- D.
Choice D
- E.
None of the Above
Correct Answer
D. Choice DExplanation
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:
-
- 5.
To center an object on screen in a desktop publishing document, it is best to use...
- A.
Tabs
- B.
Tags
- C.
Center justification
- D.
Rulers
Correct Answer
C. Center justificationExplanation
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:
-
- 6.
The character used to separate pieces of data in a data file is called a...
- A.
Delimiter
- B.
Separator
- C.
Monospace
- D.
Pica
- E.
Tilde
Correct Answer
A. DelimiterExplanation
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:
-
- 7.
The highlighted section of the graphic represents the...
- A.
Binding column
- B.
Gutter
- C.
Spinal margin
- D.
Mirror
- E.
Publishing slice
Correct Answer
B. GutterExplanation
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:
-
- 8.
In a database with multiple tables, tables are linked through a...
- A.
Query
- B.
Primary key
- C.
Hyperlink
- D.
Dependent annotation
Correct Answer
B. Primary keyExplanation
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:
-
- 9.
How would you get a title to appear on every page in a document?
- A.
Use a header
- B.
Insert a text box
- C.
Insert a recursive text box
- D.
Use a title field tag
Correct Answer
A. Use a headerExplanation
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.Rate this question:
-
- 10.
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...
- A.
Residual text
- B.
Misplaced modifiers
- C.
Stray cats
- D.
Widows & orphans
Correct Answer
D. Widows & orphansExplanation
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:
-
- 11.
Linking data to a graph rather than copying and pasting the graph is advantageous because...
- A.
It displays more detail.
- B.
It provides more accurate data.
- C.
It is easier to read.
- D.
It allows for future changes.
Correct Answer
D. 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:
-
- 12.
While a spreadsheet could be used to track student grades, using electronic grade books are more advantageous because...
- A.
They have complex formulas and calculations built into them.
- B.
They are more reliable.
- C.
They have better color schemes.
- D.
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:
-
- 13.
To manage student data in a school with hundreds of students, which type of productivity application would be most suitable?
- A.
Spreadsheet
- B.
Gradebook
- C.
Database
- D.
Project Manager
- E.
Concept Mapping
Correct Answer
C. DatabaseExplanation
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:
-
- 14.
To sum or average numbers in a spreadsheet, the data must be listed as what data type?
- A.
Text
- B.
Number
- C.
Currency
- D.
Accounting
- E.
Custom
Correct Answer
B. NumberExplanation
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:
-
- 15.
The effects that are displayed between slides in a slideshow are called...
- A.
Tweens
- B.
Animations
- C.
Advancements
- D.
Transitions
Correct Answer
D. TransitionsExplanation
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:
-
- 16.
To print a poster across multiple pages, it may be necessary to use...
- A.
Rasterization
- B.
Tiling
- C.
Gutter expansion
- D.
Print to fit
Correct Answer
B. TilingExplanation
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:
-
- 17.
A spreadsheet can be considered a "flat" database.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Flat databases are those that have only one table- as opposed to relational databases that have multiple, linked tables.Rate this question:
-
- 18.
Tables in a relational database that are built in such a way that duplicate data is kept at a minimum are said to be...
- A.
Normalized
- B.
Minimalized
- C.
Secured
- D.
Indexed
Correct Answer
A. NormalizedExplanation
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:
-
- 19.
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...
- A.
Complete autonomy
- B.
Cross-tab security
- C.
Referential integrity
- D.
Double-check automation
Correct Answer
C. Referential integrityExplanation
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:
-
- 20.
A spreadsheet or database that has both the first and last names in the same field violates the rules of normalization.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
First and last name data should always be stored in separate fields.Rate this question:
-
- 21.
The text stored in separate fields in a database or spreadsheets can be combined into one text string using which function?
- A.
Demarkation
- B.
Concatenation
- C.
Join
- D.
Summation
Correct Answer
B. ConcatenationExplanation
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:
-
- 22.
Refer to the following graphic and select the statement that best describes the graphic.
- A.
Paragraph 1 has less kerning than paragraph 2.
- B.
Paragraph 2 has greater vertical tracking than paragraph 1.
- C.
Paragraph 2 has less aliasing than paragraph 1.
- D.
Paragraph 1 has less leading than paragraph 2.
Correct Answer
D. Paragraph 1 has less leading than paragraph 2.Explanation
Leading is synonymous with line spacing (or space between lines of text).Rate this question:
-
- 23.
What type of font face is this?
- A.
Serif
- B.
Sans Serif
- C.
Block
- D.
Open Text
Correct Answer
A. SerifExplanation
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:
-
- 24.
The large "O" in this text is called a...
- A.
Drop Cap
- B.
Leading Serif
- C.
Docked Cap
- D.
Printer's Cap
- E.
Shakespeare Mark
Correct Answer
A. Drop CapExplanation
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:
-
- 25.
Which type of font is best for readability of body copy?
- A.
Serif
- B.
Sans serif
- C.
Roundhand
- D.
Monospace
Correct Answer
A. SerifExplanation
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:
-
- 26.
The hyphen that appears in the following text is called a(n)... 8:00-9:00
- A.
Em dash
- B.
En dash
- C.
Elipse
- D.
Tilde
Correct Answer
B. En dashExplanation
Remember that an "en dash" shows duration.Rate this question:
-
- 27.
This graphic has which type of word wrapping?
- A.
In front of text
- B.
Behind text
- C.
In line with text
- D.
Tight
Correct Answer
D. TightExplanation
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 +
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 -
Nov 03, 2008Quiz Created by
Jholland
Back to top