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