Shared Flashcard Set

Details

COMPUTER
COMP 1000
100
Computer Science
Undergraduate 1
04/30/2009

Additional Computer Science Flashcards

 


 

Cards

Term
A workbook with 12 worksheets would be saved as ________ file(s)
Definition
1
Term
The ________ is displayed in teh image below
Definition
Active Cell
Term
_______ can be one cell or a group of cells
Definition
Cell ranges
Term
______ are used to document specifics of cell content and are avilable as a frame of reference for users of a workbook
Definition
comments
Term
What is the effect of typing F5+F6 into a cell without a beginning equal sign?
Definition
The entry will be treated as text entry and display F5+F6 in the cell
Term
The _________ is found in the bottom right hand corner of an active cell
Definition
Fill Handle
Term
The types of cell referencing available in Excel are mixed, absolute, and:
Definition
relative
Term
To copy a formula across a range of cells and have the formula automatically update the cell row and column, use the ____________ cell referencing
Definition
relative
Term
To display cell formulas, click the ___________ + ~ Keys
Definition
CTRL
Term
Parameters in an IF function can be _______, value, a formula, or a nested function
Definition
text
Term
To display similar data in a single column, with each series of data distinguished by a different color, use a:
Definition
stacked column chart
Term
The ________ tab is where you will find options to change the source data of a chart
Definition
design
Term
The same data range is used as the basis for an embedded pie chart, as well as a column chart in a chart sheet. Which chart(s) will change if you change the values in a data range?
Definition
Both the pie chart and the column chart
Term
____________ column and row headings enable you to view data easily in a large spreadsheet
Definition
freezing
Term
The command to hide and unhide columns and rows is round in the __________ groups in the Format menu
Definition
Cells
Term
Cells must be ______________ and the sheet protected to prevent edits being made to the data
Definition
LOCKED
Term
To add a second level to a sort, use the ______ option in the sort dialog box.
Definition
add level
Term
Which of the following statements about the Autofilter command is true?
Definition
If two criteria are entered, records must meet both conditions to be selecteD
Term
Clickable text or objects that can be used to connect documents on the WWW are:
Definition
hypertext links
Term
The ____________ view is in Sharepoint designer 2007 can be used to manage the flow of a web site.
Definition
Navigation
Term
The ______ view in Sharepoint Designer 2007 can be used to synchronize files with those created on your local slide
Definition
remote website
Term
The hyperlink target is:
Definition
a file that launches when a hyperlink is clicked
Term
the remote website view can be used to publish
Definition
an entire website
Term
the process of coordinating changes made on a local site witha remote site so that the two are identical is known as:
Definition
synchronization
Term
The ________ report contains comprehensive information about a Web site, such as unlinked files and slow pages
Definition
site summary
Term
In Sharepoint designer 2007 report that displays links targeting unavailable files is the _______ report
Definition
Broken hyperlinks
Term
Access permissions can be used to perform which of the following task?
Definition
All user roles can be assigned except that of administrator
Term
The page banner displays the web page _______ as they appear in Navigation view
Definition
filenames
Term
To add a marquee to a web page
Definition
click dynamic effects in the insert web component diaglog
Term
An advanced control that in normally used by Web designers to add animation and music is a(n):
Definition
Active-X
Term
A software application that gives a browser additional multimedia capability is a(n)
Definition
plug-in
Term
A streaming video file displays a _________ set of images
Definition
sequential
Term
________ files are NOT used as animated images in sharepoint designer
Definition
graphics
Term
_________ files DO NOT support transparent colors
Definition
joint photographic experts group
Term
Use the ____________ task pane to search a comprehensive collection of media files
Definition
clip art
Term
The crop button can be used if
Definition
you want to remove a portion of the picture
Term
Which statement best describes what happens after editing and saving a data record?
Definition
Undo can be used only before advancing to a different record
Term
Data validation best refers to:
Definition
preventing duplicate records from being entered into a table
Term
Which statement best describe the following image?
Definition
one record displayed in a form
Term
Which statement best describe the following image?
Definition
Form Design View
Term
Fields are added, deleted, edited and defined through the:
Definition
Design View of a table
Term
Which of the following would ensure that a value of 15 or greater is entered in a field?
Definition
Validation Rule
Term
Which is NOT true of validation rules?
Definition
They protect from fraudulent practices
Term
Which is NOT true of a calculated field?
Definition
Calculated fields should be stored in a table
Term
Data that is organized and summarized in an easy to read view is known as a:
Definition
Pivot Table
Term
From the following example, which does NOT apply to this view?
Definition
The design view of the table is displayed
Term
Which statement is NOT true of the following image display?
Definition
The display shows that data will definately be lost when the "Yes" button is clicked.
Term
Which statement is NOT true when referential integrity is enforced
Definition
Access checks the accuracy of spelling in the tables
Term
Which does NOT describe queries?
Definition
They are run from a table Datasheet view
Term
Which is an example of an expression that will return records that are from either of two states?
Definition
New York OR California
Term
Which is NOT true of birth date field?
Definition
Using an age field, which shows how old a person may be, is the same as a birth date field.
Term
In the following figure, which letter represents the option for slide layout?
Definition
A
Term
Which of the following are examples of special theme effects?
Definition
Shadowing or flows
Term
What indicates a misspelled word?
Definition
Red wavy line
Term
IN the following figure, which letter represents the tab used to place a table in a presentation?
Definition
A
Term
If you are creating a document that needs a diagram to illustrate a process, use
Definition
smartart
Term
A clip art image is
Definition
A series of combined shapes
Term
To what does aspect ratio refer?
Definition
The proportion of width
Term
When stacking objects, the last object
Definition
has the highest stacking order
Term
If a level is less important it should be
Definition
demoted
Term
When an outline is collapsed, only the ______ of the slides are displayed in the Outline View
Definition
title
Term
If you wish to move a slide in the OUtline View, you should
Definition
drag to the desired location
Term
Which of the following is a feature of the reuse slides task panes?
Definition
browse button
Term
If you crop an image and then try to enlarge the image:
Definition
it may appear as pixilated
Term
Which of the following options can be used to save a picture from the Internet?
Definition
Right-click on the image and choose save picture as
Term
Which of the following options can be used to savea a picture from the internet?
Definition
Right-click on the image and choose Save Picture as
Term
Which of the following is NOT true when photo albums are created:
Definition
They are time consuming to design
Term
Which area allows you to apply a frame to a photo album?
Definition
album layout
Term
When lines of text are straight on the left and right margins, such as most newspaper columns, the test is:
Definition
fully-justified
Term
To keep all lines of a paragraph together on the same page, use the _________ option
Definition
keep lines together
Term
In the following image, dragging the small recangle on the ruler bar will:
Definition
change the left indent
Term
Spacing before and after paragraphs is increased or decreased in
Definition
points
Term
Which of the following is NOT implemented at the section level?
Definition
line spacing
Term
A 3X5 table represents
Definition
three columns;five rows
Term
When you press the Tab key from the last cell in a table, what happens?
Definition
A new blank row is added
Term
Use the __________ command on the layout tab to join two or more cells together?
Definition
Merge Cells
Term
To divide a cell into different cells, use the __________ command
Definition
split cells
Term
One easy way to select a table is to click
Definition
select in the table group on the layout
Term
The _______________ pane shows all comments and editoral changes made to a document
Definition
reviewing
Term
The show Markup feature enables you to
Definition
see all revisions in a document or just certain ones
Term
What feature monitors all additions, deletions, and formatting changes in a document?
Definition
Track Changes
Term
What happens when a revision is accepted or rejected?
Definition
The revision mark disappears
Term
The two option listed with the display for review are:
Definition
original and final
Term
You can insert footnotes and endnotes from the _________ tab
Definition
references
Term
Where is the status bar located in Office 2007?
Definition
At the bottom
Term
What do the shortcut keys Ctrl+S do?
Definition
Save
Term
How can you save a file as a different type?
Definition
Use the save as version box
Term
What is the print preview command found?
Definition
On the Office Menu
Term
If you've spelled a client's name as Jamison and find out that it's Jammison, use the __________ feature to change the occurrences.
Definition
Replace
Term
Where is the Undo button found?
Definition
On the Quick Access Toolbar
Term
What HTML language is composed of special symbols called:
Definition
tags
Term
Which of the following is a network in which computers are located physically close together, often in the same buidling?
Definition
LAN
Term
Which protocol is used to upload and download files from Web servers?
Definition
FTP
Term
What is a single document on the web called?
Definition
A web page
Term
Which is a place on the screen you can click to navigate to another web page?
Definition
hyperlink
Term
In Windows Vista, a window arrangement where open windows are placed on top of each other, with only a small segment of the background window showing is called:
Definition
cascaded
Term
The Windows Vista program that is used for creating and managing folders is
Definition
Windows Explorer
Term
The recycle bin
Definition
contains files deleted from the hard drive
Term
Each window contains control buttons. They are:
Definition
Minimize, Maximinze, Restore, Close
Term
Small pictures on the desktop representing programs, files, folders, or shorcuts are called:
Definition
Icons
Supporting users have an ad free experience!