CGS Final Exam

Ace your homework & exams now with Quizwiz!

Excel recognizes an entry as a value if it's a number if it begins with ____

+, =, $

Which dot pitches gives you the sharpest picture?

.26

If cell A1 contained 10, cell A2 contained 2, and cell A3 contained =A1^A2 what would cell A3 show on the worksheet

100

You can insert ___ different kinds of pictures into PowerPoint

14

You are likely to decrease the average meeting length by ___ when you use a visual presentation

26.8%

The chapter stated that ___ of what an audience learns comes directly from visual messages

55%

You are twice as likely (___) to achieve your communication objectives using a visual presentation

67%

Research shows that ___ of all environmental stimuli is received through visual reception

75%

Which symbol means greater than?

>

To find numbers greater than or equal to 500, use which comparison operator?

>=

Pressing Ctrl + ___ changes that current pointer during a slide show back to the arrow key

A

Personal computers commonly use the ___ code system to represent character data

ASCII

When you double-click a field in a field list in Query Design View, it is

Added to the next available position in the query design grid

Should you apply artistic effect before or after you compress it?

After

The Group Footer section prints ___

After every group of records

Entrance and Exit are ___

Animation categories

The Distribute commands are in the ___ group

Arrange

If you Excel worksheet is blocking your PowerPoint slide, click the ___ command to see both presentations

Arrange all

How are page numbers inserted in a document

As a field

The Report Header section prints

At the top of the first page

Which automatic feature in Word automatically corrects typos, minor spelling errors, and capitalization as you type?

Auto Correct

Which feature would you use to correct words that you frequently misspell as you type

Auto Correct

Which of the following keys will help you delete unwanted data in Edit mode?

Backspace

Copyright law is a type of intellectual property law that protects ___ (books, the expression of an idea, underlying facts, or artwork)

Books, the expression of an idea, underlying facts, artwork

The PowerPoint guides appear as dotted lines intersect at the ___ of the slide

Center

As soon as you move the pointer over the Mini toolbar, the toolbar becomes ___

Clearly visible

Which pointing device action should you use for selecting objects or commands, opening menus on the task bar?

Clicking

You can apply a chart type to an existing data series in a chart to create a(n) ___ chart

Combination

This control is both a list box and a text box control

Combo box

To control how cropped images are treated with a PowerPoint file is saved, click options in the ___ dialog box

Compression settings

Which section break begins a new section on the same page?

Continuous

When the ___ button is active, the sizing handles appear as straight black lines

Crop

When the ___ is active, the sizing handles appear as straight black lines

Crop

Documents properties include ___ (handouts, custom XML data, comments)

Custom XML data, comments

You move a file using which commands?

Cut and Paste

What Send to menu command copies the file to your computer's DVD drive?

DVD RW Drive (D:)

Controls placed in this form section print once for every record in the underlying object

Detail

The section generally constitutes the largest physical space on the report

Detail

What tool helps you detect and remove private or confidential information from a document

Document Inspector

PowerPoint uses ____, if it is installed, to create numerical charts

Excel

The Office Clipboard allows you to collect text and graphics from which other office applications before inserting them into you Word documents?

Excel, Access, PowerPoint

Which of the following is an exception to copy right protection? (copyright infringement, cyber law, fair use, intellectual property)

Fair use

T/F: A cell reference that does not change when it is copied is called a relative cell reference.

False

T/F: A chart must be located in a specific cell or at a specific address range

False

T/F: A continuous section break begins a new section and moves the text following the break to the top of the text page

False

T/F: A filter can be used to create calculated fields

False

T/F: A foreign key field is always on the "one" side of a one-to-many relationship between two sides

False

T/F: A slide template contains text and object placeholders that are arranged in a specific way on a slide

False

T/F: A slide template contains text and object placeholders that are arranged in a specific way on the slide

False

T/F: According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last

False

T/F: Bound controls exist only to clarify or enhance the appearance of the form

False

T/F: Charts are updated automatically in Excel whenever data changes

False

T/F: Copyright protects the underlying facts or concepts, but not the expression of an idea

False

T/F: DVD + R's are rewritable

False

T/F: Each clip you download is automatically inserted into the clip Gallery folder and appears in the Clip Art task pane

False

T/F: Footnotes are placed at the end of a document

False

T/F: In a window, the Address bar is located just above the title bar

False

T/F: Indent markers on the horizontal ruler always indicate the default indent settings of the document

False

T/F: Phishing is a broad term that describes any program that is intended to cause harm or convey information to others without the owner's permission

False

T/F: Pressing E highlights the annotation drawing

False

T/F: Reports are view-only objects, meaning they can be used to read and display data but cannot be used to change data

False

T/F: SQL is the acronym for "Simple Query Language"

False

T/F: Slide Show view displays thumbnails of all slides; use this view to rearrange and add special effects to your slides

False

T/F: Technical information about components on a computer are called configurations.

False

T/F: The Auto Correct feature automatically corrects all your spelling and grammar errors as you type

False

T/F: The File Inspector looks for hidden data and personal information that is stored in the file itself or in the document properties

False

T/F: The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels

False

T/F: The Navigation buttons on a datasheet display the total number of fields in the datasheet

False

T/F: The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties

False

T/F: The Paste option from the Excel Home tab allows the user to specify components of a cell's contents to be pasted

False

T/F: The Quick Access toolbar appears faintly above text when you first select it, and contains commonly used formatting commands

False

T/F: The asterisk is the wildcard used to represent one and only one character in criteria

False

T/F: The capabilities of various report views are mutually exclusive

False

T/F: The categories of functions available in Excel 2010 are financial and statistical

False

T/F: The font size is measured in units called Pixels

False

T/F: The record selector button is to the right of a record in a datasheet

False

T/F: To move text from one location to another, you have to retype the text in the new location

False

T/F: To reverse an Auto Correct adjustment, immediately click the Redo button on the Quick Access toolbar.

False

T/F: Use a negative indent if you want the subsequent lines of a paragraph to be indented more than the first line

False

T/F: When the paper orientation is set on landscape, the contents will print across the width of the page

False

T/F: When you apply highlighting to text, the highlighting is only visible on the screen and doesn't print

False

T/F: When you move text to a new location using the mouse, that text is added to the clipboard

False

T/F: Word places footnotes at the end of the document.

False

T/F: Word's Format Painter will only allow you to change the font styles used in other areas of a document by copying font styles from paragraph to paragraph

False

T/F: You can enter, edit, and navigate data in query data sheet just like a report datasheet

False

T/F: You can switch between views using the view buttons in the lower-left corner of the window

False

T/F: You can use the calendar Box to enter dates in a Date/Time field

False

T/F: You must select an entire paragraph to change its paragraph formatting

False

T/F: You would use the Font List Arrow to change the format of text to 20 points

False

The easiest way to filter the records for an exact match is to use the Filter by Form feature

False

There are nine basic categories of Smart Art graphics that illustrate text differently

False

To change the formatting of text from Calibri to Arial, which tool would you use?

Font Name List Arrow

What would change in order to make characters narrower and give text a tall, thin appearance?

Font Style

T/F: You can create custom theme fonts by clicking the ___ button, then clicking Create New Theme Fonts

Fonts

Controls placed in the ____ form section print only once at the top of the print out

Form Header

To move an object to the back of the stack, click the Send Backward button in the Arrange group on the Drawing Tools ___ tab

Format

You can format any text with a Word Art style. Select the text, click the Drawing Tools ___ tab one the Ribbon, then click a Word Art style option in the Word Art styles group

Format

Which Word view displays document text so it's easy to read and annotate with comments and high lighting?

Full Screen Reading

The physical components of a computer are referred to as

Hardware

The Font Color button is on the __ tab

Home

The Font Color button is on the ___ tab

Home

Which shortcut key moves focus to the first field of the current record

Home

You can use colors, patterns, and borders to enhance the over all appearance of a worksheet and to make it easy to read one of the ways of adding these enhancements is by using the Border and Fill Color buttons in the Font group on the __ tab of the Ribbon

Home

Which tab group will allow the insertion of rows and columns in a worksheet?

Home tab, Cells group

Which data type stores Web addresses?

Hyperlink

You can insert a logo on a form using the ___ button on the Design tab

Insert Image

How do you force text in a column to the top of the next column

Insert a column break

____ will find all records where there is any entry in the field, even if the entry is 0

Is Not Null

You can search Help and Support by typing one or more descriptive ____

Keywords

Which of the following is the smallest unit of measurement

Kilobyte

Which of the following is not a bound control? (Text box, Combo box, List box, Label)

Label

Cells in the first or top row are ___ names and provide further information about the data

Legend

Which chart type would be the best candidate to emphasize sales trends over a period of 6 months

Line

A ___ is a box that lets you select an option from a list of options

List box

You can preview the look of a design theme before committing it using ___

Live Preview

A query datasheet is sometimes called a ___ of the data

Logical view

What type of margins are used in a document with facing pages, such as a magazine?

Mirror

What type of indent would you use to move the left edge of a paragraph to the left of the left margin?

Negative indent

The default view that PowerPoint opens in is called ____

Normal

The ___ at the right side of the task bar contains icons that represent informational messages and programs you might find useful

Notification area

After you enter text in a placeholder, the placeholder becomes a text ___

Object

Tables, queries, and forms are examples of Access ____

Objects

____ allocate system resources, manage storage space, maintain security, detect equipment failure, and control basic input and output.

Operating Systems

Which section would most likely contain page number and date expressions?

Page Footer

What task does Word not give you the ability to accomplish?

Perform calculations in a spreadsheet

Expansion cards plug into electrical connectors on the motherboard called ____

Ports

Which dialog box do you use to embed fonts? (Save options, font options, PowerPoint options, Embed font options)

PowerPoint options

The ___ is an area on the right side of a window that shows you what a selected file looks like without opening it

Preview Pane

A hard copy is another name for a file that you ___.

Printed from a printer

An example of an output device is a ____

Printer

Pressing Shift as you drag to create a shape maintains the shape's ___ as you change its size

Proportions

The ____ toolbar is fully customizable

Quick Access

Which element of the Word program window contains buttons for saving a document and for undoing, redoing, and repeating a change?

Quick Access Toolbar

What temporarily holds programs and data while the computer is on and allows the computer to access that information randomly?

RAM

Slide sorter view is primarily used to (edit slide content, rearrange slides, add slide effects, add design themes)

Rearrange slides, add slide effects, add design themes

Which editing a record, pressing ESC a second time ____

Removes all change made to the record you are currently editing

You can use the ___ command to replace one font to another

Replace

Which report view's primary purpose is to quickly review the first page of the report?

Report View

You insert a comment in a worksheet by using the ____ tab on the Ribbon.

Review

To format a cell or range, first you select it, and then you apply the formatting using the ___ or a keyboard shortcut.

Ribbon.

Which chart type would be the best candidate to spot trends and extrapolate info based on research data?

Scatter

The search text that you type is called your ___

Search Criteria

What is the name of the formatting mark that shows the end of a section?

Section break

Which button do you click to show formatting marks in a document?

Show/Hide P button

___ describes the technical details about each component of a computer system

Specifications

A ___ is a box with up and down arrows; slick arrows or type to increase or decrease the value

Spin box

Which tab in the Properties dialog box shows information about revisions to the document as well as the number of pages, word, lines, paragraphs, and characters in the file?

Statistics

Which element of the Word program window displays information about the current document, such as number of pages, and also includes the view and zoom buttons?

Status bar

To apply a table style, select the data to be formatted or click anywhere within the intended range, click the Format as Table button in the ___ group on the Home tab, and then click a style in the gallery.

Styles

Criteria ___ is the term for rules by which criteria must be entered in a query

Syntax

A(n) ___ is any part of the computer system, including memory, storage devices and the microprocessor, that can be used by a computer

System program

Which key do you press to create a new bullet?

Tab

This Access object contains all of the raw data within the database

Table

A Smart Art graphic consists of two parts: the Smart Art graphic itself and a(n) ___ pane

Text

This control is used to display, edit, or enter data for each record. It does not provide a list of possible data entries

Text box

When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?

The Auto fit options button

Where are the Clip Art images stored?

The Clip Organizer

The slides tab displays each slide as a(n) ____

Thumbnail

The Group Header and Group Footer Section can be turned on or off in which pane?

Toolbox

T/F: A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data

True

T/F: A form contains record navigation buttons, with information about the current record number and total number or records, similar to a data sheet

True

T/F: A primary key field uniquely identifies each records

True

T/F: A query can be used to create calculated fields

True

T/F: Although you can change a Clip's size by dragging a corner sizing handle, you can also scale it to change its size proportionally by a specific percentage or size

True

T/F: An Excel complex formula uses more than one arithmetic operator.

True

T/F: An interface card could be plugged into an expansion slot on the main board of a computer

True

T/F: Any data changed in the worksheet is automatically updated in the chart

True

T/F: Calculated expressions within text boxes start with an equal sign

True

T/F: Design elements that you place on the Slide Master appear on every slide in the presentation

True

T/F: Double-clicking a word selects the entire word

True

T/F: Excel includes a(n) scenario manager where you can name and save different what-if versions of your worksheet

True

T/F: Grouping means to sort records plus provide extra report sections

True

T/F: If your presentation has numerous slides, you can organize them into section in the Slides tab

True

T/F: In Page Layout view, the dotted line indicates the print area

True

T/F: In the outline tab, a highlighted slide icon next to the slide number indicates that the slide is selected

True

T/F: On the left side of the title bar, the Quick Access toolbar lets you perform common tasks with just one click

True

T/F: One way to move text within a document in Word is to select the text and drag and drop it to a new location

True

T/F: Portrait orientation means a page is taller than it is wide

True

T/F: PowerPoint accepts information in the form of files from a variety of sources, such a Microsft Acess

True

T/F: Smart Art styles are organized into sections; the top groups offers suggestions for the best match for the document

True

T/F: The Alternate Back Color Property helps differentiate parts of the report by allowing you to specify a new color for every other time that the section prints

True

T/F: The F2 key switches between Edit and Navigation modes

True

T/F: The Large Setting, Computer & HD Displays (960 x 720) is used for viewing on a computer monitor, projector, or other high definition displays

True

T/F: The Outline tab displays the text of your presentation in the form of an outline, without showing graphics or other visual objects

True

T/F: The communication path between a microprocessor, RAM, and peripherals is called the data bus

True

T/F: The question mark (?) is the wildcard character which stands for any single character in criteria

True

T/F: The same expression in different sections of a report produces different calculations

True

T/F: There are three Master views: Slide Master view, Handout Master view, and Notes Master view

True

T/F: To add delete, or change fields in a query you use Query design view

True

T/F: To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spell check again.

True

T/F: To create custom theme colors, click the colors button, then click create New Theme Colors

True

T/F: Word Art, which lets you create curved or stylized text can be created using the Chart Tools Format tab

True

T/F: You can apply formatting before or after you enter data in a cell or range.

True

T/F: You can change the font and font size of any cell or range using the Mini toolbar.

True

T/F: You can change the font and font size of any cell or range using the mini toolbar

True

T/F: You can resize a chart to improve its appearance by dragging its sizing handles

True

T/F: You can right align a paragraph so that the text is flush with the right margin and has a jagged left edge

True

T/F: You would use the options on the Table Tools Layout tab to change the alignment of text in a table

True

You are running two programs at once that require 10 megabytes of RAM. What makes this possible?

Virtual memory

On a chart created in Excel, the horizontal axis is called the ____

X-axis

Which type of cell reference preserves the exact cell address in a formula

absolute

You can use a spreadsheet to ___ by using variable to investigate and sample different outcomes

create what-if data scenarios

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ___ in the template

data

All Excel formulas begin with the ___

equal sign (=)

A(n) ___ is a collection of stored information, such as a letter, video, or program

file

A(n) ___ is a built-in formula that uses that uses arguments to calculate information

function

In Escel, MAX and AVERAGE are examples of ____

functions

A(n) ___ identifies each data series in a chart, generally with a different color

legend

Word's ____ feature allows you to quickly search for replacements for a particular word or phrase within a document

replace

It is a good idea to limit each slide to six words per line and ___ per slide

six

Megahertz is a measurement of ____

the speed of a microprocessor

T/F: In form layout view, you can move through records and view data, but you cannot enter or edit data

true

T/F: It would sense to set the Tab Stop property of a text box that will not be used for data entry to number

true


Related study sets

Chapter 19: Business Conduct Rules - Multiple Choice

View Set

Pharmacology, Chapter 87: Aminoglycosides: Bactericidal Inhibitors of Protein Synthesis

View Set

CompTIA 2.4 PC Maintenance (Test-Out)

View Set

Loud Pack 164 Kaplannzzzz UCSD Psych 164

View Set

Stephen F. Austin & the Empresarios of Texas

View Set

Pro Res - Stevenson 2019, 500 Questions

View Set