Computer Technology 2 Review: Question Preview (ID: 27360)

Below is a preview of the questions contained within the game titled COMPUTER TECHNOLOGY 2 REVIEW: Word Processing, Excel, PowerPoint .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

What function adds a range of cells?
a) =max(A1:A8)
b) =add(A1:A8)
c) =average(A1:A8)
d) =sum(A1:A8)

What option applies a format to cells based on certain criteria?
a) Conditional formatting
b) Sort
c) Freeze panes
d) Formatting

This graph shows how one part compares to the whole.
a) column graph
b) line graph
c) pie graph
d) scatter graph

A group of cells used in a formula.
a) range
b) function
c) column
d) row

This option keeps the first row in place as you scroll around a spreadsheet.
a) Split window
b) Freeze panes
c) Auto fill
d) Wrap text

Excel spreadsheets use this file format.
a) .doc
b) .pdf
c) .psd
d) .xls

This is an example of an absolute reference.
a) $A12
b) $A$12
c) A$12
d) A12

How do you show formulas in an Excel spreadsheet?
a) Control +
b) Control -
c) Control #
d) Control ~

Dividing the Word screen into two panes that you can scroll independently is...
a) mail merge
b) split window
c) column break
d) text wrap

What is SmartArt?
a) A graphic that applies a title style to the document.
b) A graphic that is darker than the text around it.
c) A graphic that links to a web page.
d) A graphic that visually represents the information in the document.

Word Processing documents can be saved as which file type?
a) .docx
b) .pdf
c) .rtf
d) all of the above

A list of items that uses numbers, letters, and/or roman numerals.
a) Bullet list
b) Numbered list
c) Multi-level list
d) Word list

In a hanging indent used for a bibliography, the second line is...
a) at the margin
b) indented 1/2 inch
c) indented 1 inch

WordArt is text that has a style applied to it and looks like a graphic.
a) True
b) False

Formatting characteristics that can be applied to text in a document.
a) Style
b) Query
c) Filter
d) Spell check

To quickly go to another place in a large document, you could create a...
a) Table
b) Hyperlink
c) Theme
d) Tab

How can you format the same document in 2 different styles?
a) Insert an endnote.
b) Insert a footnote.
c) Insert a continuous section break.
d) Insert a hanging indent.

You can control where a new page begins by using a...
a) hanging indent
b) footnote
c) column break
d) hard page break

What is a header?
a) Text that appears at the bottom of every page in the document.
b) Text that appears at the top of every page in the document.
c) Larger text, such as a title.
d) A style of text.

Allows you to view specific rows in a spreadsheet while hiding the other rows.
a) Data, Sort
b) Data, Filter
c) Data, Format
d) Data, Group

Play Games with the Questions above at
To play games using the questions from the data set above, visit and enter game ID number: 27360 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register