CSIT Unit II

Ace your homework & exams now with Quizwiz!

When making a slide presentation, be sure that you do the following ______

Have only on topic per slide.

To select a paragraph ________.

Triple-click the paragraph

A file format that can be opened and edited by many different word processing programs.

RTF

Use a numbered list for all of the following except items that are listed ________

Randomly

A file that can be opened and read but not edited

Read-only (End of Chapter 1)

All of the information about an individual or company that displays in a single row of a data source

Record

All of the related facts about a single person, place, object, or event

Record

A join between two tables based on a common field for the purpose of displaying or etracting information from connected records in both tables

Relationship

A cell reference that is stored as a certain number of rows and columns from the currently selected cell

Relative reference

If you complete a formula entry by clicking the Enter button on the Formula bar, the cell selection _______.

Remains on the current cell.

When Track Changes in enabled, it records changes made to ___________.

formatting, text that is added, text that is deleted ^(ALL OF THE ABOVE)^

Add graphics to your slides for any of the following reasons except _____.

to add an image on every slide

To create a table, you can _______.

~Drag the dimensions in the Insert Table grid ~Use the Draw Table command ~Use the Insert Table dialog box ^DO ANY OF THE ABOVE^

Digital images should be resized and cropped to _____

~Make the image fit in the available space ~Remove clutter from an image ~Focus attention on the significant portion of the image ^DO ANY OF THE ABOVE^

SmartArt diagrams can be used to show all of the following except ______.

Bar charts

A formula with an absolute reference to cell B3 would be _______.

=$B$3

You can sort a numbered list, bulleted list, or text list ______.

Alphabetically, numerically, by date *^ALL OF THE ABOVE^*

An Excel formula always begins with _______

an equals sign

Three dimensional

3-D

Range of values indicated by the maximum value of the range

Bin

A category or type of data such as last name

Field

An example of cloud storage

OneDrive

If the six cells in the range B3:B8 have the content 5, 6, -3, -10, 8, and 10, the MIN function would display ______.

-10

You can save a Word document in any of the following file formats except ______.

.ptf, .pdf, .docx

In a Word 2013 document, the default margin settings are ______.

1 inch on all sides

One of two commonly used styles for formatting research papers and reports

APA

In Excel, row height can be measured in points. A point is ______.

1/72 of an inch

If the six cells in the range B3:B8 have the content 5, 6, -3, -10, 8, and 10, the MAX function would display _____

10

When data is merged with a letter using the Edit Individual Documents command, it displays all the letters in one document with _____ between each letter.

A section break

A histogram is _______.

A special type of column chart with no gaps between columns that counts the frequency of occurrence.

To control how slides enter and exit the screen, select ______.

A transition

The paper size used by the ISO 216 standard that is comparable to the 8.5" x 11" standard letter size used in the United States and Canada is _______.

A4

A cell reference that does not change if copied to another cell

Absolute reference

A(n) _______ cell reference will not change when a formula that uses this type of reference is copied or filled into the other cells.

Absolute.

The location where data will display when you type

Active cell

It is recommended that audio files used in a presentation use ______- media format.

Advanced Audio Coding (AAC)

Teh horizontal placement of text

Alignment

Controls how text and other objects come onto the screen during a slide show

Animation

To correct spelling errors in your document, _______.

Any of the above would work: ~Right-click on each word with a red wavy underline ~Use the Spelling pane to review and correct spelling errors -Proofread the document and correct any word that displays a red line underneath it,

To format text, you can use ____.

Any of the following: -Buttons on the Mini toolbar -Buttons on the ribbon -Keyboard shortcuts

A value or expression used by a function

Argument

To ensure that a date is not understood by someone from another country, the best format to use is

August 5, 2015

To automatically correct a frequently mistyped word, use the ______ dialog box, which is accessed from the ______ pane in the Word Options dialog box.

AutoCorrect, Proofing

A feature that saves files on your computer at regular intervals to reduce the amount of data lost in the event of a computer malfunction

AutoRecover

The FV function returns a value that can be the ______.

Balance after a certain number of payments.

Like a column chart, but values are displayed horizontally

Bar chart

If two files are open at the same time, you can switch between the windows for each file by doing which of the following? (Choose the method that will work regardless of the size of the window)

Click the program's button on the taskbar.

To apply AutoFit to several adjacent columns at once, you select the columns by ______.

Clicking the column heading of the leftmost column, pressing and holding the I key, and then clicking the column heading of the rightmost column.

When you cut or copy text or images, they are stored in a temporary storage location known as the _______.

Clipboard

A list of sources used in a paper, which are listed at the end of a document

Bibliography

Words that are underlined in ______ indicate possible incorrect word usage.

Blue

A rectangle that surrounds one or more paragraphs

Border

To set up labels for printing, you need to know the _______.

Brand and product number of the labels.

An animation applied to a chart

By Series

START END OF CHAPTER 10 QUIZ

CHAPTER 10

START CHAPTER 11 QUIZ

CHAPTER 11

END OF END OF CHAPTER 11 QUIZ

CHAPTER 11 ENDS

End of Chapter 2 Quiz:

CHAPTER 2 QUIZ

START Ch. 5 - End Quiz

CHAPTER 5

CHAPTER 5 END QUIZ

CHAPTER 5 END

END OF CHAPTER 6 QUIZ

CHAPTER 6 ENDS

CHAPTER 6 END OF CHAPTER QUIZ START

CHAPTER 6 START

START OF CHAPTER 7 END OF CHAPTER QUIZ

CHAPTER 7 STARTS

END OF CHAPTER 8 QUIZ

CHAPTER 8

START END OF CHAPTER 9 QUIZ

CHAPTER 9

Chart type that uses rectangles that are oriented vertically

Column chart

To append data to an Access table from an Excel worksheet ______.

Column labels in the worksheet should match the field names in the Access table

If Accounting Number Format is used to display currency with dollar signs, the related format that right aligns with it by default is the ______ format.

Comma Style

A note that an author or reviewer adds to a document that displays in either a ballon-shaped graphic or in the Reviewing pane

Comment

(Chapter 1 (Common Elements) BEGINS)

COMMON ELEMENTS

End of Chapter 1 Quiz: Common Elements

COMMON ELEMENTS ENDS

The function that counts all of the cells that have either a number or text is the _____ function.

COUNTA

The column letter and row number used to identify a cell

Cell address

Unit of measure of column width

Character

A reference in a document to the source of information is a(n) ____.

Citation

A reference in a text to the source of the information

Citation

To display the top of a document, you can do all of the following except _______.

Click the HOME tab on the ribbon

To reply to a comment

Click the Reply icon in the right corner of the comment balloon

A selected format that is applied if a criterion is met

Conditional formatting

Any graphical object on a form or a report ath is used to display the data, perform an action, or make a form or report easier to read

Control

Ownership of intellectual property and the right to choose who uses it

Copyright

Examples of a serif font include ____

Courier, Times New Roman, Cambria

The keyboard shortcut to insert a manual page break is ______.

Ctrl + Enter

Similar to the Accounting format, but it places the currency symbol next to the number on the left

Currency

A file that contains organized data that includes names, addresses, and other information necessary to merge with a document for mailing purposes

Data source

Which of the following views in File Explorer displays a list view which shows the size of the file and the date it was last changed?

Details

The Tab button displays all of the following stops except the _______.

Hanging indent.

In the Print backstage view, you can ________.

Do all of the following: -Change the number of copies to print -Change the printer -change the range of pages in a doc that will print

Providing information about the source, author, and creation date of a workbook

Documenting

A series of dots that provide a visual connection between between widely separated tabbed text

Dot Leader

To display the Tabs dialog box, ____.

Double-click a tab stop on the ruler

END OF CHAPTER 10

END CHAPTER 10

END OF END OF CHAPTER 4 QUIZ

END CHAPTER 4

END OF CHAPTER 9

END CHAPTER 9

END of the END OF CHAPTER 3 QUIZ

END OF CHAPTER 3

END OF CHAPTER 7 QUIZ

END OF CHAPTER 7

A reference that is placed at the end of a document or section of a document

Endnote

Forms are used primarily to _______.

Enter or edit records

To open an existing file from within an application, begin by clicking the _______.

FILE tab

If a filter is applied to two different columns of a table, the most likely result is ______.

Fewer records displayed than if only filter is applied

A category of data such as file name, date, or page number that is inserted into a document

Field

A category of data that is the smallest usable fact collected for each record

Field

Three or four letters at the end of a file name that identifies the type of file

File extension

Small box at the lower-right corner of a selected cell used to copy or repeat cell content into adjacent cells

Fill handle

A filter that restricts records based on one or more fields or on more than one value in the same field

Filter by Form

To locate a record so you can change an address the best approach is to use the ______- command.

Find

Which of the following is a paragraph style in which the first line of a paragraph begins to the right of the rest of the paragraph?

First line indent

An area reserved at the bottom of a document for information that should appear on every page

Footer

A reference that is placed at the bottom of a page

Footnote

You can recover deleted files from the Recycle Bin from which type of device?

Hard Drive

To create a relationship between two tables, both tables must _________

Have a field in common

A reserved area at the top of a document for information that should appear on every page in a document

Header

The documentation that displays at the top of each worksheet is entered in the _______ area.

Header

The common field that is used to join with a primary key field in another table

Foreign key field

To repeat a format that was just applied to another area, use the ______.

Format Painter or the Repeat button.

The location in Excel that displays the formula or contents in the active cell.

Formula bar.

To display the file name and author on every page of a document, use the _______.

Header or footer area

The row numbers and the column letters are called ____.

Headings

The difference between indent and alignment is:

Indent is used to move text in from the left or right margin, and alignment lines up text at the margins

An interface tha tincludes dialog boxes, command buttons, graphic icons, and menus and is manipulated with a mouse and keyboard to interact with software.

GUI

A displayed list of potential results.

Gallery

Feature that tires many values in a cell to achieve a desired outcome

Goal Seek

Animations can be applied to _______.

Graphic or text objects

Shades of gray that represent color, which are applied to slide images when they are printed

Grayscale

The lines between cells that display on screen but that by default do not display in printouts are called _______.

Gridlines

A collection of related commands on a tab that enable you to interact with the application

Group

A language that defines the way everything looks on a Web page

HTML

Displays from one to nine thumbnail imagesof slides to distribute to an audience

Handouts

Which of the following is a paragraph style in which the first line of a paragraph extends to the left of the rest of the paragraph?

Hanging Indent

A SmartArt graphic whose purpose is to show a decision tree would be found in the ______ category

Hierarchy

Type of column chart with no gaps between columns

Histogram

Bottom edge of a column, line, or histogram chart

Horizontal (category) axis

Text or graphic that, when clicked, connects you to a location in a file or a Web page

Hyperlink

The difference between a bar chart and a column chart is ______.

In a column cart, the rectangles are oriented vertically.

In Word, indicates with a blinking vertical line where text or graphics will be inserted.

Insertion Point

To correctly interpret the slope of a line chart, ________.

Intervals on the horizontal axis must be equal.

Text that is aligned evenly between both the left and right margins

Justified

Pressing two or more keys at a time to perform some action

Keyboard Shortcut

The arrangement of placeholders on a slide

Layout

Identifies each data series on a chart

Legend

To show trends over time, the best chart type to use is the ____ chart.

Line

If you want to demonstrate how the values change with the passing of time, use a ________.

Line Chart

A graphic diagram that shows information that is not sequential

List diagram

The first screen you see when you turn on your computer

Lock Screen

The area in the Excel window that displays the name of the cell

Name box

A Word feature that joins a main document and a data source to create customized letters, labels, or envelopes

Mail merge

In a mail merge, the document that contains the text and formatting that remains constant

Main document

If another function is the argument of the ABS function, how will the ABS function affect the result of the nested function?

Makes the answer positive

Used to force the beginning of a new column

Manual column break

Used to force the beginning of a new line without creating a new paragraph

Manual line break

The space between the edge of the paper and the text

Margin

A graphic diagram that shows how parts are related to the whole

Matrix diagram

The button on the title bar that changes names depending on the present size of the window can have which of the following pairs of names?

Maximize/Restore Down

Group of cells that are assigned a word

Named range

To represent a payment of $200 to the bank for repayment of a loan, a cash flow statement would display the number as a(n) _______.

Negative Value

To apply animations to slides, it is best to use the ______ view.

Normal

The main view in PowerPoint that is used to create a presentation

Normal View

Notes for the speaker can be added in the ______.

Normal view (or) Notes Page view (ANSWER WAS A OR B, NOT C)

In Normal view, the portion of the window at the bottom that is used to create notes for the speaker

Notes pane

An area on the right side of the taskbar that keeps you informed about processes that are running in the background

Notification Area

Which of the following is the part of the Windows screen that displays icons for programs that are running in the background?

Notification area.

To import text from another document, use the ______ button found on the _____ tab.

Object, INSERT

An animation applied to a SmartArt graphic

One by One

The most common type of relationship in Access is _____

One-to-many

Reports are used primarily to _______.

Organize and present information.

A data source can be information that is stored in

Outlook, Access, Excel ^(ALL OF THE ABOVE)^

A document format that can be read on computers with different operating systems but not edited

PDF

A file type used to save a PowerPoint presentation to share with others that does not include animations

PDF

A citation in the MLA style that uses the author's last name and the page number, surrounded by parantheses

Paranthetical Citation

A button that displays options when you drag text from one location to another

Paste Options button

If you want to demonstrate how the values in a range of numbers contribute to a total, use a _______.

Pie Chart

Command used to add a program to the Start screen

Pin

Preformatted areas that define the type of information to place in each area on the slide

Placeholders

To include data from Excel in a Word document so that it does not display as a table, use the Paste Special command and choose

Plain Text

Unit of measure of row height

Points

Amount of a loan before it has been repaid

Present Value

In a slide show, to advance to the next slide do any of the following except _____.

Press Esc on the keyboard

Some buttons include a list or gallery of possible results that use the Live _______ Feature.

Preview

A field that contains unique data for each record

Primary key

You may add graphics in all of the following circumstances except to ____

Provide Information (Y) Attract the reader's attention (Y) Embellish every type of document (N) Illustrate a point (Y)

A customizable area containing a Save button and an Undo button

Quick Access Toolbar

A list of available styles in a document, found on the HOME tab

Quick Style gallery

Database objects that summarize information for printing and presentation of data

Reports

To control who has access to a document and what they can do, display the Protect Document menu and select the _____ command.

Restrict Editing

A pane at the bottom or side of the screen that displays comments and tracked changes

Reviewing pane

What is the first step you need to perform to create a new group of tiles on the Start screen?

Right-click in an open area to display the shortcut menu.

END OF CHAPTER 3 QUIZ

START CHAPTER 3

END OF CHAPTER 4 QUIZ

START CHAPTER 4

If a financial function like PMT or FV uses nper and rate as arguments, both nper and rate must use the _____.

Same unit of time

Fonts that do not have lines or extensions on the ends of letters

Sans serif

A description that displays the name of a screen element, button, or area on a window.

ScreenTip

Located in the scroll bar, it can be used to drag a work area up and down or left and right

Scroll box

A part of a document that can be formatted differently from the rest of the document

Section

To create a report using the Report button first you must _______.

Select the object upon which to base the report

A filter that limits the records displayed to only those records that match the value in the selected field

Selection filter

A font that as lines or extension on the ends of the letters

Serif

To display information in the header and footer area of a slide, ______.

Set the Slide options in the Header and Footer dialog box.

To insert a manual line break, press _______.

Shift + Enter

Data labels should be ______ if they might be used as chart labels.

Short

When you click the right mouse button, a list of actions that displays, which are related to the area on which you clicked.

Shortcut menu

The Greek letter that often represents summation is ____.

Sigma

Option on the Shut down or sign out menu that enables a person to leave the computer and close all personal settings

Sign Out

Option on the Shut down or sign out menu that shuts down nearly all the power to the computer but keeps power to the CPU and to RAM, while greatly reducing energy consumption

Sleep

If you need to reorganize several slides in a presentation with 30 or more slides, it is best to use the _____ view.

Slide Sorter

Thumbnail display of slides on a single page that is used to rearrange slides and add transitions

Slide Sorter view

Slide layout images that contain all of the placeholder formats for each slide layout within a theme and are used to change theme formats for all slides

Slide masters

A graphic that creates a visual representation of concepts or information

SmartArt

The quickest way to find all records in a table that match a particular value is the ______ command

Sort Descending

To reduce the potential for problems if you expect a file to be used on Linux or UNIX operating systems, it is a good idea to avoid use of which character(s) in file names?

Space

Presentations can help with all of the following except _______.

Speaking clearly.

Generic term for financial data arranged in rows and columns

Spreadsheet

Button that enables you to quickly switch between the Start screen and the desktop

Start

Which of the following is the screen that displays apps as tiles? (Chapter 1)

Start Screen

How do you close a Start screen app?

Swipe down from the left of the screen.

Words that are similar in meaning

Synonym

When you need to create lists of parallel information, use a(n)

Table

To add or delete a records use a _______

Table or Form

Database objects that store a set of related data

Tables

To remove the table features from rows of data and restore the worksheet to its original appearance, ________.

Takes more than one step. The table is converted back to a range and then the desired formatting must be applied again.

To switch between open applications, click the related button on the _______.

Taskbar

A preformatted and designed document that can be used repeatedly

Template

A preformatted file that is designed for a specific purpose

Template

All of the following are true about a template EXCEPT:

Templates can be customized (Y) Templates are available to create a resume (Y) Templates can be used repeatedly (Y) Templates can only be used once (NO)*

A tool used to turn words into a decorative title

Text Effects

In addition to paragraph styles, what other styles are available in Word?

Text Styles, List Styles, Table Styles ^(ALL OF THE ABOVE)^

To move an image around in a document, you need to change the ______

Text Wrapping

By 1st Level Paragraphs

Text animation effects

Tool used to change plain text into artistic text

Text effect

To organize the data used in a mail merge, sort the data in _______.

The Edit Recipient List dialog box.

When applying a theme to a presentation, the most important factor to keep in mind is ______.

The environment in which the presentation will be given.

An advantage of saving a file in PDF format is ______

The file can be read on a different operating system

One of the advantages of collaborating on editing a file by using a shared folder on a network is _______.

The file is locked while someone is editing it to assure there is only one version of the file

Internet storage is often referred to as the cloud because ______.

The specific location of the storage facility is often unknown

If a table is sorted on two different columns, _______.

The table is sorted by the values in the first column listed in the Sort dialog box, and then, where the values are equal, sub-sorted by the next column listed in the Sort dialog box.

A collection of design elements that are applied to documents to create a uniform look

Theme

A collection of design elements, fonts, colors, and graphics that create a uniform look for a presentation

Theme

In the file list, icons that show small versions of the files

Thumbnails

When you display the files in the file list as Large Icons, what do you call the type of icons that display?

Thumbnails

A square or rectangle on the Start screen that opens apps

Tile

Audience handouts are provided for all of the following reasons except

To make people feel like they are part of a group.

If ten rows of data and labels are placed in columns, the labels should be _______ the data.

To the left of

Formatting used to identify a total in a column

Top and double bottom border

A feature that records changes made to a document by others

Track Changes

Added to slides to control the direction, timing, speed, and manner in which slides enter and exit the screen during a slide show

Transitions

To change the orientation of a table of data from horizontal to vertical or vice versa

Transpose

To immediately reverse an action, click the ______ button.

Undo

Reveals a row or column that is not currently displayed

Unhide

Left edge of a column, line, or histogram chart

Vertical (value) axis

A process of trying different values to see what happens

What-if analaysis

An app that might be used to share a presentation with animations and transitions

Windows Media Video

Collection of worksheets in a single Excel file

Workbook

In Excel, a spreadsheet is called a ______

Worksheet

To check for style such as passive voice, change the _____ options in the ______.

Writing Style, Word Options dialog box

When you format a document with multiple columns, you can do all of the following except _______.

You must format the entire document in the same number of columns.

To use picture as the slide background ______

on the Format Background pane under FILL, click Picture or texture fill. Under Insert Picture from choose the location where image is located. Select the image and then click Insert.

One of the drawbacks of collaborating on editing a file by using email attachments is

other copies of the file might be edited before the file is returned, resulting in different versions.

Tables can be used for _______.

parallel data, financial info, records of data for groups over time ^(ALL OF THE ABOVE)^

Records in an Access database are stored in ______.

tables

If you change a theme after you have formatted a table it may alter the _______

text alignment, font, font size ^(ALL OF THE ABOVE)^


Related study sets

ECON 1022 Exam 2 (Chapter 5, 6, 10, and 7)

View Set

Organizational Behaviour Chapter 1-12

View Set

MKTG 351 Final practice questions

View Set

Chapter 57: patients with inflammatory intestinal disorders

View Set