Shared Flashcard Set

Details

PLS_21~Midterm_1
Information_from_smartsite
347
Plant Sciences
Undergraduate 2
04/28/2012

Additional Plant Sciences Flashcards

 


 

Cards

Term
Where is cloud computing data stored?
Definition
On the internet.
Term
What tool used for video editing lets the video editor to chance the background of the video's subject?
Definition
A green screen.
Term
What are the processes (operations) which define a modern computer?
Definition
Input, Processing, Output, Storage. (IPOS)
Term
What are examples of a section break within Microsoft Word?
Definition
Continuous, Even, Odd.
Term
What are the advantages to computer networking?
Definition
You can reduce hardware costs, enable shared applications, and build massive information resources.
Term
What refers to the usability of the computer and allows for the ability to work with images instead of textual commands?
Definition
The Graphical User Interface (GUI).
Term
Within an operating system, what does a kernal do?
Definition
The kernal acts as a middleman for the operating system and translates information between applications and hardware. A backronym for: Keyboard Entry Read, Network, And Link.
Term
What are the four basic operations of a computer?
Definition

IPOS; Input, Processing, Output, Storage.

 

 

*study guide said electronic data storage

Term
What do operating systems do?
Definition

Operating systems provide a stable, consistent environment for the computer, while managing its hardware and software resources.

Term
What is the main function of the kernal in an operating system?
Definition
The Kernal oversees all operations and allocates resources to different parts of the Operating System.
Term
What is the difference between Hardware and Software?
Definition
Hardware is the physical component of a computer and software includes the applications or programs needed to start and run tasks on the computer.
Term
What are some examples of useful tools that can be used in Microsoft Word?
Definition
Frames, Rulers, Tabs, Mail Merge, and others.
Term
What symbol must precede a formula in order for the formula to work correctly?
Definition
An equals sign (=).
Term
What makes up excell and allows a user to input data?
Definition
Cells.
Term
What are examples of a programming language?
Definition
HTML, Java, CSS, and others.
Term
What is a widow?
Definition
A widow is the last line of a paragraph printed at the top of a page.
Term
What is the definition of software?
Definition
Software means the programs and applications required to start, perform, and run tasks on one's computer.
Term
What are the four basic operationsan electronic device must perform to be considered a "computer"?
Definition
Input, Processing, Output, electronic data Storage.
Term
Why are macros useful?
Definition
They automate repetitive tasks.
Term
What is an example of computer hardware?
Definition
A keyboard
Term
What is an example of an output device?
Definition
Earbuds.
Term
What programs word by recording a sequence of events?
Definition
Macro.
Term
What describes a row in Excel?
Definition
Rows are horizontally aligned cells.
Term
What is an example of hardware?
Definition
Microsoft Word.
Term
What is a Deterministic System?
Definition
A deterministic system runs a known program whenever prompted by the user.
Term
What are the columns in Excel?
Definition
Vertically aligned cells.
Term
What elements does HTML consist of and why are these elements needed?
Definition
HTML consists of Tags, and the browser needs tags to interpret the content of the page.
Term
What does a function in an Excel spreadsheet do?
Definition
An Excel spreadsheet function performs mathematical or logical operations.
Term
What is the correct term for the file extension of a Microsoft Word Document?
Definition
.doc or .docx
Term
When freezing panes, which row would have to be highlighted in order to freeze 5-8?
Definition
Row 9
Term
What are used to create space within a document to place a particular object?
Definition
Frames.
Term
What is an example of absolute addressing for column but not row in an Excel spreadsheet?
Definition
$A4+$D3
Term
What is an example of a relative column and an absolute row cell address in an Excel spreadsheet?
Definition
=A$3+B$5
Term
What are some examples of a word processor's characteristics?
Definition
A word processor requires special training to use, can record and edit text, combines the keyboard text entry and printing functions of an electric typewriter, and refers to an obsolete type of stand-alone office machine.
Term
What are some things that Excel spreadsheets do?
Definition
Make data manipulation easy, handle logical operations, and produce tables and charts.
Term
What are some examples of an operating system?
Definition
UNIX, DOS, Linus.
Term
What is an example of a programming language that can be used to create a webpage?
Definition
ASP.Net
Term
What are some examples of types of video formating?
Definition
MPEG, MOV, WMV
Term
What is the intersection between a column and a row on an Excel spreadsheet?
Definition
A cell.
Term
The operating system mediates interactions between...?
Definition
Hardware and software, and internal and external components.
Term
Define an application suite.
Definition
A group of programs, sold as a package to solve common problems.
Term
What kind of anti-virus software should someone buy if they just bought a new computer and like to try things before buying?
Definition
Shareware.
Term
What does an operating system do?
Definition
Handles input and output, and manages programs and memory.
Term
CNTRL1 pops up the cell dialogue, there is a limit to how many cells a sheet contains, and number manipulation is easy on what software?
Definition
Microsoft Excel
Term

What are some pitfalls of using Excel spreadsheets?

 

Compatibility issues is not one of them.

Definition
Formulas can have mistakes, design can be poor, important formulas may get buried, and there may be assumptions in the data.
Term
Which of the following are formats of breaks in Microsoft Word?
Definition
Section breaks, even/odd breaks, page breaks.
Term
The Operating System (OS) establishes and runs virtual memory, which enables the computer to...
Definition
run programs larger than the physical size of the memory.
Term
In Excel, a cell...
Definition
contains data.
Term
What is an example of absolute referencing?
Definition
$E$5
Term
Where are most robust programs delievered?
Definition
The Hard Drive.
Term
Which of the following is the correct order of document hierarchy from low to high?
Definition
word, paragraph, pages, document.
Term
What are the three layers of internet protocol?
Definition
Internet Protocol (IP), Transmission Control Protocol (TCP), File Transfer Protocol (FTP).
Term
Why were spreadsheets invented?
Definition
To make processors appear to be bug-free in comparison.
Term
How do you keep your inputted fraction "3/8" from converting to a date, "8-March"?
Definition

Put a "0" before the fraction with a space inbetween.

 

Example: 0 3/8

Term

What is some of the information needed to create a story board under its basic requirements?

 

Hint: Finding actors for scenes is not one of them.

Definition
Stech scenes, identify needed equiptment, add critical dialogue or scene titles.
Term
What is the difference between commerical software and shareware software?
Definition
Commerical software is paid for and shareware software is free for a limited time.
Term
What are the three ways of referencing cells when building formulas in an Excel spreadsheet?
Definition
Using relative, absolute, and mixed referencing.
Term

What are examples of major web browsers?

 

Hint: Adobe is not one of them.

Definition
Internet Explorer, Chrome, Opera.
Term
Story Boarding began in the 1930s with:
Definition
Walt Disney Studios
Term
What are some software properties?
Definition
Its applications and programs are needed to start the computer and perform computer tasks.
Term
Asp.net and PHP are now mainly used:
Definition
For programming software and controlling databases.
Term

What are some advantages of networking?

 

Hint: Reducing software costs is not one of them.

Definition
Reduce hardware costs, enable shared applications, connect people.
Term
Operating systems perform what tasks?
Definition
Operating systems mediate interactions among internal and external components, and manage hardware and software resources.
Term
For what purposes does the business world use Excel?
Definition
To organize, analyze, and track data.
Term
What was the first spreadsheet program available for personal computers?
Definition
VisiCalc
Term

ASP.NET is a web application framework developed and marketed by Microsoft to allow programmers to build:

 

Hint: Web desiging programs is not an answer.

Definition
Dynamic web sites, web applications, and web services.
Term
What is an example of rendering?
Definition
AVI
Term
In programming, what does "VBA" stand for?
Definition
Visual Basic for Applications.
Term
What is a VBE and what does it do?
Definition
Visual Basic Editor (VBE); a program within Excel that allows you to communicate with Excel
Term
What is an example of a computer platform?
Definition
Windows 7
Term

An operating system can be classified into what?

 

Hint: Multi-user single-task is not an aswer.

Definition
Single-use single-task, single-user multi-tasking, and multi-user
Term
What are the advantages of networking?
Definition
Networking will reduce hardware costs, enable shared applications, and build massive information resources.
Term
 _________ makes up the physical components of your computer, while ________ runs and performs its tasks.
Definition
Hardware, software
Term

What are examples of window names in the Visual Basic Editor (VBE)?

 

Hint: Workbook Window is not one of them.

Definition
Project Window, Properties Window, and Code Window.
Term
A computer can only do one thing at a time unless it is _______.
Definition
A multicore computer.
Term
What are some basic operations of a computer?
Definition
Input, Processing, Output, electronic data Storage.
Term
What are some statements that explain an Excel spreadsheet?
Definition
A spreadsheet is a program that minics a paper ledger and incorporates a grid.  The first spreadsheet program available for personal computers was VisiCalc and it converted the computer from a hobby into a business tool.  Cells, rows, and columns are among some of the key elements of a spreadsheet. A spreadsheet can produce tables and charts, and handels more than just numbers.
Term
What are one of the kernel's function in a modern operating system?
Definition
The kernel is the heart of a modern operating system and also allocates resources to the other parts of the operating system.
Term
Bios, which initializes the hardware, is classified as what?
Definition
Bios is a bootloader.
Term
What does "rendering" a movie clip mean?
Definition
Rendering is the process of taking the project file and converting it to a self contained file format.  It also finalizes the movie clip.
Term
Considering that every IP v4 address must have four 3 digit numbers and a certain amount of octals, what is an example of a valid IP v4 address?
Definition
153.234.1.10
Term

Operating systems...

 

Hint: Operating systems are not installed in all computers.

Definition
Operating systems manage software and hardware resources of the computer system, provide a stable consistent enbironment for applications to operate, and act as a office cop, translator, and resource manager.
Term
Browsers are typically used to access the World Wide Web (WWW).  However, what is another use for browsers?
Definition
Browsers provide access to information and files in private web servers.
Term
$ is placed before a column letter or a row number in order to indicate what?
Definition
An absolute column or row.
Term
On Excel, how do I freeze rows 1-5 on my spreadsheet? (Under Windows)?
Definition
Hightlight Row 6 and select "Freeze Panes" under the View tab.
Term
What are some aspects to application suites?
Definition
They are a group of programs that are bundled together in a package with a common interface for ease and affordability.  Common examples are "office suites".
Term
What are the 3 layers of protocols (multiple programs used to facilitate movement of packets over the Internet)?
Definition
Internet protocol, Transmission Control protocol, and Application protocol.
Term
Which of the following is not a window that should always be showing when working with the Visual Basic Editor?
Definition
The Task Manager Window.
Term

What are some parts of a document's hierarchy?

 

Hint: Themes are not a a part.

Definition
Characters, pages, and sections.
Term

Which of the following statements is incorrect?

 

Dim statement performs with a variable declaration. Every visual basic program must contain a main procedure. Sub is the short form of subroutine. Basic code is only based on subroutines.

Definition

Incorrect: Basic code is only based on subroutines.

 

Term
What loads and runs device drivers?
Definition
An operation system.
Term
What does HTML stand for?
Definition
Hypertext Markup Language.
Term
What system or process allows you to use productivity tools through web based applications and storage?
Definition
Cloud computing.
Term

What are Excel spreadsheets are used for?

 

Hint: Spreadsheets are not perfect for handling graphics.

Definition
Manipulating numbers, using a grid, automatically linking values and formulas/
Term
Word Document hierarchy:
Definition
characters, word, sentences, paragraph, pages, sections, documents
Term
When sending workbooks to the "Recycling Bin," the VBA procedures (macros) are ________.
Definition
destroyed.
Term
Some Excel spreadsheet basics.
Definition
Worksheets, rows, columns, cells.
Term
What is the main function of the kernel in an Operating System?
Definition
Connecting the hardware to the software.
Term
What is wrong with the Operating System?
Definition
The Operating System is the first, but not hte last software you will see when you turn on and off the computer.
Term

Types of computer networks.

 

Hint: DCHP is not a type of computer network.

Definition
WANs, LANs, Internet.
Term
What are the A/V formats and which formats do most images for video production use?
Definition

The A/V formats are Raster (Pixel based images: .JPG, .TIFF, .GIF, .PNG, .BMP) and Vector (Line based images: .SVG, STL, DQG) formats. 

 

Most of video production uses Vector formats.

Term
Which of the following are some uses of Cache Memory?
Definition
Arithmetic Logic Unit, Control Unit, and Interface Unit.
Term
Name a task that could be easily and usefully delegated to a macro in a word processing program.
Definition
Format changes - including margins and fonts.
Term
Memory and storage facts.
Definition
Virtual and physical memory both exist. Storage is not transient. A hard drive is an example of a storage device. Memory disappears when the power is turned off.
Term
Three internet application protocols are:
Definition
Hypertext Transfer Protocals, Files Transfer Protocals, and Simple Mail Transfer Protocals
Term
What is an I/O Device?
Definition
Input and Output device
Term
What are types of computer networks?
Definition
LANs (local area networks), WANs (wide area networks), and the Internet (a network of networks)
Term
The basic networking set up includes...?
Definition
Firewall, Server, Switch.
Term
Examples of applications for Excel spreadsheets.

Hint: updating a website is not one.
Definition
accounting, scientific modeling, and creating simulations. (among others)
Term
The first spreadsheet available for personal computers was...
Definition
VisiCalc
Term
How many bytes are in a kilobyte?
Definition
1024
Term
Where are the tabs located on a microsoft document?
Definition
The ribbon interface
Term
In what order did the evolution of networking occur?
Definition
Electric Computers, Local Area Networks, Internet, E-mail, World Wide Web
Term
Can a CPE do multiple things at a time? If so, how?
Definition
No, unless it is a multicore.
Term
What are the three layers of protocols?
Definition
Internet Protocol, Application Protocol, Transmission Control Protocol
Term
When was the World Wide Web developed?
Definition
1989
Term
What keys move the user to the previous worksheet?
Definition
Ctrl + Page Up
Term
What is the difference between hardware and software?
Definition
Hardware is the physical aspects of a computer, while software is what you put on your computer.
Term
What is the purpose of a web browser?
Definition
To be able to read HTML documents, access the World Wide Web, and interpret mark up language and compose it into visible or audible web pages.
Term
Itunes is an example of what?
Definition
hardware
Term
Which of the following are the correct definitions for LAN and WAN?
Definition
LAN = local area network; WAN = wide area network
Term
What is the difference between horizontal and vertical application suites?
Definition
Horizontal Application Suites bundle software designed to support multiple functions and requirements, but vertical application suites are specialized for a specific buisness.
Term
What are Macros?
Definition
A way of programming word by recording a sequence of events.
Term
What is the purpose/function of a green screen?
Definition
To create a uniform background that makes editing easier.
Term
Which of the following is a piece of hardware?
Definition
Motherboard, Case, and Ram.
Term
When referring to Excel what is syntax?
Definition
Language of the Function
Term
Although Operating Systems (OS) manage the hardware and software resources of the computer, the BIOS that is used to initialize the hardware within the OS is a form of:
Definition
Boot Loader
Term
How many jobs can a CPE do at one time, if it is not a Multicore?
Definition
One
Term
What keys do you press to access the task manager?
Definition
Ctrl Alt Delete
Term
Where you can find Mail Merge in MAC?
Definition
Menu bar-tools
Term
Examples of productivity suites.

Hint: Microsoft word is not a productivity suite
Definition
Open office, Google apps, Word perfect.
Term
What is a Macro?
Definition
A shortcut you create.
Term
What is an output device?

Hint: A keyboard is not an output device.
Definition
A monitor, speakers, a printer.
Term
What year was Microsoft Word created?
Definition
1983
Term
Computer networks.

Hint: A Browser is not a computer network.
Definition
LAN, WAN, the internet.
Term
What is a BitTorrent (P2P) network?
Definition
A common network used to share larger files, the breaking down of large files which are then transferred to the user.
Term
What is a sub, and what is one use for it?
Definition
Subroutine, used to split a task into individual procedures.
Term
If a file is dragged from one drive to another drive...
Definition
a copy is made in the new drive location and the original is left untouched.
Term
What is the purpose of a web browser?
Definition
To read HTML documents and compose HTML tags into visible or audible web pages.
Term
What are two different kinds of transmission that can occur over a network?
Definition
circuit and WAN switching
Term
Examples of computer networks.

Hint: Keyboards aren't computer networks.
Definition
LANs: local area networks
WANs: wide area networks
Internet: a network of networks.
Term
What percentage of the VBA work is done in the Code Window?
Definition
90%
Term
How do you sum together multiple cells in an excel worksheet under OS-X?
Definition
Click on the Sigma icon in the toolbar.
Term
What is the practical difference between cicuit switching and packet switching?
Definition
Packet switching is slower and more reliable.
Term
When using Microsoft Excel, which of the following are required to create a function?
Definition
= (equal sign)
Term
What's an operating device or system used for computing?
Definition
the platform.
Term
An example of a horizontal application suite would be:
Definition
Microsoft Office
Term
An example of computer hardware includes...
Definition
the hard drive
Term
On excel, what do you type to multiply the content in two cells?
Definition
=C4*C8
Term
The cell address $D$7 has ____.
Definition
an abolute column and an absolute row.
Term
Why were spreadsheets invented?
Definition
In order to make word processors less "buggy"
Term
What is hardware?

Hint: Microsoft word is not hardware.
Definition
Monitor, hard drive, keyboard.
Term
Computer networks are...?

Hint: BANs is not a type of computer network.
Definition
LANs, WAns, and the Internet.
Term
What are the three ways of referencing cells when building formulas?
Definition
Relative references, absolute references, and mized references.
Term
How do styles enhance workflow and productivity in Microsoft Word?
Definition
Styles enhance workflow and productivity by minimizing repetivite tasks.
Term
If an Operating System is "Thrasing" it:
Definition
Spends most of its time swapping information between virtual memory and RAM. Spends most of it's time swapping between cache and main memory. It has a severe imbalance between RAM and virtual memory or between cache and main memory.
Term
If you want to freeze row 6, where do you need to highlight?
Definition
row 7
Term
Examples of equipment used for the collection of A/V footage.
Definition
Audio recorder, video camera, green screen.
Term
What was the first spreadsheet available for personal computers?
Definition
Visicalc.
Term
What is correct about a Byte?
Definition
It is a number of bits grouped into a "word"
Term
Story boarding.
Definition
A graphic process to organize a project pioneered in the 1930s by Walt Disney Studio. It means to identify the visual content required for each scene and touches on the audio content as well.
Term
What is the difference between "Subs" and "Functions"?
Definition
A function takes some arguments as parameters and returns any values back, while a sub doesn't.
Term
Computer networks.
Definition
LANs, WANs, the Internet
Term
Physical components of the computer.
Definition
Motherboard, Case, Hard Drive
Term
Which part of the URL http://www.thisisanexample.com is the domain name?
Definition
thisisanexample.com
Term
What are some of the key elements of Excel?
Definition
rows, cells, workbook, syntax.
Term
Speakers, a computer monitor and a printer are all examples of..
Definition
Input and output devices.
Term
The World Wide Web Consortium (W3C)

Hint: it does not create regulations for censorship in the World Wide Web.
Definition
Encourages the use of CSS over explicitly presentational HTML markup, ensures consistency across splatform s, and is the main international standards organization for the World Wide Web.
Term
When was Microsoft Excel introduced for Macintosh?
Definition
1985
Term
What is the default WORD document format?
Definition
.DOC
Term
Programming languages that can be used to create a webpage.

Hint: PTP is not included.
Definition
HTML, Java, and CSS
Term
What toold in Microsoft Word allows you to take multiple files / records from a spreadsheet, database, or other document and apply them to your current document?
Definition
Mail merge
Term
Spreadsheets in Excel dont have left or right tabs, but they do have..
Definition
Formulas, syntax, and function.
Term
What is the purpose of the Operating System?
Definition
To manage the hardware and software resources of the computer system.
Term
What is the correct document for hierarchical order for formatting?
Definition
Documents, Sections, pages, paragraph, sentences, words, characters.
Term
PEMDAS
Definition
Parenthesis, Exponent, Multiplication, Division, Addition, Subtraction.
Term
The hardwares in an operating system include..
Definition
BIOs, CPU, ROM
Term
Data driven decision making
Definition
relies on information to inform decisions.
Term
Hexadecimal is a numbering system containing ________ symbols as base units.
Definition
16
Term
How many Central Processing Unit(s) does a computer have and what does it do?
Definition
1 and it carries out instructions and performs data manipulation.
Term
Operating Systems..
Definition
Manage hardware and software of the computer system and mediate the interatctions among both internal and external components.
Term
What is the proper way to restart a computer when the OS freezes completely?
Definition
Cold boot the computer.
Term
Benefits of a computer network?
Definition
Reduce hardware costs, connect people, build massive information resources.
Term
Which of these is not a file extension of a Pixel Based Image?
Definition
STL
Term
What are some programs can you make a video on?
Definition
Windows Movie Maker and iMovie
Term
Physical components of the computer?
Definition
Motherboard
Term
Which of the following is a container format?
Definition
.avi
Term
[Microsoft Word] In Word: Command + 2 = ?
Definition
Double space selected text.
Term
Which protocol layer defines the packets that carry data from one node to another?
Definition
Internet Protocol.
Term
Key elements of a spreadsheet?

Hint: Absolute addressing is not one.
Definition
Rows & Columns, Formula Bar, Locations of Cells.
Term
Who pioneered story boarding in 1930?
Definition
Walt Disney
Term
A correct line of Visual Basic.

Hint: Answer is not 2-MsgBox ("PLS21")
Definition
MsgBox("PLS21") Display on computer screen, MsgBox("PSL21"), End Sub
Term
What is an orphan when referring to Microsoft Word?
Definition
The first line of a paragraph printed at the bottom of the page.
Term
The term "Information literacy" refers to the ability to do which of the following?
Definition
gather data and information and integrate then evaluate them.
Term
"Format Cells" allows you to format your Excel to do all of the following except..
Definition
delete cells
Term
A green screen is used in filming to create a uniform background that
Definition
will be later replaced by a more complicated image.
Term
What is a benefit of circuit switching?
Definition
teleconferencing.
Term
Hardware.

Hint: Itunes is NOT hardware.
Definition
Motherboard, Case, Ram.
Term
When editing live to tape, closed circuit, or TC, the type of video editing is also known as:
Definition
Linear Editing
Term
What is the first and last program that you see when you turn your computer on and off?
Definition
Operating System.
Term
Which of these is a characteristic of Packet switching?
Definition
data is moved in separate, small blocks.
Term
What is the purpose of a web browser?
Definition
To read HTML documents and compose them into visible or audible web pages.
Term
Which of the following applications is an example of cloud computing?
Definition
Drop Box
Term
The heart of a modern operating system is called?
Definition
Kernel (Task Management)
Term
What is a Macro in excel used for?
Definition
To create your own shortcut
Term
What is the function of the Operating System?

Hint: Network Security is not an operating system function
Definition
handling input and output, managing programs and memory
Term
What is the first and last program that you seen when you turn your computer on or off?
Definition
The Operating System
Term
Packet switching characteristic.
Definition
Data is moved in separate, small blocks
Term
What is the purpose of a web browser?
Definition
To read HTML documents and compose them into visible or audible web pages.
Term
cloud computing
Definition
dropbox
Term
The heart of a modern operating system is called?
Definition
Kernel (Task Management)
Term
What is a Macro in excel used for?
Definition
To create your own shortcuts.
Term
An operating system...

Hint: an OS is not network security
Definition
handles input and output, manages programs and memory
Term
A graphic process to organize a project..

hint: does not incude deciding who to cast
Definition
Identify the scenes to be collected, identify the various camera angles needed to tell the story, highlight key text/dialogue
Term
What command is helpful when viewing a worksheet that contains more rows or columns than can be shown in a single screen?
Definition
Freezing panes.
Term
What describes the meaning of Relative addressing of cells in Microsoft Excel?
Definition
Relative Cell Address is referenced in respect to the current position.
Term
Microsoft Word offers a large set of tools to style your documents, but only a few tools to help with writing style. What are some tools that are used for writing style?

Hint: Widow/orphan is not one.
Definition
Spelling & Grammar checker, Dictionary, and Thesaurus
Term
Correct usage of Autodesk.
Definition
Dedicated to 2D & 2D graphic design software for the gameing, film, engineering, and architectural industries.
Term
An operating system's function.

Hint: it does not manage the database.
Definition
Manages programs, establishes the user interface, and handles input and output
Term
programs available in Microsoft Office Word.
Definition
Spreadsheets, Cloud based platform, Business programs.
Term
The process of Editing Live to tabpe, closed circuit, or TV is called..
Definition
Linear Editing
Term
What can excel do while processing a large range of data?
Definition
Data analyzing, create charts, arrange data
Term
Which of the following is a primary characteristic of Cascading Style Sheets (CSS)?
Definition
The separation of HTML document content to improve accessibility, content, and control.
Term
Which subsection do you find the menu to change the line spacing of your document?
Definition
Paragraph
Term
What is a macro?
Definition
A way to program Word by recording a sequence of events.
Term
Which answer contains only examples of computers?
Definition
Drones, GPS, Wireless Irrigation System
Term
Hardware

Hint: Microsoft Word is NOT hardware.
Definition
Mouse, keyboard, Ram
Term
Why were Cascading Style Sheets (CSS) a helpful addition to web design?
Definition
Users of HTML could avoid having to type the same formats multiple times by using a single style sheet.
Term
In Excel, what are columns and rows signified with?
Definition
Columns are signified by letters, Rows by numbers.
Term
Functions of Mail Merge.

Hint: Mail merge does not field/record and apply it to the document
Definition
Mail Merge makes quick work of mass customization projects, and can be linked to other documents (spreadsheets, databases, and outlook contact lists).
Term
What is the best definition for hypertext markup language?
Definition
An internet based hypertext system, A markup language that web browsers use to interpret and compose text, images and other material into visual or audible web pages. Also known as html.
Term
File transfers.
Definition
A copy of the file is made when transferring between two different drives, and the file is moved when transferring within the same drive.
Term
Definition for hypertext markup language?
Definition
An internet based hypertext system. A markup language that web browsers use to interpret and compose text, images and other material into visual or audible web pages. Also known as html.
Term
When referring to computers, what is networking?
Definition
"practice of linking computer devices together to support digital communication among them."
Term
What is a thread and what fuction does it not perform?
Definition
A thread is a basic process that does not allow input of output control. Threads do not have to be identical in performance, but can retrieve performance instructions from the same source.
Term
What is it called when you keep specific rows or columns visible when you scroll in the Excel Worksheet?
Definition
Freeze Panes
Term
Why is an Operating System essential in a computer?
Definition
It enables the computer hardware to communicate and operate with the computer software
Term
What is PHP's function in terms of web design?
Definition
It is a general purpose server side scripting language
Term
What is HTML?
Definition
Hypertext markup language; tagging text and graphics and using language to tell how it is displayed
Term
What is the term that refers to technical knowledge and skill in the use of computers and information technology?
Definition
Computer Literacy
Term
How do you delete a column?
Definition
right click + delete
Term
What window(s) should be open when you are working with Excel's Visual Basic Editor?
Definition
The Project Window, the Code window, the properties window.
Term
How do you absolute reference a cell in excel?
Definition
Add a $ sign in front of the cell name, or press F4
Term
File structure

Hint: it does not organize files in groups based on content
Definition
Organizes files in a location that is easy to find. Organizes files so that any referenced file or material is easily linked in the same foler or subfoler. Organizes files in groups based on themes.
Term
What is the right description about key elements of spreadsheets in Excel?
Definition
Cells contain various types of numbers, text, formula, ect.
Term
What happens to a file when moved from folder to folder on the desktop?
Definition
The file is completely moved to the new folder
Term
A Web Browser is, in its most basic form, what?
Definition
A software application for retrieving, presenting and traversing information resources on the World Wide Web.
Term
Types of interfaces.

Hint: RAM is not a user interface
Definition
Command-line, Menu-drive, Graphical (GUI)
Term
Mail merge is a useful tool in Microsoft Word that..
Definition
Takes multiple fields/records and applies your fields to your document. Can be linked to a spreadsheet, database, other document, or even an outlook contact list. Makes quick work of mass customization projects.
Term
What is the file extension on a Microsoft Word document?
Definition
.docx
Term
Which of the following is the correct hierarchy?
Definition
Documents; Sections; pages; paragraphs; sentences; word; characters
Term
A vertical application suite is defined as:
Definition
a specialized grouping of programs designed for a specific task
Term
What does IPOS stand for?
Definition
Input, Processing, Output, Storage
Term
From lowest to highest, the three layers of internet protocols are:
Definition
IP, TCP, Application Protocol
Term
Microsoft office Word allows you to do which of the following?
Definition
Word process text
Term
What is a RAM?
Definition
It is the primary area where the computer stores information as it is processed
Term
How to change the document view? (ex. full screen view, notebook layout view, or outline view)
Definition
Botto left of the window
Term
What is the benefit of a common user interface between applications in a suite?
Definition
consistency
Term
What is primarily used in separation of document content?
Definition
CSS
Term
ROM (read only memory) is a type of storage that:
Definition
can't be removed; and can be read only. Data is also prerecorded.
Term
Goal Seek is an advanced option in excel that allows users to calculate numerical solutions and equations and is accessed how?
Definition
data tab --> what if analysis --> goal seek
Term
What resource can be used in order to navigate a browser to related resources?
Definition
Hyperlink
Term
What is the difference between a computer's hardware and software?
Definition
Hardware is the physical components of a computer such as it's monitor, while software is it's applications.
Term
Examples of software categories.
Definition
Commerical, Open source, Shareware
Term
common layouts of networks.

Hint: ribbon network is not a common network layout
Definition
Bus network, star network, ring network
Term
What is the purpose of programming for computers?
Definition
To give the computer a set of directions, to allow it to perform several tasks at once, and to translate the keystrokes to actions.
Term
What is running a single system when more than one CPU?
Definition
Multiprocessing
Term
What window(s) should always be showing to be efficient with the VBE?
Definition
The project window, code window, and the properties window.
Term
What is computer programming?
Definition
it's the process of design and maintenance of computer programs.
Term
Tab options provided by the rules in MS Word.

Hint: Continuous is not a tap option.
Definition
Center, Bar, Decimal, ect.
Term
What is the shortcut key for "Cut"?
Definition
Ctrl+X
Term
What is the main goal of mail merging on microsoft word?
Definition
To send out to multiple recipients the same letter in an organized and sucinct manner.
Term
The 3rd step of instructions in the CPU is:
Definition
Fetch Operands.
Term
Output devices

Hint: Keyboard is input
Definition
Monitor, speakers, printer
Term
Storyboarding is a graphic process to organize a project that:
Definition
Identifies the scenes (video) to be collected, as well as the various camera angles needed to tell the story, and highlights key test/dialogue.
Term
What does Bcc do when attempting to send emails?
Definition
It sends to multiple recipients and recipients that recieve it are able to view other recipients who received the same email
Term
How doe a macros recorder work?
Definition
It records any actions that are made on a Microsoft application (e.g. Word, Excel) and creates a short-cut for all of the recorded actions in the form of a combination of keyboard buttons
Term
What is the name for the file extension that is used to identify an Apple Quick Time Movie?
Definition
MOV
Term
What is a BIOs and what does it do?
Definition
Basic input/output system; initializes hardware
Term
How do you cold boot a computer?
Definition
Hold the power button down.
Term
Using macros when creating macros will..?
Definition
Make the created macro not work.
Term
Which computer works without an Operating System?

Hint:Smartphones, routers, Android, Linus, Mac OS X, and wireless stations all incorporate operating systems.
Definition
VHS, HI Speed USB 2.0
Term
What is one way to help counter the pitfalls of formulas in Excel?
Definition
Divide them into components.
Term
What doe sthe letter 's' in https stand for?
Definition
Secure
Term
What does the acronym RAM stand for?
Definition
Random Access Memory
Term
Why does one need to have an operating system already loaded into memory to load the system into memory?
Definition
The computer's hardware cannot perform complex actions, so it needs to have it already loaded when it turns on.
Term
You wnat to use a piece of software for a project that will only take a few days, however you do not want to pay for it. What type of software will you NOT be using?

Hint: you will be using freeware, shareware, and open source
Definition
Commerical
Term
How do the bars show up on the Windows GUI from top to bottom?
Definition
Title bar, Menu Bar, Toolbars, Status Bar
Term
Tap options in the MS Word ruler

Hint: Continuous is not an option
Definition
Center, Bar, Decimal, Left, Right, ect.
Term
Codecs..
Definition
Encode data streams or signmals for transmission, are used in videoconferencing, can be used to store data, and decode data streams or signals for playback or editing.
Term
Where are default characteristics for every item of HTML markup defined?
Definition
In the browser
Term
What is HTML?
Definition
Hypertext markup language; tagging text and graphic and using language to tell how it is displayed.
Term
How do I change the margins on Word for a document?
Definition
Go to File, PAge Setup, select Microsoft Word Settings, select MArgins, change margins to desired positions.
Term
WHat statements are true about vertical application suites?
Definition
Vertical application suites are likely to be purchased by a veriety of different companies and individuals. A vertical application suite is a specialize system meant for a narrow purpose or specific buisness.
Term
In MS Word Command + 2?
Definition
Double Space
Term
Which is not an advantage to package switching?
Definition
Order of packets is important.
Term
Advantages of package switching.

Hint: the fact that the order of packets is important is not an advantage.
Definition
its cheap, efficient, and dropped packets are resent.
Term
Autodesk is a company dedicated to 2D and 3D graphic design software for what industries?
Definition
gaming, film, engineering and architectural industries
Term
What's difference between moving a file from one drive to another and moving a file from two folders within the same drive?
Definition
A copy is made in the new drive location (only copied), and within the same drive the items are moved (copied and cut)
Term
When working in Excel, _____ cells appear with dollar signs between the numeral and letter which give a cell its name. These cells are used in _____ referencing.
Definition
Locked, absolute.
Term
What is the minimum amount of time it typically takes to edit 1 minute of video?
Definition
45 mintues.
Term
One of the key elements in excel is a ______. It is the intersection of a ROW and a COLUMN. It contains the data.
Definition
Cell
Term
examples of an input/output (I/O) device?
Definition
digital camera, printer, flatbed scanner
Term
Virtual memory
Definition
part of the hard dis that is used to hold information as if it were RAM. It allows the computer to work as if it had a lot more memory than it physically has, without a large reduction in performance.
Term
Which of the following is the proper file extension for files created in Microsoft Word 2010?
Definition
.docx
Term
How are horizontal applications used?
Definition
To perform one task or one kind of task, but also used across the fuctional divisions of an organization
Term
What effect does rendering have on the project file?
Definition
It finalizes the project and converts it into a file format.
Term
an easy way to address an group of people using the same letter?
Definition
Mail merge in microsoft word
Term
The "Mosaic" was one of the first graphical web browsers, introduced in 1993, which created a colossal explosion in web use. A year later another browser became the world's most popular. Which browser was this?
Definition
Netscape
Term
What is a sub?
Definition
The short form of subroutine used to handle a certain task within a program.
Term
IP address stand for..
Definition
Internet protocol
Term
What is the difference between circuit switching and pack switching?
Definition
There is only one route a message can take in circuit switching whereas in packet switching, the parts of a message can take multiple routes to get the recipient where they are then assembled together.
Term
Operating systems.

Hint: a PC is not an Operating system.
Definition
Machintosh, Windows, Linux
Term
What is the file extension for excel documents?
Definition
.xlsx
Term
What is the difference between relative addressing and absolute addressing in Excel spreadsheets?
Definition
Relative addressing gets value relative to current cell's position; absolute addressing is a specific place.
Term
Which of the following are legitimate computer networks?
Definition
LANs, WANs, and the Internet
Term
The operating system (OS) is a type of system software that controls and coordinates computer hardware. Which describes the fuction(s) of operating systems?
Definition
they manage resources such as the CPU, disks, and memory (virtual memory), manage input and output devices, and make the computer a multifuctional tool (with multitasking, multithreading, and multiprocessing)
Term
What happens when you transfer a file from your computer to a removable drive?
Definition
Copies file into driver.
Term
Excel makes people's lives easier in each of the following ways except:
Definition
helping people get information from others.
Term
Why video editing?
Definition
B/c it is critical for the workforce and easy to post and send. It also makes it easy to communicate with mass audiences.
Term
What common code or programming language is standard for webpages?
Definition
HTML
Term
Which one is not included in collecting a/v footage?

Hint: screen capture, video, and audio are captured in A/v footage.
Definition
Excel is not captured in a/v footage.
Term
In HTML code, which of the following start tag/end tag combination is proper? (Written: start tag, end tag)
Definition
,
Term
How can Audio/video footage be collected?
Definition
throught screen capture, digital video, or audio
Term
What is VBE and what does it do?
Definition
Visual Basic Editor; program within Excel that allows you to communicate with Excel
Term
Which is not considered an operating system?

Hint: Android, Linus, Microsoft Windows - all are considered operating systems.
Definition
an Ipod
Term
".doc" and ".pptx" are example of what type of which of the following?
Definition
file extension
Term
What are some function of Operating Systems?
Definition
Handles Input and Output (I/O), Establishes User Interface, Manages Prgrams & Memory
Term
How many Rows and Columns can one Excel Worksheet be composed of?
Definition
65,536 Rows and 256 Columns
Term
Which of the following is not included in an IP packet?

Hint: source node address, destination node adress, and data are all included.
Definition
a token ring
Term
What type of software has no person or organization having propriety interests on it and is not a contain copyright or patent?
Definition
Public Domain Software
Term
What is software?
Definition
The applications needed to start, run and perform tasts on your computer
Term
What is an example of free video editing software?
Definition
iMovie
Term
Output device

Hint: a webcam is an input device
Definition
Printer speaker plotter
Term
What is considered the standard mark-up language for webpages?
Definition
HTML
Term
What is the purpose of the operating system (OS)?
Definition
It is essentially the brains of your computer. It deals with the software that is open and helps the motherboard map-out memory.
Term
Where in the CPU is data processed either by manipulating it or by acting upon it?

hint: this system has two parts
Definition
ALU
Term
The functions of an Operating System include?
Definition
Managing memory and establishing the user interface.
Term
In programming, what is the benefit of procedures (SUBS) and (FUNCTIONS)?
Definition
Once you have developed a program code with task components, you can use this code in another project.
Term
Which option is the correct use of "Cold Boot"?
Definition
CTRL + ALT +DEL
Term
commercial spreadsheet tool?
Definition
Microsoft Excel
Term
What are the three windows in the Visual Basic Editor?
Definition
The Project Window, the Code Window, and the Properties Window
Term
What is an example of hardware?
Definition
The keyboard.
Term
When dealing with Excel, what is true about a subroutine?

Hint: subroutines do not return values to the calling sub
Definition
It is used to split a task into individual procedure, and enhances readability and reduces error proneness.
Term
What is Cloud Computing?
Definition
Applications that are stored via difference sources on the web.
Term
What is a story board?
Definition
It is a graphic process to organize a project.
Supporting users have an ad free experience!