Business Data Applications: Final Exam Review

Use a range name to reference a cell or range of cells by name rather than by cell address(es).

• True
• False

_____________ is a text function that joins together words, cell references, blank spaces, or numbers.

• TEXTJOIN
• LEN
• CONCAT
• MID

The shape representing each data point of a chart is a:

• Data marker
• Plot area
• Data series
• Legend

Which of the following is not a way you can modify a SmartArt graphic?

• Change the graphic's colors or style
• Convert the graphic to a chart
• Change the order of shapes in the graphic
• Add shapes to the graphic

To hide columns or rows temporarily, right-click the column/row heading and click Show.

• True
• False

Which of these comparison operators means NOT equal to?

• =
• <=
• =>
• <>

Insert the ____________ function to add the system date and time to any cell on the sheet.

• TEXTJOIN
• NOW
• SUMIF
• TIMEDATE

An example of a mixed cell reference is:

• $A$5
• A named cell
• A5
• A$5

A tab stop is:

• A series of characters inserted along the line between the location of the insertion point when you press the Tab key and the tab stop
• A key on the keyboard that advances the insertion point
• The location on a horizontal line to which the insertion point advances when you press the Tab key
• A temporary left and/or right margin for lines or paragraphs

To format text 45 degrees, right end angled up, use:

• Angle Clockwise
• Angle Counterclockwise
• Rotate Text Up
• Rotate Text Down