130 terms

CMS Final

Review Questioons
A collection of information, such as a Microsoft Word document, stored on a computer under a single name is a
A container where files are stored is a
The Windows Explorer program allows the user to __________ the organizing structures of Windows.
A __________ is a rectangular area on the screen where programs and content appear; it can be moved, resized, minimized, or closed
The opening screen in Windows that simulates a work area is called the
A collection of items, such as files and folders, assembled from various locations is called a
A picture, known as a(n) __________, represents a program, a file, a folder, or some other object
__________ is used to navigate the organizational structure of Windows
Windows Explorer
The __________ is the area along the lower edge of the desktop that contains the Start button and an area to display buttons for open programs
Windows taskbar
The Windows feature ____________ allows you to choose which program to sue to start different kinds of media, such as music CDs
The Word feature that determines whether the next word in the line will fit within the established right margin is called
Which of the following is NOT an example of a text effect?
How do you deselect an image?
Click outside the image
Drawing objects include all of the following EXCEPT:
Which of the following is a correct statement about sizing handles?
Using square sizing handles may distort an image
What is the difference between an inline object and a floating object?
A floating object can be moved independently of the surrounding text characters
Graphic objects may be either
Inline or floating
Effects that include borders, shadow, and reflections are:
Picture styles
Which of the following is a small movable container for text or graphics?
Text box
Lines, arrows, callouts, and banners are examples of
When a table has been added to a Word document and is active, what two tabs are added to the Ribbon?
Design and Layout
Which key is used to move from cell to cell in a Word table?
When typing reaches the right border of a cell in a table, wordwrap
Moves the test to the next line within the same cell
The default line spacing within a Word table is
Single spacing with not space before or after paragraphs
Formatting a Word table can include any of the following EXCEPT
Creating graphics within the table
In a table, to move to a tabbed location within the cell and not to the next cell, press:
Ctrl + Tab
simple border edges can be added using the Border button from which group?
When creating a table with four columns, the size of the each column will
Be of equal width
When inserting bullets into a cell, which of the following is NOT true?
The bullet will appear centered vertically in the cell
Which button is used to merge cells so that you can position the table title across the columns?
Merge Cells
Which of the following is NOT one of the standards for MLA style?
Arial, 12 pt font
Which line spacing is used for research papers and reports using MLA style?
Which of the following is a field that can be automatically inserted into a document folder?
The file name
In which dialog box are you able to control line spacing?
Which of the following is a traditional non-numeric footnote symbol?
Which of the following is NOT necessary for footnotes according to MLA style?
Calibri font
With Microsoft's default settings, if a footnote is inserted into body text that is 14 pt Arial font, which of the following is NOT true?
The footnote font size increases with the size of the document font
Which of the following is a statistic automatically tracked by Word?
Number of revisions to the document
In MLA style, citations that refer to items in the Works Cited page are referred to as
Parenthetical references
To position Works Cited entries onto a new page,
Insert a manual page break
An Excel document is called a
The individual pages of an Excel document are called
A _____________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.
A _____________ is created when a row and a column intersect
The _____________ allows the user to enter or edit the value or formula contained in the active cell.
Formula Bar
The _____________ allow(s) the worksheet to be split into two vertical views of the same worksheet.
Vertical window split box
The _____________ displays the name of the selected cell, table, chart, or object.
Name Box
The current cell mode, the page number, and the view and zoom buttons are displayed on the
Status bar
Anything a user types into a cell is known as
Cell content
A text value is also known as a
A predefined formula is called a
The values that an Excel function uses to perform operations are called
Excel's _____________ function finds the middle value in a range.
Which Excel function would be used to find the middle value of a list of test scores
Which Excel function would be used to calculate the total points a student earned on a series of tests?
The Excel function _____________ would be used to find the lowest score on a series of student test scores.
Excel's _____________ function adds all of its arguments then divides the sum by the number of arguments
The _____________ function adds all of the numbers in a range of cells
Excel's _____________ function finds the largest value in a selected range of cells.
The functions AVERAGE and MEDIAN are examples of _____________ functions, which are useful when the user needs to analyze a group of measurements
A _____________ shows the relationship of each part of the data to the whole.
Pie Chart
Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast
Pie Chart
A(n) _____________ refers to a cell by its fixed position in the worksheet.
Absolute cell reference
A cell address used in a formula using a(n) _____________ will be adjusted appropriately when the formula is copied to another cell.
Relative cell reference
65. A _____________ is a value that originates in a worksheet cell and is represented in a chart
Data point
Each pie slice displayed on a pie chart is an example of a
Data marker
On a pie chart, the _____________ determines the size of each pie slice
Data series
The _____________ identifies patterns and colors assigned to categories in the chart.
A workbook sheet that contains only a chart is called a(n)
Chart sheet
One way to tell which slice of pie on a pie chart goes with which set of data is to look at the
A flat database
Is not related to any other collection of data
Raw data that has been organized so as to become useful is also known as
Which of the following is NOT a benefit of avoiding redundancy in a database?
Prevents unauthorized manipulation of data
Good database design does NOT include
Accessible coding so that users can alter the structure
Each table row contains all the categories of data pertaining to one entity and is called a
In Microsoft Access, all data is stored in one of more
An Access record is saved when you
Move to the next record
Which of the following is NOT a characteristic of the Currency data type?
Data must be displayed with two decimal places
To rename a table, you can
Right-click the table name in the Navigation Pane
Before populating a table, which is the correct sequence of steps?
Create and name the database, save the database, create and name the table
Which of the following is NOT true regarding security alerts?
They can be resolved permanently by most college users in the Trust Center
Where can you view the security and privacy settings for Access?
Trust Center
If you accidentally place two copies of the same table list in the Relationship window, the correct method for removing the extra table?
Right-click the table, and select Hide Table
When establishing a relationship, common fields do NOT necessarily need to have
The same field name
Which of the following is possible if referential integrity is enforced within a one-to-many relationship?
Deleting a record from the many table if there is a related record in the one table
In Datasheet view, which of the following is NOT true when a one-to-many relationship exists?
Plus signs indicate that the many table has related records
Sorting a table in descending order by a Last Name field would NOT
Sort ONLY the Last Name field, thus mixing up the records
If you want the records in a table to be sorted by last name then by first name within each last name, you would need to
Sort Lastname as the outermost field in ascending order
Which of the following is NOT a true statement regarding a select query?
A complex select query should be create using the Query Wizard
Which is the primary advantage of creating a new query?
It saves time if your new query uses the same fields as the existing query
Access forms can
Be based on multiple tables
Using a form for data entry can increase the usefulness of a database by increasing
Which is NOT true concerning forms?
Every table must have at least one form
Form Layout view differs from Design View in that
Only Form Layout View allows modifications while viewing data
When you delete records in Access
Any records deleted by mistake must be reentered
To print just one record from a form, which of the following would you choose in the Print dialog box?
The Selected Record(s) option
Compared to the Form tool, the Form Wizard
Allows more flexibility in the layout and design of the form
In Layout view, the _____________ is a small symbol displayed in the upper left corner used to move the entire group of controls.
Layout selector
The advantage of resizing control in Layout view rather than Design view is
By seeing the content of the fields in Layout View, you can visually determine that the space allotted is adequate
Resizing sections in a form must be done in
Design View
The primary editing view in PowerPoint where the user can write and design presentations is
Normal view
When PowerPoint displays a new presentation, the user is presented with one slide, the _____________ slide
PowerPoint's _____________ is displayed below the Slide pane and provides and area for the user to enter information concerning the active slide
Notes pane
A large image of the active slide is displayed in the
Slide pane
The _____________ displays the presentation either in the form of thumbnails or as an outline
Slides/Outline pane
The PowerPoint _____________ allow(s) you to control the look of the presentation window with a set of commands
View Buttons
The current slide number, number of slides in the presentation, and theme are among the items displayed in the
Status bar
The _____________ provides an introduction to the topic covered in the presentation
Title Slide
A PowerPoint presentation is made up of one or more _____________ that can contain text, pictures, tables, charts, and other objects
A _____________ is a box on a slide with dashed or dotted borders that holds titles and body text, or other content such as charts, tables, or pictures
Changing bulleted and numbered styles on a slides is an example of
A box that appears on a slide with dotted or hatched-marked borders where text, charts, tables, or pictures can be placed is called a(n)
When you see a _____________ border around a placeholder, you know that you can edit the placeholder text
A _____________ border around a placeholder means that any formatting commands will be applied to all of the text within the placeholder
The color of the numbers in a numbered list is determined by the presentation
You can customize a bullet by changing any of the following EXCEPT
Its intensity
A button that turns on and off is called a _____________ button.
A _____________ is a single media file including art, sound, animation, or movies
When you use the Clip Art command on the Ribbon to insert clip art, PowerPoint inserts the image
In the center of the slide
When an object is selected, it is surrounded by _____________, which allow you to change the size of the object
Sizing handles
_____________ are a set of coordinating colors that are applied to the backgrounds, objects, and text in a presentation
Theme colors
A presentation's _____________determine the fonts applied to the two types of slide text: headings and body.
Theme fonts
A Presentation's _____________is applied to the slide titles.
Headings font
A presentation's _____________ is applied to all text except the slide titles
Body font
A(n) _____________ is a sound or visual effect added to an object or text on a slide.
An animation that highlights an object or text that is already displayed is called a(n)
Emphasis effect
Animations that bring a slide element onto the screen are called
Entrance effects
A(n) _____________ is used to move an object off the screen.
Exit effect
In the Animation group, the _____________ control the direction and sequence in which an animation plays
Effect Options
Using _____________ allows you to indicate an animation should begin either on the click of a mouse, at the same time as the previous animation, or after the previous animation has finished
Timing options