TExES Tech Apps Quiz: Office Productivity!

27 Questions | By Jholland | Last updated: Feb 22, 2021 | Total Attempts: 849

Questions

Settings

or Create Online Test

TExES Tech Apps Quiz: Office Productivity!

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

The highlighted section of the graphic represents the...
- A.
  
  Binding column
- B.
  
  Gutter
- C.
  
  Spinal margin
- D.
  
  Mirror
- E.
  
  Publishing slice
8.

In a database with multiple tables, tables are linked through a...
- A.
  
  Query
- B.
  
  Primary key
- C.
  
  Hyperlink
- D.
  
  Dependent annotation
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
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
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.
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.
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
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
15.

The effects that are displayed between slides in a slideshow are called...
- A.
  
  Tweens
- B.
  
  Animations
- C.
  
  Advancements
- D.
  
  Transitions
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
17.

A spreadsheet can be considered a "flat" database.
- A.
  
  True
- B.
  
  False
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
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
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
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
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.
23.

What type of font face is this?
- A.
  
  Serif
- B.
  
  Sans Serif
- C.
  
  Block
- D.
  
  Open Text
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
25.

Which type of font is best for readability of body copy?
- A.
  
  Serif
- B.
  
  Sans serif
- C.
  
  Roundhand
- D.
  
  Monospace