CSIT Unit II
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
A file type used to save a PowerPoint presentation to share with others that does not include animations
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)^
