CIS 146 - Final Study Guide

Word's default margins are typically ___ inch(es)

1

An accurate IF function is ___

=IF(C2>D2,"no","yes")

An example of a MIN statistical function formula is ___

=MIN(B4:H8)

An accurate example of a PMT function is ___

=PMT(4%/12,36,2500)

A formula using the TODAY function looks like___

=TODAY()

To find all appointments that meet these conditions - January 1, 2017 or later and March 31, 2017 or earlier, enter ______ in the criteria row for the appt date

>=1/1/2017 and <=3/31/2017

Sorting query results in ascending order sorts them ____

A To Z

An example of the average function is ___

AVERAGE (B3:D4)

To align objects on a slide, select more than one object and then click the ___ button in the arrange group on the Picture Tools Format tab

Align

One method to insert a column or bar chart is to use the ___ tab from the insert chart dialog

All charts

___ charts are like column charts turned on their side

Bar

A ___ is a compiled list of sources you reference in your document

Bibliography

In excel you can add ___ to make your workbook look more like a desktop publishing form or to show separation between a column of values and the total row

Borders

A ___ is a brief of an illustration, chart, equation or table that usually appears above or below an image

Caption

A ___ is the intersection of a column and a row

Cell

___ alignment aligns text on the left side, leaving the right side ragged

Center

A ___ takes the information entered in a spreadsheet and converts it to a visual representation

Chart

When you wish to present your excel worksheet data as a graphic, create a(n) ___

Chart

A(n) ___ is a reference to source material

Citation

To remove the contents of a cell without removing the cell from the structure of your workbook, use one of the ___ commands

Clear

If you have sent a document to multiple reviewers, each reviewers' comments and changes will be displayed in a different ___

Color

A ___ is a group of predefined colors that work well together in a document

Color theme

If your worksheet includes a large table of data that prints on more than one page, you should ensure that the ___ and ___ labels print on every page

Column and row

The ___ placeholder is a special type of placeholder that gives you a quick way to add a variety of material to your presentation

Content

The query wizard button is located in the ____ tab of the ribbon

Create

The ___ command is used to move text and objects from one place to another

Cut

The ___ command is used to move text and other objects within a file and from one file to another

Cut

The content of a cell or range of cells that is ___ and is removed from the selected cell

Cut

A(n) ______ field is automatically assigned its value by access

Database users cannot edit or enter data in this field. AutoNumber

Use the ___ view when entering records into a table

Datasheet

Tables open in ____ Datasheet view where you can enter, sort, and filter data

Datasheet view

Access will prevent you from ___ records if it would violate the integrity of the database

Deleting

The copy command ___ the content from the selected cell

Duplicates

By default, word inserts images into documents as ___ objects, meaning they become part of the new document

Embedded

#DIV/0 is an example of a worksheet ___ that can display in a cell

Error

The expression builder can be used to create complex expressions including functions similar to those in ____

Excel

In a ___ pie chart, each slice is slightly separated from the whole

Exploded

Each column in a table represents a specific data value called a(n) ___

Field

The ____ property is used to limit the number of characters that can be entered in a text field

Field Size

Access is a relational database; objects in your database are related to one another through relationships defined by common _____ between tables

Fields

To access the print button in the backstage view click the ___ tab

File

By applying a(n) _____ to a database object, you display a subset of records that meet your criteria

Filter

If you need to find multiple records that match your search parameters, not just the first one, use the ___ command

Find

A ___ refers to a set of characters of a certain design

Font

A(n) ___ is text that appears at the bottom of every page, below the margins

Footer

___ appear at the bottom of the page and provide your reader with further information on a topic in a document

Footnotes

By default, excel includes ___ when copying or filling a series

Formatting

A ___ is an equation used to calculate a value

Formula

Use the ___ paste option to paste the content, including formulas, but none of the formatting into a worksheet

Formulas

Commonly used spacing options include all of the following except ___

Half spacing

___ is what appears at the top of every page

Header

A ___ is text or a graphic that, when clicked, opens another page or file

Hyperlink

To add a header or footer to a document, start by clicking the ___ tab

Insert

When you first add a picture to a document, word inserts the picture at the ___ point and displays the picture in line with the text

Insertion

Bulleted and numbered lists are typically ___ aligned

Left

If you right-click any field name and select insert field to insert a new blank text field, it is inserted to the _____ of the field you selected

Left

The ___ option in a Total Row can be useful when filtering records in a table; it tells you how many records are included in the filtered table

Legend

___ charts show the movement of values over time; they work best when data trends over time are important

Line

The ___ are the blank spaces at the top, bottom, left and right of the page

Margins

A line in a line chart may include dots called ___ representing each data point

Markers

You can ___ cells to create a header cell across multiple columns of data or to center a title across your worksheet

Merge

The ___ button automatically merges the selected cells and then centers the data from the first cell across the entire merged area

Merge & center

___ cells entails combining multiple cells into one

Merging

A(n) ___ reference is a combination cell reference with a row position that stays constant with a changing column position (or vice versa)

Mixed

All of the database objects are organized in the ___ pane, which is docked at the left side of the screen

Navigation

The default method of searching text in a document is to use the ___

Navigation pane

Some forms in Access are designed to automatically open to a(n) ___ record where you can immediately begin entering data

New

To add a new worksheet to your workbook, click the ___ button to the right of the last worksheet tab

New sheet

In ___, excel shows the aspects of the worksheet that are visible only on screen

Normal view

In excel, the find and replace commands not only to find the text but also ___ in values and formulas in a single worksheet or across an entire workbook

Numbers

One of the most useful financial functions in excel is the ___ function, which you can use to calculate loan payments

PMT

Viewing a worksheet in ___, shows all the worksheet elements as they will print

Page layout

If you want to print pages 3 through 8 of your document, type 3-8 in the ___ box

Pages

Keep source formatting, merge formatting, picture, and keep text only are the different ___ options when working with text

Paste

One method to open the Insert Picture dialog is for you to click the ___ icon in the content placeholder

Pictures

Each slide contains ___ for you to add content such as text, tables, charts or images

Placeholders

Fonts are measured in ___

Points

A red, wavy line under text represents ___

Possible misspelled word

Reports include ________, which shows how the report will look when printed

Print view

The ___ toolbar gives you immediate access to both the undo and redo commands

Quick access

You can change the style of a chart using the predefined ___

Quick styles

A named range refers to a ___ in your formula

Range of cells

Word's ___ is designed for reading documents in electronic format

Read mode

Each row in a table contains all the data for a single ___

Record

Different criteria in multiple rows implies _____

Records must match one criteria but not all. OR

The _____ command allows you to reverse the undo command and restore the file to its previous state

Redo

A(n) ___ database is a group of tables related to each other by common fields

Relational

Objects in Access are related to one another through ___ defined by common fields between tables

Relationships

To remove a hyperlink, right-click the link and select ___ from the menu

Remove hyperlink

The ___ command in word allows you to locate specific instances of text in your document and replace them with different text

Replace

To remove all the manual page breaks at once, on the page layout tab, in the page setup group, click the breaks button and click ___

Reset all page breaks

You can resize images in a presentation by either manually entering the values for the size of the picture or by dragging a ____ on the image to resize it

Resize handle

To add a comment click the ___ tab

Review

If you want to adjust the width of a column manually, move your mouse over the ___ column boundary and click and drag until the column is the size you want

Right

One method you can use to insert a new field is to ____ any field name and select _____

Right click, insert field

A method used to sort is to ___ any cell in the column you want to sort by, point to sort, and then select the option you want

Right-click

One method of changing a chart type is to ___ in the chart area and select change chart type

Right-click

To delete the relationship between two tables you can _____ the relationship line and select Delete

Right-click

After clicking a shape, you notice an arrow circle above it; this is known as the ___ handle

Rotate

A ___ is a horizontal group of cells

Row

To delete a field in Design View, select the field you want to delete by right clicking the _____ to the left of the field name, and select Delete Rows

Row Selector

Clicking the ___ selects an entire row in a worksheet

Row selector

A(n) ___ is a drawing object that you can quickly add to a presentation

Shape

The _____ Query Wizard will create a simple select query

Simple

Which view is used to add text placeholders to slide layouts

Slide Master

Clicking a thumbnail in the Thumbnails pane will make that slide appear in the ___

Slide pane

One way to insert a SmartArt diagram in a presentation is to click the ___ icon in a content placeholder

SmartArt

If you want to control how records are displayed, set the _____ order as part of the query design

Sort

You can control the order in which records appear in a table, query or form by using the ___ feature

Sort

The ___ appears at the bottom of the worksheet grid and displays information about the selected data, including the number of cells selected that contain data and the average and sum of the selected values

Status bars

The ___ effect draws a horizontal line through the text

Strikethrough

A(n) ___ is a group of formatting, including character and paragraph formatting, that you can easily apply to text in a document

Style

In Word, you can sort by all of the following except ___

Style

Complex formatting, including font, color, size, and spacing can be applied to text are called ___

Styles

The text highlight color button is located in the ___ group on the home tab

Styles

The ___ effect draws a small character above the text

Superscript

___ concatenates cells using a delimiter character to separate values in the new text string

TEXTJOIN

One method to delete a worksheet is to right-click on a sheet ___

Tab

In excel, you can define a series of adjacent cells as a ___

Table

To merge cells in a table, use the ___ tab

Table Tools Layout

In powerpoint, you can create a variety of charts, including all of the following except ___

Table charts

A ___ is a document with predefined settings that can be used as a pattern to create a new file

Template

If you start with a ___, your presentation may include several slides ready to add content

Template

Filtering with AutoFilter is ____

Temporary

The ___ helps you not reuse a certain word over and over again in a document by providing a list of synonyms and antonyms

Thesaurus

In the _____ box, type the new field name

This is the name as it will be referenced by other objects in your database. Name

There are ___ types of relationships that can be established in Access

Three

Commonly used spacing options include all of the following except ___

Triple spaced

In excel, you can split the worksheet view into ___ or ___

Two, four

When rearranging fields in datasheet view, the ______

Underlying table design will not be changed

If you are working on data entry in the Datasheet view or Form view, the ___ command is applied to the entire record, not each individual field within the record

Undo

If you make a mistake while working on the presentation, the ___ command allows you to reverse the last action you performed

Undo

If you move a named cell, the name ___ with the new cell location automatically

Updates

If the ruler is not displayed, click the ___ tab and select the ruler check box in the show group

View

By hiding a field in a query, you can use it to define criteria without making the field _____ in the final query results

Visible

A graphic or text that appears as part of the page background is called a ___

Watermark

By default, all the worksheet tabs in excel are the color ___

White

Microsoft office word is a ___ program that enables you to create many types of documents

Word processing

The ___ feature places text on the next line when the right margin of the page has been reached

Word wrap

Use ___, with predefined graphic styles, to call attention to text

WordArt

___ is used to make text really standout using a combination of color, fills, outlines and effects

WordArt

An excel file is referred to as ___

Workbook

A ___ is an electronic ledger in which you can enter data

Worksheet

Each excel ___ is made up of rows and columns of data on which you can perform calculations

Worksheet

A(n) _______ field stores a true/false value as a -1 or 0

Yes/No

A ___ takes the values you have entered in a spreadsheet and converts them to a graphic representation

chart

APA, Chicago, and MLA are all examples of ___

reference styles

___ rearranges the order of rows in your table by the text in a column or columns

sorting