Final exam review Flashcards
Know 4 functions of a computer
Input, Output, and Storage.
Which of the following is an example of an output device?
Speaker
What is the assumption made by the system when the user has indicated no specific choice?
Default
Know the 2 Major Function of an operating system:
Memory & Device Management
Know the difference between application & system software.
Application: programs that sit on top of an operating system that direct the computer’s hardware to perform a task for the user. Ex: games
System: Provide basic services, infrastructure and hardware control.
Application software includes all of the following except ______software.
System
The CPU- Brains of the computer. Performs arithmetic & logic operations, executes programs & also called
Microprocessor
What is our operating system?
Windows 7. Window 7 uses a graphical user interface (GUI) that uses windows, icons, menus, and pointing devices.
Know the difference between bits & bytes.
Bit: short for binary digit. Either 0 or 1. Smallest unit of data a computer can store and understand.
Byte: group of 8 bits that represent a single character such as
Computers execute instructing using cod____
Binary
Which of the following represents a byte?
11001010
Communication speed is measured in bps, which stands for:
Bits per second. Storage is in bytes.
Even when the computer is off, instructs are stored in ____
Even when the computer is off, instructs are stored in ____
Temporary storage is:
ROM
When a program loads…
instructions are loaded from Disk to RAM memory
Storing user data from memory to disk is called _______.
Saving
______ are rules that govern data communications
Protocols
When electrical power is cut off, information stored in ____ is lost.
RAM
In C-S network, the server is used to share files and software – typically a high powered computer.
Network administration is centralized.
Each client on the network is referred to as a node.
Which network architecture do you think is used in most home networks?
Peer to Peer LAN
30 billion bytes is equal to ____GB.
30 GB
A computer’s microprocessor speed is determined by the attached input & output devices.
False: It is determined byte the speed of the internet.
The sender of the file uploads.
The receiver of the file downloads.
What does it mean you see https:// in a web page address?
Encrypted
Viruses: They are written (programmed) by a person
Attach themselves to executable files
Affect the system when the attachment is executed.
DELETE!
The purpose of the ____ is to foil spyware and hacker intruders.
Firewall
In the web address HTTP: //www.susd.org, the portion labeled HTTP is the?
Protocol
important internet applications existed before the World Wide Web was invented
true
All of the following are broadband connections except:
Dial Up
A reserved area for text & graphics that displays at the top of each page in a document is the
Header
How do you deselect an image?
Click outside the image.
Which of the following is a small movable container for text or graphics?
Text box
Which keyboard shortcut is used to move to the top of a document?
CTRL+Home
Which key is used to move from cell to cell in a word table?
Tab
Which text wrapping style allows you to place an image anywhere on the document page?
Square
Which type of break will force text to appear at the top of a column?
Column
When looking for another word that means the same as “smart”, you could use the?
Thesaurus
A ___ is a specific location on the ruler to which you can move using the TAB key.
Tab Stop
When creating a table with four columns, the size of each column will.
Be of equal width
Effects that include boarders, shadows, and reflection are:
Picture Styles
The formatting mark that represents a tab is an:
Arrow
What keystrokes would you use to get from page 6 of a document to the top of a document?
CTRl+ Home
To copy formatting from one paragraph to another, use ______
Format Painter
To display repetitive information at the top or bottom of every page, use
Header or footer
MS Word will automatically create a Table of Contents for you by listing the _____ in the order they appear in a document and the page number where the entries begin.
Headings
Manual page breaks are created by holding down the ____ key and pressing____.
Ctrl: enter
To delete a word from a line of text, position the insertion point anywhere in the word, double click on the word, and press______.
Delete
A function is a
Prewritten formula in Excel
A___ refers to a cell by its fixed position in the worksheet.
Absolute cell reference
Which function determines the smallest value in a selected range of values?
MIN
To ____ one or more slices on a pie chart means to pull the slices away from the rest of the chart.
Explode
All formulas begin with the ____ symbol.
=
What is the name of the toll that allows you to quickly copy formulas & functions relative to their starting location?
Fill Handle
A gallery of text styles that can be used to apply decorative effect to text is
Word Art
The values that an excel function uses to perform operations are called.
Arguments
MIN and MAX are examples of functions.
Statistics
The ___ function returns one value if a conduction is met and a different value if it is not.
IF
The ____ function retrieves the date and time from your computer’s calendar and clock and inserts the information into the selected cell.
Now function
Three kinds of information can be put into a spreadsheet. They are.
Text, Numbers, Formulas.
What happens when you change the data in a cell with a formula?
The formula will automatically recalculates to reflect the changed data.
If cell A1 contains the text “Jan”, use the ____ to auto fill cell B1, C1, and D1 to contain Feb, Mar, Apr,
Fill handle
Dollar signs used in the cell reference is
Absolute
What type of chart is best used to express the following information: # of students at SCC as percentage
Pie chart
Your progress in Micro type
Line chart
Pie chart
Bar chart
The Best formula for calculating the sum of the range A4through A6 would be:
=SUM(A4:A6)
When you see the following in a spreadsheet, what does it mean? #####
A formatted number is too wide
To update the pivot table with changes, click the PivotTable Tools
Option tab and then use the “Refresh” command
To create a pivot chart:
Click anywhere in the Pivot table and select the Pivot Chart option
To make it easier to refer to total specific block of cells in a formula, function, data table, etc, use a
range name.
_____are a set of common characteristics for designing a table.
Fields
An ____ is a field that uniquely identifies each record in a table.
Primary Key
I Access, all data is stored in one or more
Tables
An Access record is saved when you.
Move to the next record.
The primary purpose of the ____ object is to create a user friendly interface for entering, editing
Form
The lower area of the query window that displays the design of the query is the
Design grid
A criteria that searches for fields that are empty is
Is Null
The symbols of =, >, and < are known as:
Comparison operators
In a query, you design in
design view
The access view is
Layout
If a record is deleted, what happens to the primary key assigned to that record?
It is never used again
The process of displaying only a portion of the total records (a subset) based on matching a specific value.
Filter
A database object that summarized the field
Report.
In an Access database, which of the following fields would be a numeric key?
Salary
In the relationship between the Account Table & the Customer Table what would prevents you from adding a record
Enforce record integrity
TO create a calculated field in Access, use the _____.
Expression builder
Which object adds functionality to a database and is written using VBA?
Macro
Important about macros:
A macro used only with table events is a data macro.
An embedded macro belongs to a single object or a control.
A stand-alone macro appears in the navigation pane.
In the VB editor, you can do all of the following:
All of the above
VBA editor
Create code statements for programming a database, modify code statements, test and debug a procedure.
