CSC 100

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first? a. $M$3/4 c. (G15-G14) b. (G15-G14)*$M$3 d. (G15-G14)/4

(G15-G14)

By default, table cells have ____ left and right cell margins with no spacing between the cells. a. .08" c. .05" b. .03" d. .10"

.08"

The Excel operator for division is ____. a. / c. % b. \ d. ^

/

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet? a. =A1^A2 c. 10^2 b. 20 d. 100

100

The default Accounting number format adds dollar signs and ____ decimal places to the data. a. one c. three b. two d. four

2

You write your letter and insert merge fields in step ____ of the mail merge process. a. 1 c. 4 b. 3 d. 5

4

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet? a. =A1/A2 c. 5 b. =10/2 d. Error

5

Which of the following comparison operators means "less than or equal to"? a. > c. < b. >= d. <=

<=

Which of the following comparison operators means "not equal to"? a. +=+ c. <<>> b. =/= d. <>

<>

All Excel formulas begin with the ____. a. plus sign (+) c. equal sign (=) b. asterisk (*) d. slash (/)

=

Which of the following comparison operators means "greater than"? a. > c. < b. >= d. <=

>

To find numbers greater than or equal to 500, use which comparison operator? a. <> c. >> b. <= d. >=

>=

The wildcard character that stands for any single character is the ____. a. Ampersand (&) c. Exclamation mark (!) b. Question mark (?) d. Caret (^)

?

Which of the following cannot be a data source for a mail merge? a. An Excel worksheet c. A PowerPoint presentation b. An Outlook contact list d. An Access database

A Powerpoint presentatiom

What happens to a word you type that is not in the electronic dictionary? a. A wavy red line appears under the word. b. A wavy blue line appears under the word. c. The word appears in red type. d. The Mini spell checker appears.

A wavy red line appears under the word.

The Corrections button is in the ____ group. a. Color c. Format b. Adjust d. Illustrations

Adjust

A content placeholder can be used to insert ____. a. clip art c. tables b. charts d. all of the above

All of the above

Which of the following items can you import into a presentation? a. digital images c. text b. numerical data d. all of the above

All of the above

With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____. a. Microsoft Word c. Microsoft Access b. Microsoft Excel d. All of the above

All of the above

The wildcard character that stands for any group of characters is the ____. a. Period (.) c. Asterisk (*) b. Semicolon (;) d. Plus sign (+)

Asterisk*

When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder? a. Autofit Options c. Text Options b. Autofit Text d. AutoFont Options

Autofit Options

Which chart type would you use to compare distinct objects over time using horizontal bars? a. Area c. Column b. Bar d. Line

Bar

In the formula =D1+C1/F3, which calculation will be performed first? a. C1/F3 c. D1/F3 b. D1+C1 d. D1+F3

C1/F3

This control is used to display "yes" or "no" answers for a field. a. Check box c. Combo box b. List box d. Option box

Check Box

____ are rules or limiting conditions you set to determine which records will be selected in a filter or query. a. Criteria c. Queries b. Filters d. None of the above

Criteria

Microsoft Access can best be described as ____ software. a. Spreadsheet c. Database b. Presentation d. Systems

Database

Themes are found on the ____ tab. a. Layout c. Design b. Style d. Theme

Design

Which key is used to insert a blank line in a document? a. Tab c. Insert b. Spacebar d. Enter

Enter

Which of the following is an exception to copyright protection? a. copyright infringement c. fair use b. cyberlaw d. intellectual property

Fair use

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____. a. Object c. Field b. Record d. Table

Field

Which two properties are required for every field? a. Field Name and Data Type c. Data Type and Format b. Field Name and Field Size d. Field Size and Format

Field Name and Data Type

A(n) ____ is a saved view of the data whose criteria is not discarded when you close the datasheet. a. Query c. Find b. Filter d. Union

Filter

Which of the following formats cannot be changed using the Paragraph dialog box? a. Indents c. Line Spacing b. Font d. Alignment

Font

Use this form creation tool to create a form by answering a series of questions provided by dialog boxes. a. Form Wizard c. Split Form b. More Forms d. Navigation

Form Wizard

To move an object to the back of the stack, click the Send Backward button in the Arrange group on the Drawing Tools ____ tab. a. Design c. Grouping b. Format d. Stacking

Format

____ are blue dotted lines that show the boundaries of cells, but do not print. a. Gridlines c. Guidelines b. Borders d. Cell lines

Gridlines

The Font Color button is on the ____ tab. a. Format c. Insert b. Home d. Design

Home

The New Slide button is in the Slides group on the ____ tab. a. Slides c. Insert b. Home d. Design

Home

You can insert a logo on a form using the ____ button on the Design tab. a. Graphic Art c. Graphic Image b. Art d. Insert Image

Insert Image

How do you force text in a column to the top of the next column? a. Insert a continuous break b. Insert a column break c. Insert a page break d. Apply text wrapping

Insert a column break

Use the ____ command on the Table menu to create a table with any number of columns and rows and then select an AutoFit behavior. a. Quick Tables c. Insert Table b. Draw Table d. New Table

Insert table

Which button is not on the Mini toolbar? a. Format Painter c. Font b. Line and Paragraph Spacing d. Italic

Line and Paragraph Spacing

A join line is also called a ____ line. a. Query c. Connection b. Link d. Objectivity

Link

This control displays a list of possible data entries from which the user can choose. a. Label c. List box b. Text box d. Tab control

List Box

Which of the following would you NOT find in the data source? a. Data fields c. Data records b. Field names d. Merge fields

Merge fields

Data sources created in Word are saved in ____ format. a. Microsoft Office Data Source c. Microsoft Office Mail Merge b. Microsoft Office Address Lists d. Microsoft Office Record Lists

Microsoft Office Address Lists

Clicking the ____ button in the Themes group displays the All Themes gallery window. a. Gallery c. Expand b. More d. Maximize

More

Click the _____ button list arrow to take advantage of more crop options. a. Picture c. Crop b. Insert d. None of the above

None of the above

The default view that PowerPoint opens in is called ____. a. Slide c. Standard b. Normal d. Edit

Normal

Other than the Slide pane, where can you enter slide text? a. Slide view c. Slide Sorter view b. Notes pane d. Outline tab

Notes pane

Tables, queries, and forms are examples of Access ____. a. Entities c. Values b. Objects d. Controls

Objects

The ____ tab does not show any graphics or objects. a. Slide Show c. Outline b. Handouts d. Normal

Outline

Which Word view can be helpful for editing and formatting longer documents that include multiple headings? a. Outline c. Full Screen Reading b. Print Layout d. Web Layout

Outline

Which task does Word not give you the ability to accomplish? a. Perform calculations in a spreadsheet. b. Format text and paragraphs with fonts and colors. c. Copy and move text between documents. d. Add graphics and charts to a document.

Perform calculations in a spreadsheet.

Which type of document would you create with the Word Mail Merge feature? a. Resume c. Presentation b. Spreadsheet d. Personalized form letter

Personalized form letter

Pressing [Shift] as you drag to create a shape maintains the shape's ____ as you change its size. a. proportions c. placement on the slide b. style d. alignment

Proportion

A group of related fields, such as all the demographic information for one customer, is called a(n) ____. a. Record c. Database b. Table d. Object

Record

Which tab contains the tools for inserting and managing footnotes and endnotes? a. Page Layout c. Review b. References d. Insert

References

The term ____ database comes from the fact that two or more tables are linked by a common field. a. Hierarchical c. Schematic b. Network d. Relational

Relational

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers. a. Relational database c. Record b. Field d. Object

Relational database

The ____ organizes all of PowerPoint's primary commands. a. Standard toolbar c. Quick Access toolbar b. Tab group d. Ribbon

Ribbon

The ____ option helps fit the data on a single page without making changes to individual margins. a. Scale to Fit c. Page Break View b. Paginate d. Squeeze

Scale to fit

Which element of the Word program window is used to display different parts of the document? a. Tabs c. Vertical ruler b. Ribbon d. Scroll bars

Scroll bar

Click the ____ option button in the Mail Merge task pane to use an Outlook contact list as a data source for a merge. a. Use Outlook contacts list c. Select from Outlook contacts b. Select Contacts d. Mail Merge Recipients

Select from Outlook contacts

How do you insert multiple rows at the same time? a. Click Insert Multiple Rows in the Rows & Columns group. b. Select the number of rows you want to insert, then use the buttons in the Rows & Columns group to insert the new rows. c. Select one row and click the Insert Above or Insert Below button. You will be prompted to choose how many rows to insert. d. You cannot insert multiple rows at the same time.

Select the number of rows you want to insert, then use the buttons in the Rows & Columns group to insert the new rows.

A ____ graphic is a professional-quality diagram that visually illustrates text. a. bitmap c. SmartArt b. clip art d. theme

SmartArt

Which tab or dialog box do you use to organize your sources? a. Source Organizer dialog box c. Source Manager tab b. Source Manager dialog box d. Citations & Bibliography dialog box

Source Manager dialog box

Which automatic feature causes red and green wavy lines to appear under words as you type? a. ScreenTips c. Spelling and Grammar b. AutoComplete d. AutoCorrect

Spelling and Grammar

The Font Color gallery includes the Theme Colors and the ____ Colors. a. Basic c. Primary b. Complimentary d. Standard

Standard

A presentation with a clear message that reads like a ____ and is illustrated with appropriate visual aids will have the greatest impact on your audience. a. billboard c. novel b. Web page d. story

Story

SQL stands for ____. a. Structured Query Lingo c. Standard Query Language b. Standard Query Lingo d. Structured Query Language

Structured Query Language

You can radically change how the SmartArt graphic looks by applying a SmartArt ____. a. Style c. Design b. Theme d. Border

Style

A collection of records for a single subject, such as all of the customer records, is called a(n) ____. a. Table c. Element b. Control d. Object

Table

A SmartArt graphic consists of two parts: the SmartArt graphic itself and a(n) ____ pane. a. Text c. Writing b. Editing d. Bullet

Text

Which of the following would NOT be considered a graphic image? a. Picture c. Text b. Logo d. Clip art

Text

What are shadows and outlines examples of? a. Text effects c. Font effects b. Text styles d. Font styles

Text effects

What happens when you click the Zoom level button? a. The Zoom dialog box opens. b. The current document zooms to Page Width view. c. The zoom level increases by five. d. The current document zooms to 100%.

The Zoom dialog box opens.

What happens when you click an item on the Office Clipboard? a. The item is moved to the system Clipboard. b. A ScreenTip appears. c. The item is deleted from the Office Clipboard. d. The item is pasted in the document at the location of the insertion point.

The item is pasted in the document at the location of the insertion point.

Which of the following cannot be changed on the Print tab in Backstage view? a. The text of the document c. The number of copies to print b. The range of pages to print d. The default printer

The text of the document

When would you need to divide a document into sections? a. To format the sections with different fonts. b. To change the page orientation of one page in the document. c. To add page numbers to the document. d. To add headers and footers to the document.

To change the page orientation of one page in the document.

Where in the Word program window would you find the top and bottom margins? a. Vertical ruler c. Horizontal ruler b. Vertical scroll bar d. Horizontal scroll bar

Vertical ruler

Which of the following statements about citations is not true? a. Citations usually include the name of the author and, for print sources, a page number. b. When you add a new citation to a document, the source is automatically added to the bibliography when you generate it. c. You can edit a citation by clicking the Citation Options list arrow next to the citation, then clicking Edit Citation. d. When you add a new citation to a document, the source is only associated with that document and is not available for use in other documents.

When you add a new citation to a document, the source is only associated with that document and is not available for use in other documents.

Which data type stores only one of two values? a. Attachment c. Yes/No b. Hyperlink d. Null

Yes/No

The Excel operator for exponent is ____. a. / c. % b. \ d. ^

^

____ operators perform mathematical calculations such as adding and subtracting. a. Text concatenation c. Arithmetic b. Reference d. Comparison

arithmetic

Double-clicking the right edge of a column heading activates the ____ feature for the column. a. AutoCorrect c. AutoFit b. Format d. Format as Table

autofit

Cells and ranges in a worksheet can be formatted ____. a. only before data is entered b. only after data is entered c. before or after data is entered d. at the same time data is entered

before or after the data is entered

The cell in the fifth row of the third column is cell ____. a. 5C c. E3 b. 3E d. C5

c5

When cells or rows are inserted or deleted in an Excel worksheet, ____. a. cell references are not affected b. the user must insert new cell references c. the user is prompted to enter new cell references d. cell references are automatically adjusted

cell references are automatically adjusted

How do you add new reference sources in the Research task pane? a. Click Research options c. Click the Research task pane list arrow b. Click Insert Resource d. Click Add Resource

click research options

###### in a cell means that the ____________. a. formula contains an error c. label has a spelling error b. value contains an error d. column is too narrow to display the value completely

column is too narrow to display the value completely

A pie chart ____. a. compares distinct, unrelated objects over time using a horizontal format b. compares trends over even time intervals c. compares trends over uneven time or measurement intervals d. compares sizes of pieces as part of a whole

compares sizes of pieces as part of a whole

What is the keyboard shortcut for pasting text? a. [Ctrl][C] c. [Ctrl][X] b. [Ctrl][P] d. [Ctrl][V]

ctrl+V

What is the keyboard shortcut for cutting text? a. [Ctrl][X] c. [Ctrl][Q] b. [Ctrl][C] d. [Ctrl][A]

ctrl+X

A collection of related data points is called a ____. a. data marker c. data point b. tick mark d. data series

data series

What tool helps you detect and remove private or confidential information from a document? a. Document Inspector c. Privacy Inspector b. Protect Document d. Prepare Document

document inspector

You can change, or ________, the contents of an active cell at any time. a. recover c. edit b. navigate d. calculate

edit

A chart that is inserted directly in the current worksheet is called a(n) ____ chart. a. inner c. sub b. embedded d. interactive

embedded

Which key do you press to create the next bullet in an existing bulleted list? a. Tab c. Shift b. Enter d. Insert

enter

In a pie chart, slices that are pulled away are said to be ____. a. identified c. opened b. exploded d. extracted

exploded

A(n) ____ is a built-in formula that uses arguments to calculate information. a. label c. template b. function d. indicator

function

In Excel, MAX and AVERAGE are examples of _____. a. functions c. lists b. arguments d. buttons

function

A(n) ____ identifies each data series in a chart, generally with a different color. a. axis c. data marker b. data point d. legend

legend

After you enter text in a placeholder, the placeholder becomes a text ____. a. block c. object b. box d. frame

object

Possible paper orientations for printing a worksheet are landscape and ____. a. preview c. normal b. portrait d. page break

portrait

Use the ____ command to save the current object with a new name. a. Datasheet c. Save Object As b. View d. Save

save object as

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data. a. database c. dataform b. spreadsheet d. project

spreadsheet

In Excel, a worksheet is contained in a file called a ____. a. workbook c. notebook b. workpad d. datapad

workbook

In Excel, the electronic spreadsheet you work in is called a ____. a. tablet c. numericsheet b. databook d. worksheet

worksheet

On a chart created in Excel, the horizontal axis is called the ____. a. x-axis c. data marker b. y-axis d. legend

x-axis

On a chart created in Excel, the vertical axis is called the ____. a. x-axis c. data marker b. y-axis d. legend

y-axis