Computer Apps Final study guide

T/F To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group)

T

T/F Well-produced video clips add value when they help explain a procedure or show movement that cannot be captured in a photograph.

T

T/F When you click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.

T

T/F Word provides an Undo button that can be used to cancel the most recent command or action.

T

T/F You can clear cell contents and formatting by clicking Clear Contents on the Clear button menu.

T

T/F You cannot change the color of a video clip.

T

A _____ is a prewritten formula that is built into Excel. a. function b. feature c. task d. calculation

a. function

A _____ reference is an adjusted cell reference in a copied and pasted formula. a. revised b. relative c. recycled d. retained

b. relative

Which of the following is the path to the Insert button? a. (Home tab | Editing group) b. (Home tab | Number group) c. (Home tab | Cells group) d. (Home tab | Inserting group)

c. (Home tab | Cells group)

Which of the following is the path to the Spelling button? a. (Home tab | Proofing group) b. (Proofing tab | Spelling group) c. (Review tab | Proofing group) d. (Review tab | Checking group)

c. (Review tab | Proofing group)

To start a new line in a cell, press the _____ keys. a. CTRL+ENTER b. TAB+ENTER c. ALT+ENTER d. SHIFT+ENTER

c. ALT+ENTER

T/F A document may wordwrap differently depending on the type of printer being used.

F

T/F A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

F

T/F A single point is about 1/32 of one inch in height.

F

T/F An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

F

T/F Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

F

T/F Excel uses the default Oriel Theme for all new workbooks.

F

T/F High color saturation produces gray tones.

F

T/F If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.

F

T/F In Datasheet view, a table is represented as a collection of rows and columns called a list.

F

T/F Offsets repeat a background image many times vertically and horizontally on a slide.

F

T/F The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

F

T/F The Format Painter button is located in the Font group on the Home tab.

F

T/F The default slide layouts are set up in portrait orientation.

F

T/F A flagged word is one that is misspelled.

T

T/F A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

T

T/F A paragraph is a segment of text with the same format that begins when you press the ENTER key and ends when you press the ENTER key again.

T

T/F A rectangle object is used to insert text in a slide area where there is no text placeholder.

T

T/F A unique identifier also is called a record key.

T

T/F Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

T

T/F Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

T

T/F Green computing involves reducing the environmental waste generated when using a computer.

T

T/F If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.

T

T/F One method of adding appealing visual elements to a presentation is by using WordArt styles.

T

T/F Redundancy is the storing of a piece of data in more than one place.

T

T/F Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

T

T/F The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

T

T/F The equal sign (=) precedes a formula.

T

T/F The four colors on the Theme Colors button represent the primary text and background colors and two accent colors.

T

T/F The range of entries that determines the size of the slices in a Pie chart is called the category names.

T

_____ refers to cells not wide enough to display the entire entry. a. ##### b. &&&&& c. $$$$$ d. +++++

a. #####

What is the correct path to the Bold button? a. (Home tab | Font group) b. (Design tab | Themes group) c. (Home tab | Paragraph group) d. View tab | Presentation Views group)

a. (Home tab | Font group)

Which of the following is the Ribbon path to the Cell Styles button? a. (Home tab | Styles group) b. (Styles tab | Home group) c. (Home tab | Format group) d. (Format tab | Styles group)

a. (Home tab | Styles group)

Which of the following is the path to the Zoom button? a. (View tab | Zoom group) b. (Home tab | Zoom group) c. (Insert tab | Zoom group) d. (Zoom tab | View group)

a. (View tab | Zoom group)

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters. a. 8.43 b. 7.52 c. 11.65 d. 9.43

a. 8.43

You can insert a new slide by pressing the _____ keyboard shortcut keys. a. CTRL+M b. CTRL+I c. CTRL+N d. CTRL+HOME

a. CTRL+M

The default view in Word is ____. a. Print Layout view b. Headline view c. Web Layout view d.Outline view

a. Print Layout view

Pressing the _____ key to complete an entry activates the adjacent cell to the right. a. RIGHT ARROW b. LEFT ARROW c. UP ARROW d. DOWN ARROW

a. RIGHT ARROW

By default, text is _____ in a cell. a. left-aligned b. centered c. justified d. right-aligned

a. left-aligned

Combining two or more selected cells into one cell is called _____ cells. a. merging b. mixing c. combining d. spanning

a. merging

To change the font size of selected text, click the Decrease Font Size or Increase Font Size buttons located _____. a. on the shortcut menu b. on the Design tab c. on the Mini toolbar d. in the Paragraph gallery

a. on the shortcut menu

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure. a. range b. bunch c. nearby cell d. neighbor

a. range

With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to _____. a. use Excel to create the worksheet b. design the 3-D Pie chart c. perform calculations d. create the 3-D Pie chart

a. use Excel to create the worksheet

An Excel _____ allows data easily to be summarized and charted. a. worksheet b. workbook c. document d. presentation

a. worksheet

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. a. semi-colon (;) c. period (.) b. colon (:) d. none of the above

b. colon (:)

How many chart types does Excel offer? a. 5 b. 11 c. 29 d. 50

b. 11

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. a. AutoComplete c. AutoFormat b. AutoCorrect d. AutoTyping

b. AutoCorrect

To move left one word with the keyboard, press the ____ key(s). a. HOME b. CTRL+LEFT ARROW c. ALT+CTRL+LEFT ARROW d. ALT+LEFT ARROW

b. CTRL+LEFT ARROW

The Themes gallery is located on the _____ Ribbon tab. a. Home b. Design c. Insert d. View

b. Design

What effect does the Accounting Number Format have on the selected cells? a. Converts alphabetic characters to numbers b. Displays cell contents with two decimal places that align vertically c. Performs tax calculations d. Copies the numbers of one cell to another

b. Displays cell contents with two decimal places that align vertically

To cancel an entire entry before entering it into the cell, press the _____ key. a. ALT b. ESC c. CTRL d. TAB

b. ESC

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Normal b. Page Layout c. Page Break Preview d. Full Screen

b. Page Layout

If you accidentally insert the wrong picture on a slide, just click the Undo button on the _____. a. status bar b. Quick Access Toolbar c. File tab d. none of the above

b. Quick Access Toolbar

_____ is/are used to add worksheet, column, and row titles on a worksheet. a. Color b. Text c. Links d. Tabs

b. Text

All of the following are PowerPoint content used to customize slides except _____. a. diagrams b. databases c. video d. shapes

b. databases

When you use the keyboard to scroll to a different position in the document, the ____ automatically moves when you press the desired keys. a. roster b. insertion point c. alt tag d. smart tag

b. insertion point

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra. a. placement b. operations c. positioning d. selections

b. operations

The first step in creating an effective worksheet is to make sure you _____. a. apply font formatting b. understand what is required c. insert a chart d. enter the data

b. understand what is required

When you type the wrong character, you can press the _____ key to erase all the characters back to and including the one that is incorrect. a. ENTER b. DELETE c. BACKSPACE d. HOME

c. BACKSPACE

To enter a blank line into a document, press the ____ key without typing any text on the line. a. CTRL b. ALT c. ENTER d. ESC

c. ENTER

Clicking the _____ box completes an entry. a. Cancel b. Formula c. Enter d. Tab

c. Enter

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab. a. Portrait/Landscape b. Orientation c. Landscape d. Switch Orientation

c. Landscape

The _____ is a blinking vertical line that indicates where the next typed character will appear. a. scroll box b. sheet tab c. insertion point d. split bar

c. insertion point

The person or persons requesting the worksheet should supply their requirements in a _____ document. a. blank b. test issues c. requirements d. certified

c. requirements

The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. a. Comma style format b. Accounting number format c. Percent style format d. Currency style format

d. Currency style format

____ are words or phrases that describe a document. a. Metakeys b. Enhanced ScreenTips c. Anchors d. Keywords

d. Keywords

You should use a _____ chart to show the relationship or proportion of parts to a whole. a. Column b. Bar c. Line d. Pie

d. Pie

To enter data in a cell, you must first select or activate the _____. a. row b. worksheet c. column d. cell

d. cell

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the _____. a. receiver cell b. final cell c. receiving range d. destination area (or paste area)

d. destination area (or paste area)

The WordArt _____ is the exterior border surrounding each letter or symbol. a. effect b. fill c. depth d. outline

d. outline