Cis 110 Final

normal view

mini toolbar

keytip

select

tab

backstage

current slide

dialog box launcher

ribbon

placeholder

if you need more room on the screen, you can hide the ribbon

when you start powerpoint, the last presentation you worked on appears on the screen

when you save a presentation that has been previously saved, clicking the save button on the quick access toolbar reopens the save as tab of backstage

the quick access toolbar contains no buttons by default

to close a dialog box without accepting any changes you may have made to it, click the cancel button

you can use the undo command to reverse the last action you took

to print a presentation, open backstage view and click print

backstage view gives you access to all of the powerpoint design tools

you can use the cut and paste commands to move text from one slide to another slide

in normal view, powerpoint displays five different panes for viewing different aspects of your slides

print preview

grayscale

note

layout

demote

thumbnail

indent level

template

handout

presenter view

a new, blank presentation appears on your screen when you launch powerpoint

once a layout has been applied to a slide, it cannot be changed

when you save a presentation for the first time, the save as dialog box appears

if you want to be able to use a presentation with an older version of powerpoint, you can save it by using the powerpoint 97-2003 file format

Many PowerPoint templates feature a set of complementing colors, fonts, and effects called a layout.

You can copy and paste content from most Windows applications into PowerPoint.

One way to copy a slide is to right-click its thumbnail and then click Copy.

notes appear on the screen with the slides in slide show view

powerpoint can print just the text of your slide without printing any graphics via an outline layout

if you use a printer that does not print in color, your slides will appear in grayscale when viewed in print preview

which of the following is not a paragraph alignment type

when selecting a color, such as from the font color button's palette, the colors on the top row are

most of powerpoint's text placeholders automatically format text as a/an _____ list

reflection is one type of _____ you can apply to wordart

a text box's ______ determines how close the text comes to the sides, top, and bottom border of the box

to apply a wordart style to existing text on a slide, you must first

what does it mean when a word has a wavy red underline

a thesaurus enables you to look up synonms

a ____ is a container for text on a slide

a ____ is a set of letters, numbers, and symbols in a specific style or design

the _____ feature, when needed, shrinks the size of the text in a text box in order to fit it in the box

a ____ is a symbol that appears to the left of each paragraph in a list

the _____ feature enables you to copy formatting from one block of text to another

_____ text us aligned to both the left and right margins of a text box

a ____ indent is a reverse indent for the first line of a paragraph where the first line is indented less than the other lines

a _____ object is text in the form of a graphic

the ______ in power point can be used to look up synonyms

to ____ a text box, drag one of its selection handles

clip art

aspect ratio

keyword

scaling

photo album

constrain

gridlines

order

crop

guides

when adding clip art to a slide, you are limited to the pictures stored on your computer

when you use the union option when merging shapes, only the area where the two shapes overlap is included in the merged shape

use the align middle option to align objects vertically so that their horizontal centers are lined up with each other

the recolor option lets you select colors in a picture and replace them with other colors

compressing an image reduces the number of colors used

the merge shapes feature merges two or more overlapping drawn shapes

to add text to a shape, select the shape and begin typing

if you want an object to be at the bottom of a stack of objects, you would use sent to back

you can format a single object in a group without having to ungroup all objects

any presentation can be converted to a photo album presentation

animation painter

audio

delay

duration

motion path

transition

animations

entrance effect

exit effect

emphasis effect

a transition can be applied to a specific object on a slide

you can assign your own sound clips to a slide transitions

you can set up both transitions and animations from the animations tab

not all transition and animation effects have effect options you can set

an emphasis effect is a good way to draw audience attention to an object as it exits the slide

to reverse the order of text animation in a text box, click effect options and click reverse path direction

An animation set to With Previous begins executing at the same time as the previous animation effect begins.

to slow down the speed of an animation effect, increase its duration setting

If you double-click the Animation Painter button, the feature stays on until you turn it off.

You can insert audio and video clips from the Clip Art task pane

table

report

redundant data

record

query

primary key

form

field

data type

database

When you press the Shift key, small letters and numbers called KeyTips appear on the Ribbon.

Any list you make for a specific purpose can be considered a simple database, even a grocery list.

By default, the Navigation Pane appears on the right side of the Access screen each time you create or open a database.

Forms, queries, and reports are examples of database objects.

The dialog box launcher contains the commands that you use most often, such as Save, Undo, and Redo.

The Change Help Location menu lets you choose between the help topics that are available online and the help topics installed in your computer offline.

In a database table, data is stored in rows and columns—similar in appearance to a spreadsheet.

each field in a table must be designated for a particular data type

An important principle to consider when planning a database is to try to record each piece of information as many times as possible for easy access.

Normalization is the process of applying rules to your database design to ensure that you have divided your information items into the appropriate tables and columns within tables.

in access, a template is

when you create a new blank database, access opens a database that contains

to save a database file in a location other than the default, click the

the table structure is created when you

the templates group commands are located on which tab

to copy a table, you must first select it in

when you paste a table, which dialog box is displayed

after you have created a table or other database object, you should

when you quit the program, access automatically

which is not a way to create a new database table

you can create a database using one of the many templates available or by creating a new ______ database

by default, access creates a _______ field named "ID" for all new datasheets

entering data in datasheet view is very similar to entering data in a ______

the ______ contains predefined templates included in two categories, blank forms and quick start

one way to create a table is to copy the _____ of an existing table and paste it into the database

when you add a new table to an existing database, that new table stands alone until you ______ it to your existing tables

you can use up to _____ characters (letter or numbers), including spaces, to name a database object

several options for creating a database are provided on the ______ tab in the backstage view

the _____ category in the application parts gallery contains a collection of predefined database objects for tracking comments, contacts, and issues

a table is structured through rows and _____ , which become meaningful when you enter data into it

referential integrity

ascending order

descending order

sort

foreign key

filter

innermost field

composite key

wildcards

outermost field

you can use the navigation buttons to search for data in a table

you may enter any kind of data into any field

After you enter data and move to a new field, Access automatically saves the data for you in the table.

After you delete a record, you can click the Undo button to bring it back.

The Find and Replace dialog box searches all the tables in a database at one time.

An AutoNumber field will usually make a good primary key

Before you can attach a document, there must be a field in a table formatted with the Attachment data type.

The outermost field is the primary sort field in a multifield sort.

The Toggle Filter button lets you permanently remove a filter and switches you back to the original view.

In a one-to-many relationship, each record in the first table can have many records in the second table.

form tool

theme command

form design button

form

form wizard

blank form button

The Forms group is located on the Home tab in the Ribbon.

Layout view gives you a more detailed view of the structure of your form than Design view.

Using the Blank Form tool is a very quick way to build aform, especially if you plan to put only a few fields on your form.

to access the theme options, first switch to form view

to delete a form, click on the remove button in the forms group

When using the Form Wizard, you can only include fields from one table.

report

record source

field list pane

detail

report wizard

design grid

a simple report contains all the records in a table or query

you can edit the data in a report

click the report button to define a record source

In the Report Wizard, you can skip steps such as Sorting or grouping by clicking the Next button.

You can drag a field from the Field List pane to the design grid to add it to the report

Layout view gives you the most options for creating a report,because it shows you the underlying structure of the report

In Report Design view, you can click on the top of the border of a label to move both the field and its label

form tool

theme command

form design button

form

form wizard

blank form button

the forms group is located on the home tab in the ribbon

layout view gives you a more detailed view of the structure of your form than design view

Using the Blank Form tool is a very quick way to build aform, especially if you plan to put only a few fields on your form.

To access the Theme options, first switch to Form view.

To delete a form, click on the Remove button in the Forms group.

When using the Form Wizard, you can only include fields from one table.

report

record source

field list pane

detail

report wizard

design grid

A simple report contains all the records in a table or query

You can edit the data in a report

Click the Report button to define a record source

In the Report Wizard, you can skip steps such as Sorting orGrouping by clicking the Next button.

You can drag a field from the Field List pane to the design grid to add it to the report

Layout view gives you the most options for creating a report,because it shows you the underlying structure of the report

In Report Design view, you can click on the top of the border of a label to move both the field and its label

Creating a query is like

When one table will provide the information that you need, you can create a

Which query cannot be created using the Query Wizard?

Queries are different from sort or filter commands because they can be

a query can get its data from

To find records that contain matching field values, you can create a query using which wizard?

Before creating a query from multiple tables, you must first ensure that the tables have

to add a table to a query, you must be in what view

the queries group on the _____ tab contains the commands used to create queries

the _____ button creates a new, blank query in design view

a _____ is the most basic type of access query

the tables or queries from which a query gets its data are referred to as its

to run a query after it has been created, double click it in the navigation pane to open it in _____ view and see the results

Two or more records are considered _____only when all the fields in your query results contain the same values.

To view only the records in one table that don’t have a matching record in another table, you can create a _____ query.

By switching to _____ view, you can access all the tools needed to modify your query.

An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available?

which of the following is a selected cell

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

After a file has been opened, the filename appears in which of the following?

When you split a window, the window is divided into how many panes?

When you click the Help button, what opens?

Which is the intersection of a row and column?

Which of the following starts off with Open, Undo, and Redo and can be customized to contain the commands you use most frequently?

How many worksheets does a new Excel 2013 workbook open with?

To get to the last cell on the worksheet, which of the following should you press.

Pressing the F1 key displays Backstage view.

Pressing the Alt key activates Keytips that allow you to use the keyboard to choose tabs instead of click them with the mouse.

Ctrl + O opens a new blank workbook.

The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.

Ctrl + F displays Backstage view.

Click the FILE tab to get to Backstage view.

Press Ctrl + Home to go to cell A1.

The columns in a worksheet are identified by numbers.

The active cell in a worksheet is outlined by a bold rectangle.

Page Layout view is useful when preparing your data for printing.

Which of the following consists of details that describe or identify a file, including the author?

Which command is used to insert a cut or copied selection to a cell or range of cells?

Which of the following is a group of adjacent cells that you select to perform operations on all of the selected cells?

Which of the following places a duplicate of a selection in the Office Clipboard?

To use a worksheet or workbook outside Excel, you have the option to save as which of the following?

Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?

Which is used to drag or double-click to change the width of a column.

Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas?

Which Excel feature helps you quickly enter previous data into cells?

Which Excel feature automatically fills cells with data from another cell or range or completes a data series?

Using the Delete key removes both text and formats from a cell.

Use Ctrl + : to enter the current date in a worksheet cell.

When data is too wide for a cell, the part of the data that will not fit is automatically deleted.

You can assign keywords so that others can search for your documents online.

To remove only the formats from a cell, you can use the Delete key.

Dates can be displayed in only one way within Excel.

All dates in Excel are actually stored in the serial date number system.

The formula bar is found at the bottom of the Excel window.

Use the fill handle to create a natural series, such as the months of the year.

Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

To change printer, layout, or margin settings, you click the FILE tab and use which of the following options?

Which of the following can you customize for quicker access to the most commonly used commands?

Which feature enables you to create custom tabs and groups?

Which command in the Backstage view navigation pane enables you to view and open your most recently used workbooks or workbooks stored on SkyDrive or your computer?

Which dialog box in Backstage view should you access to view and alter your workbook’s properties?

When you modify the ribbon, which of the following do you create?

Which of the following do you use to open Backstage view?

Which of the following do you click in the navigation pane to change Excel’s default settings by accessing Backstage view?

What is a predesigned file that already has a significant amount of formatting, text, and other features?

You do not have the ability to modify the number of default worksheets in a workbook

The Open dialog box enables you to access the Microsoft website for custom templates.

Use Ctrl + N to create a new workbook.

To access an Excel template, you can click the FILE tab and click New

You cannot have more than one worksheet in an Excel workbook

If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width

You can access Backstage view by pressing Ctrl + B.

In Excel, you can add your most commonly used commands to the Quick Access Toolbar

You can create a completely new Ribbon tab as well as groups on that ribbon.

Which of the following is not an arithmetic operator?

In Excel, what is the result of =1 + 3 * 2 / 2 - 1?

Per the order of operations, which of the following is calculated first?

Which of the following refers to an unnamed range in the current worksheet?

Which of the following shows a formula for a reference to another worksheet in the same workbook?

Which of the following shows a formula for a reference to another workbook?

Which of the following is an acceptable name for a named range?

Which of the following is an example of an absolute cell reference?

Which of the following is an example of a mixed cell reference?

Which of the following can you not do using the Name Manager?

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

Excel recognizes a construct like 3+4= as a legitimate formula

Range names may begin with the caret (^) character.

You cannot use a named range in a formula that references another worksheet.

Range names cannot be the same as a cell reference, such as C10 or $D$8.

Once you name a range, you can change the size of the range using the Name Manager.

You can create a new range by selecting the cells and typing a name in the Name box next to the formula bar.

The order of operations determines which parts of a formula are calculated before other parts of the formula.

The formula = 6 * 2 / 3 produces the same result as =6 * (2 / 3).

Assuming that you are using Windows 8, the first screen you see when you start your computer is called the:

When text is selected, what automatically appears on the screen?

The __________ contains the commands you use most often, such as Save, Undo, and Redo.

Letters and numbers that appear on the Ribbon when you press the Alt key are called:

How would you search for templates online?

Which command would you use to save a document for the first time?

When you open new documents in Word, the program names them with a _____determined by the number of files opened during that session.

Which of the following options would you use when saving a document with a new filename?

Which of the following is an acceptable format for a business letter?

Which of the following allows you to access the Help command?

When you start Word, a new blank document appears.

The Undo button is on the Mini toolbar.

Quick-printing a document sends the document straight to the printer.

The File tab can be used to save and print files.

The Zoom slider is located in Backstage in the Info command.

You can hide the Ribbon by double-clicking the active tab.

Saving a document in a PDF format will allow users to edit the document in Word 2013.

Previewing and printing can be completed by accessing Backstage.

You can close a document and begin working on a new document.

The Help command cannot be accessed in dialog boxes.

Which Word feature enables you to select multiple pieces of text that are not next to each other?

____________ are reduced-size versions of images.

The Advanced Properties allows you to add:

In what view is Synchronous Scrolling active?

When Heading Styles have been applied to a document, the user has the option to navigate through the document using which tab on the Navigation Pane?

Commands for replacing text with formatted text are located in the:

The keyboard shortcut for finding text is:

The Replace command can be opened using

Which wildcard would you use to find a single character?

The Go To command allows you to navigate by page, text, graphics, equations, or tables by doing which of the following:

The New Window command launches a new window that contains the current document.

By selecting text, the user has the ability to change the font or font size, bold, and delete text.

Read Mode view displays the document as it will look when printed.

The Zoom slider is located in the View tab.

The Synchronous Scrolling button is used when viewing documents side by side.

The Switch Windows command allows you to toggle between documents

Double-clicking a word in a document selects the word

When you type text in the search box while in the Navigation Pane, Word identifies this text by bolding the results in the document.

The Arrange All command places all open documents in a separate window on the screen.

You can use the Navigation Pane to search for words or phrases in a document.

When measuring point size, one point is equal to a character height of:

The Underline drop-down menu in the Font group contains options to underline selected text with a:

A ________ is a typeface that applies a style to characters.

If you type a paragraph in uppercase and need to change it to sentence case without having to retype the paragraph, which option would you use?

Opening the Modify Style dialog box allows you to________________.

The ________ lets you copy the format of text and apply those attributes to different text.

The ________________feature removes all formatting from the selected text.

Tiny lines at the ends of characters are known as:

To increase the point size of selected text, click the:

Changing the font and font size of selected text can be completed using:

Toggle Case changes each character to its opposite case.

Applying bold to text gives it special emphasis.

The Format Painter is found on the Mini toolbar.

The default color for Text Highlighting is pink.

The Decrease Font Size button increases point size.

The Clear Formatting button clears text from one location and lets you apply it in another location.

PDF files can be edited using Word 2013.

The Font dialog box has an option to display the underline drop-down menu.

To apply a Style to selected text, click the style from the Styles group.

styles cannot be modified

Which of the following is NOT a type of indent?

Which word(s) refers to how text is positioned between the top and bottom margins of the page?

Which line spacing command sets the spacing at a fixed amount that Word does not adjust?

Where is the View Ruler button located?

What does dragging a tab off the ruler do?

Bullets can be defined by adding a:

Which property of borders can be changed in the Borders tab of the Borders and Shading dialog box?

The inverted L sets which tab on the ruler?

Which tab setting would you use to align a list of currency values?

You can define a New Number format by selecting which of the following styles?

Pressing the Enter key will indent the first line of a paragraph.

An indent is the space between a paragraph and the document’s left and/or right margin.

You can use the ruler to set tabs.

A bar tab inserts a vertical bar line at the place indicated on the vertical ruler.

Tab leaders are dotted, dashed, or solid lines that fill the space before a tab.

The Clear Formatting command clears only the fonts applied to the selected text.

Horizontal alignment refers the position of text with regard to the top and bottom margins of a document.

Centered vertical alignment aligns text between the top and bottom margin.

Indents can be changed using the markers on the ruler.

The shortcut to double space a paragraph is Ctrl+2.

You can use the __________ to control almost every aspect of the Outlook environment.

Click the _______ button to access the Show Columns dialog box where you can add and remove fields from a List view.

A _________ is a record stored in Outlook.

You can change the appearance of the Outlook workspace by changing the theme on the Outlook ________ page.

The ________ contains menus and commands available in Outlook 2013.

What pane displays the text of a selected email message?

You can customize the appearance of the Navigation bar using the Navigation Options dialog box, which can be accessed by_________.

What is the easiest way to access Outlook’s features, such as the Tasks and Calendar?

The ________ button is the first feature listed in the Navigation bar.

You can ________ a pane to save room in the Outlook window.

The Reading Pane can be hidden.

The Navigation bar can only display four items

In Outlook, messages, appointments, people, tasks, and notes are called records.

The Calendar feature contains an appointment book.

By default, the To-Do Bar is displayed on the right of the Outlook workspace.

You can hide columns from a list by selecting the field and pressing the Delete key.

The Status bar identifies the application and the active feature.

You can use a keyboard shortcut to access Outlook’s Backstage view.

Hovering over Contacts on the Navigation bar displays the People Pane.

Backstage is a help feature in Outlook.