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
