Shared Flashcard Set

Details

Computer Literacy B
--
163
Computer Networking
11th Grade
08/31/2011

Additional Computer Networking Flashcards

 


 

Cards

Term
Is the following an example of a formula or a function?

=A1 + B3
Definition
Formula
Term
Which of the following formulas divides the sum of cells E9 through H9 by cell D1?
Definition
=SUM(EH9)/(D1)
Term
With what symbol do all spreadsheet formulas begin?
Definition
=
Term
Which of the following formulas is equivalent to =SUM(A1:A3)?
Definition
=(A1)+(A2)+(A3)
Term
Which of the following formulas subtracts cell G2 from the sum of cells F1 through F5?
Definition
=(F1) + (F2) + (F3) + (F4) + (F5) - (G2)
Term
If you type "=2+6" into a spreadsheet cell, what will the cell display?
Definition
8
Term
Which of the following formulas calculates 45% of cell E19?
Definition
=(E19)*45%
Term
Which of the following accurately describes the function of this formula: =(B1)*(C5)?
Definition
Multiplies cells B1 and C5
Term
Which of the following formulas adds cells B5 through D5?
Definition
=SUM(BD5)
Term
Which of the following formulas multiplies cell F4 by cell G8?
Definition
=(F4)*(G8)
Term
If you type "5+8=" into a spreadsheet cell, what will the cell display?
Definition
5+8=
Term
Which of the following formulas subtracts 15 from 80% of cell G10?
Definition
=(G10)*80% - 15
Term
Which of the following formulas calculates the mean of cells E11 through E16?
Definition
=AVERAGE(EE16)
Term
What is the selected cell in a worksheet called?
Definition
Active
Term
To insert an image into a spreadsheet, it must be imported from another program, such as a word processing application.
Definition
False
Term
In OpenOffice.org Calc, the "Borders" tab in the "Page Style" window will allow you to set borders around the cells in your spreadsheet.
Definition
False
Term
Information in the header of a spreadsheet is printed on the top of every page.
Definition
True
Term
What are boundaries of white space immediately inside the boundaries of a page?
Definition
Margins
Term
Footers are not an option in most spreadsheet software programs.
Definition
False
Term
How many margins does a page contain?
Definition
4
Term
What is standard paper called?
Definition
Letter
Term
Which of the following let’s you decide what appears in the spreadsheet based on criteria that you define?
Definition
Filtering
Term
What is it called when paper is turned so the longest side is the width?
Definition
Landscape
Term
To format dollar amounts correctly, you have to type in the dollar sign ($) manually.
Definition
False
Term
When using the chart wizard in OpenOffice.org Calc, what is indicated by the data surrounded in blue?
Definition
This is the data that will be presented in the chart.
Term
What is the way the printed page is laid out called?
Definition
Orientation
Term
What is it called when paper is turned so the longest side is the height?
Definition
Portrait
Term
What are interactive tables that allow you to group and summarize information into a table that can be easily changed so you can look at the data in different ways?
Definition
Pivot Charts
Term
Which of the following determines whether the database should automatically place a value in this field if it is left blank?
Definition
Auto value
Term
If you want to set the kind of data that will be inputted into a field, which of the following settings would you change?
Definition
Field type
Term
You should always delete the primary key before completing a database.
Definition
False
Term
What is a collection of organized data?
Definition
Database
Term
A table is one object that you'll find in a database.
Definition
True
Term
Which of the following are electronic tools that store large amounts of data in one place in a systematic way?
Definition
Databases
Term
Which of the following indicates what will actually be shown in the field?
Definition
Field Name
Term
Which of the following is a program that can be used to create databases?
Definition
Open Office Base
Term
Which of the following requires the database to refuse to move to the next field unless the person entering data puts an integer here?
Definition
Entry Required
Term
Which of the following are uses for a database? (Choose all that apply.)
Definition
Find data, Organize data, Track data
Term
All spreadsheet formulas must begin with a plus sign.
Definition
False
Term
Tools are mechanisms that aid us physically, while technology includes mechanisms that aid us cognitively.
Definition
False
Term
Which of the following are presentation programs that can help you create digital presentations? (Choose all that apply.)
Definition
Microsoft PowerPoint OpenOffice Impress
Term
When you copy information in order to paste it in another location within a document, where is this information temporarily stored?
Definition
Clipboard
Term
What is the purpose of a digital presentation?
Definition
Serve as a supplement or enhancement to a person's physical lecture
Term
Which one of the following is the most accurate definition of technology?
Definition
Any type of tool that serves a practical function
Term
Emoticons are a good way to show emotion in an e-mail while remaining professional.
Definition
False
Term
Which one of the following describes an inappropriate use of technology?
Definition
Purposely posting inaccurate information online as the truth
Term
Which of the following commands will copy information, leaving it in its original location, but making it available to be pasted in another location?
Definition
Copy
Term
In 2 to 3 sentences, describe the difference between the Cut and Copy tools.
Definition
Copy will copy the text and leave the original text there. Cut will copy the text but the original text will no longer be there.
Term
Using word processing software is similar to using which one of the following?
Definition
Typewriter
Term
The e-mail address of the main recipient of an e-mail belongs in which field?
Definition
TO
Term
The e-mail address of any third party recipient of an e-mail belongs in which field?
Definition
CC
Term
Any tool that helps make our physical and mental processes more efficient can be referred to as which one of the following?
Definition
Technology
Term
Which one of the following is true about the subject line of an e-mail?
Definition
It should be a short phrase that describes the contents of an e-mail.
Term
Which of the following can spreadsheet programs help a person with? (Choose all that apply.)
Definition
Calculating Data,Organizing Data
Term
:O is an example of an Internet slang.
Definition
True
Term
Marlon needed to move the text in his opening paragraph to the closing paragraph because it would better fit in that part of his paper. Which function should Marlon use to accomplish the move?
Definition
Cut and paste
Term
Shelby decided to make his own birthday invitations. He wanted to fit two invitations per page. Which function should Shelby use to accomplish this task?
Definition
Copy and paste
Term
A pencil can be considered a piece of technology.
Definition
True
Term
Which one of the following describes an appropriate use of technology?
Definition
Sharing information with others
Term
In 1-2 sentences, briefly describe the main difference between the Internet and the World Wide Web.
Definition
The internet includes all of the networks and servers that we normally don't see. The World Wide Web is the part of the internet that we have access to.
Term
Which of the following are guidelines you should follow when designing a digital presentation? (Choose all that apply.)
Definition
Be consistent.Keep it simple. Make it readable.
Term
Which of the following commands will grab information, removing it from its original location and making it available to be pasted in another location?
Definition
Cut
Term
Charlie e-mailed a customer and sent a copy of it to his boss. In which field did Charlie type in his boss' e-mail address?
Definition
CC
Term
Is the following an example of a formula or a function?

=A1 + B3
Definition
Formula
Term
Which of the following formulas divides the sum of cells E9 through H9 by cell D1?
Definition
=SUM(EH9)/(D1)
Term
With what symbol do all spreadsheet formulas begin?
Definition
=
Term
Which of the following formulas is equivalent to =SUM(A1:A3)?
Definition
=(A1)+(A2)+(A3)
Term
Which of the following formulas subtracts cell G2 from the sum of cells F1 through F5?
Definition
=(F1) + (F2) + (F3) + (F4) + (F5) - (G2)
Term
What is animation that serves a purpose without distracting the audience?
Definition
Meaningful animation
Term
What term defines pieces of hardware that add functionality to a computer?
Definition
Peripherals
Term
When using the chart wizard in OpenOffice.org Calc, what is indicated by the data surrounded in blue?
Definition
This is the data that will be presented in the chart.
Term
If a friend of yours accesses the Internet to find out personal information about another friend of yours, and then tells you what she learned from that Internet research, what would be the most appropriate thing for you to say when given that information?
Definition
"That is most likely an inappropriate use of the Internet, so don't share that information with me or with anyone else."
Term
What is a single computer document called?
Definition
File
Term
Which of the following is a directory that can hold a collection of files?
Definition
Folder
Term
Which button reduces the active window to an icon or task bar button when clicked?
Definition
Minimize
Term
Barney is sending an email to his boss to ask if he can reschedule their meeting on Friday because he has a doctor's appointment. Which one of the following would be the most appropriate subject line for him to use?
Definition
Rescheduling Friday's Meeting
Term
What is it called when paper is turned so the longest side is the width?
Definition
Landscape
Term
Which one of the following is NOT considered to be an inappropriate use of technology?
Definition
Researching information on a new technology that might assist the company for which you work with its own research in a similar area
Term
Mrs. Fitzgerald is sending an e-mail to (e-mailing) to her friend to invite her to her New Year's Eve party. Which one of the following would be the most appropriate subject line for her to use?
Definition
New Year's Eve Party
Term
What is a paper format whose width is 8.5” and height is 11”?
Definition
Portrait
Term
Which of the following is a slide that acts as a template for one or more slides in your presentation called?
Definition
Master slide
Term
Miranda used the same reference several times in her research paper. Which function did she most likely use after she created the first reference?
Definition
Copy and paste
Term
What is a paper format whose width is 11” and height is 8.5”?
Definition
Landscape
Term
Karen double-clicks on a small image on her desktop which opens a folder that contains her homework files. What is the small image on which she clicked called?
Definition
Icon
Term
In a spreadsheet, what are the blank fields where rows and columns intersect?
Definition
Cell
Term
Which of the following are ways to keep a presentation simple? (Choose all that apply.)
Definition
Avoid filling the screen with information and graphics. Provide only necessary information on charts and tables. Use bulleted information rather than complete sentences.
Term
Is the following a formula or a function?

=(5C - 8D)/2
Definition
Formula
Term
What are interactive tables that allow you to group and summarize information into a table that can be easily changed so you can look at the data in different ways?
Definition
Pivot Charts
Term
When the user clicks on an icon, holds down the mouse button, and moves the icon across the screen, what is the user doing?
Definition
Dragging
Term
What is standard paper called?
Definition
Letter
Term
Is the following a formula or a function?

=A2+B2+C2
Definition
Formula
Term
Which of the following is mostly used to manage cash flow, maintain budgets, estimate costs, and so forth?
Definition
Spreadsheet
Term
Is the following a formula or a function?

=7C*13
Definition
Formula
Term
What are the boundaries of white space immediately inside the boundaries of a page?
Definition
Margins
Term
When used as part of online communication, LOL stands for "laugh out loud." What is this an example of?
Definition
Internet slang
Term
Which of the following are file extensions for presentation files? (Choose all that apply.)
Definition
.odp .ppt
Term
In a presentation, how should each slide look? (Choose all that apply.)
Definition
Every slide should be the same style. The same color scheme should be used on each slide. The same transition effects should be used on each slide.
Term
In a spreadsheet, what would the fourth cell down in the second column be labeled?
Definition
B4
Term
Monita wants to create a field in a database that will only allow the user to input a date. Which of the following would she want to set?
Definition
Field Type
Term
When a summary slide is inserted into a presentation, where does it appear?
Definition
At the end of the presentation
Term
Which of the following is a template for the notes pages in a presentation called?
Definition
Notes master
Term
When searching for a key word on the internet, what are you actually querying?
Definition
Large database
Term
Which of the following is an example of interactivity?
Definition
A button that links to another slide
Term
Is the following a formula or a function?

=SUM(A2:A11)
Definition
Function
Term
Is the following a formula or a function?
=C9/C2
Definition
Formula
Term
Navigating through a layout should require the viewer to use critical thinking skills.
Definition
False
Term
What is the invisible structure that serves as the foundation for a design?
Definition
Grid
Term
Dividing a composition into four quadrants enhances the layout by creating a sense of balance.
Definition
False
Term
Elements that are aligned to each other are often perceived as being related.
Definition
True
Term
Which of the following would be most appropriate to use when designing a website?
Definition
Storyboard
Term
People from cultures who read up and down and right to left look at designs in what shape pattern?
Definition
N
Term
People from cultures who read left to right look at designs in what shape pattern?
Definition
Z
Term
When the letter strokes on regular type are adjusted and thickened, what type of font is created?
Definition
Bold
Term
When designers apply the rule of thirds, where do they place the most important elements?
Definition
At any point where the lines intersect
Term
Which of the following would be most appropriate to use when designing an animation?
Definition
Storyboard
Term
Which of the following is a slanted version of regular type?
Definition
Oblique
Term
Which of the following type attributes would be good to use for paragraph text?
Definition
Regular
Term
Designers should place the most important elements in a composition at the mathematical center rather than at the visual center.
Definition
False
Term
Where is the visual center of a page in comparison to the mathematical center?
Definition
Slightly above and to the right
Term
To create a sense of balance and stability, which part of a composition should have more white space?
Definition
Bottom
Term
What is the arrangement of design elements in a composition?
Definition
Layout
Term
Grid units should never be compromised; a single element should not span more than one grid unit.
Definition
False
Term
Which of the following is one of the first things a designer does when faced with a project?
Definition
Design a comprehensive layout
Term
Drew included stock photography in his comprehensive layout for the advertisement. What are these photographs called?
Definition
Placeholders
Term
What is another term for comprehensive layout?
Definition
Comp
Term
What is regular type with a line below it called?
Definition
Underlined type
Term
Which of the following would be most appropriate to use when designing a print advertisement?
Definition
Layout
Term
What is a series of images that summarizes the layouts of each frame in an interactive application?
Definition
Storyboard
Term
What is usability?
Definition
The ease or difficulty with which a product is used
Term
What is the most important thing a designer should be concerned about when designing an interface?
Definition
How the interface design affects the product's user
Term
Which of the following are lists of links that illustrate the hierarchy of the frames the user has visited to reach the current location within an application?
Definition
Bread crumbs
Term
Designers should be concerned with how the design of an interface will affect the use of a product.
Definition
True
Term
Users have to create queries when using a WYSIWYG interface.
Definition
False
Term
Poor interface design might cause the validity of an application's content to be questioned.
Definition
True
Term
Which of the following is a visual element that links a user with the tools and functionalities of a computer program?
Definition
Interface
Term
Which of the following is a motto graphic designers follow when designing the underlying structure of an application?
Definition
Form follows function
Term
Which of the following is an organized hierarchy of links that can take the user to any page or frame in an application?
Definition
Site map
Term
Which type of navigation is simliar to a book because users can move back and forth between frames?
Definition
Reciprocal
Term
Which of the following is the amount of space available on a screen to display information?
Definition
Screen real-estate
Term
Which of the following is an important initial step in designing an interface?
Definition
Audience analysis
Term
WYSIWYG-based interfaces tend to confuse users and should be avoided.
Definition
False
Term
Designers should take into consideration the users' technical experience when designing an interface.
Definition
True
Term
How many items should a menu system have?
Definition
5 to 8
Term
Which of the following is a way to organize information that has multiple levels?
Definition
Drop-down menus
Term
WYSIWYG interfaces offer a friendly buffer between which of the following?
Definition
Users and technical information
Term
Which type of navigation organizes groups of information structures into various levels?
Definition
Hierarchical
Term
Which of the following should interfaces include to lead users where they want to go?
Definition
Visual cues
Term
Which of the following is a great way to save screen space when information on a site can be broken up into clearly defined categories?
Definition
Tabbed menus
Term
Which type of navigation only involves forward motion?
Definition
Linear
Term
Which of the following html tags indicates the end of a link?
Definition
Term
Which of the following html tags indicates the end of an html page?
Definition
Term
Which of the following html tags would you use to name a web page?
Definition
title
Term
Which of the following html tags indicates a horizontal rule?
Definition
< hr />
Term
Which of the following html tags indicates a line break?
Definition

Term
Which of the following html tags would you use after a table?
Definition
Term
Which of the following html tags indicates the beginning of a line item, or item in a list?
Definition
< li >
Term
Which of the following html tags indicates the beginning of an ordered list?
Definition
ol
Term
Which of the following html tags indicates the beginning of a new paragraph?
Definition
p
Term
Typing text into a web page using Nvu is similar to use a common word processing program.
Definition
True
Term
What is a spot on your webpage that you can link to?
Definition
Anchor
Term
You must have a complete knowledge of HTML to use Nvu and other web development applications in the creation of web pages.
Definition
False
Term
Which of the following menu options would upload your file as a web page?
Definition
Publish
Term
What is a piece of text or a graphic that takes the user to another location when he or she clicks on it?
Definition
Link
Supporting users have an ad free experience!