Final exam review

Question 1

Know 4 functions of a computer

Answer 1

Input, Output, and Storage.

Question 2

Which of the following is an example of an output device?

Answer 2

Speaker

Question 3

What is the assumption made by the system when the user has indicated no specific choice?

Answer 3

Default

Question 4

Know the 2 Major Function of an operating system:

Answer 4

Memory & Device Management

Question 5

Know the difference between application & system software.

Answer 5

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.

Question 6

Application software includes all of the following except ______software.

Answer 6

System

Question 7

The CPU- Brains of the computer. Performs arithmetic & logic operations, executes programs & also called

Answer 7

Microprocessor

Question 8

What is our operating system?

Answer 8

Windows 7. Window 7 uses a graphical user interface (GUI) that uses windows, icons, menus, and pointing devices.

Question 9

Know the difference between bits & bytes.

Answer 9

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

Question 10

Computers execute instructing using cod____

Answer 10

Binary

Question 11

Which of the following represents a byte?

Answer 11

11001010

Question 12

Communication speed is measured in bps, which stands for:

Answer 12

Bits per second. Storage is in bytes.

Question 13

Even when the computer is off, instructs are stored in ____

Answer 13

Even when the computer is off, instructs are stored in ____

Question 14

Temporary storage is:

Answer 14

ROM

Question 15

When a program loads…

Answer 15

instructions are loaded from Disk to RAM memory

Question 16

Storing user data from memory to disk is called _______.

Answer 16

Saving

Question 17

______ are rules that govern data communications

Answer 17

Protocols

Question 18

When electrical power is cut off, information stored in ____ is lost.

Answer 18

RAM

Question 19

In C-S network, the server is used to share files and software – typically a high powered computer.
Network administration is centralized.

Answer 19

Each client on the network is referred to as a node.

Question 20

Which network architecture do you think is used in most home networks?

Answer 20

Peer to Peer LAN

Question 21

30 billion bytes is equal to ____GB.

Answer 21

30 GB

Question 22

A computer’s microprocessor speed is determined by the attached input & output devices.

Answer 22

False: It is determined byte the speed of the internet.

Question 23

The sender of the file uploads.

Answer 23

The receiver of the file downloads.

Question 24

What does it mean you see https:// in a web page address?

Answer 24

Encrypted

Question 25

Viruses: They are written (programmed) by a person Attach themselves to executable files Affect the system when the attachment is executed.

Answer 25

DELETE!

Question 26

The purpose of the ____ is to foil spyware and hacker intruders.

Answer 26

Firewall

Question 27

In the web address HTTP: //www.susd.org, the portion labeled HTTP is the?

Answer 27

Protocol

Question 28

important internet applications existed before the World Wide Web was invented

Answer 28

true

Question 29

All of the following are broadband connections except:

Answer 29

Dial Up

Question 30

A reserved area for text & graphics that displays at the top of each page in a document is the

Answer 30

Header

Question 31

How do you deselect an image?

Answer 31

Click outside the image.

Question 32

Which of the following is a small movable container for text or graphics?

Answer 32

Text box

Question 33

Which keyboard shortcut is used to move to the top of a document?

Answer 33

CTRL+Home

Question 34

Which key is used to move from cell to cell in a word table?

Answer 34

Tab

Question 35

Which text wrapping style allows you to place an image anywhere on the document page?

Answer 35

Square

Question 36

Which type of break will force text to appear at the top of a column?

Answer 36

Column

Question 37

When looking for another word that means the same as “smart”, you could use the?

Answer 37

Thesaurus

Question 38

A ___ is a specific location on the ruler to which you can move using the TAB key.

Answer 38

Tab Stop

Question 39

When creating a table with four columns, the size of each column will.

Answer 39

Be of equal width

Question 40

Effects that include boarders, shadows, and reflection are:

Answer 40

Picture Styles

Question 41

The formatting mark that represents a tab is an:

Answer 41

Arrow

Question 42

What keystrokes would you use to get from page 6 of a document to the top of a document?

Answer 42

CTRl+ Home

Question 43

To copy formatting from one paragraph to another, use ______

Answer 43

Format Painter

Question 44

To display repetitive information at the top or bottom of every page, use

Answer 44

Header or footer

Question 45

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.

Answer 45

Headings

Question 46

Manual page breaks are created by holding down the ____ key and pressing____.

Answer 46

Ctrl: enter

Question 47

To delete a word from a line of text, position the insertion point anywhere in the word, double click on the word, and press______.

Answer 47

Delete

Question 48

A function is a

Answer 48

Prewritten formula in Excel

Question 49

A___ refers to a cell by its fixed position in the worksheet.

Answer 49

Absolute cell reference

Question 50

Which function determines the smallest value in a selected range of values?

Answer 50

MIN

Question 51

To ____ one or more slices on a pie chart means to pull the slices away from the rest of the chart.

Answer 51

Explode

Question 52

All formulas begin with the ____ symbol.

Answer 52

=

Question 53

What is the name of the toll that allows you to quickly copy formulas & functions relative to their starting location?

Answer 53

Fill Handle

Question 54

A gallery of text styles that can be used to apply decorative effect to text is

Answer 54

Word Art

Question 55

The values that an excel function uses to perform operations are called.

Answer 55

Arguments

Question 56

MIN and MAX are examples of functions.

Answer 56

Statistics

Question 57

The ___ function returns one value if a conduction is met and a different value if it is not.

Answer 57

IF

Question 58

The ____ function retrieves the date and time from your computer’s calendar and clock and inserts the information into the selected cell.

Answer 58

Now function

Question 59

Three kinds of information can be put into a spreadsheet. They are.

Answer 59

Text, Numbers, Formulas.

Question 60

What happens when you change the data in a cell with a formula?

Answer 60

The formula will automatically recalculates to reflect the changed data.

Question 61

If cell A1 contains the text “Jan”, use the ____ to auto fill cell B1, C1, and D1 to contain Feb, Mar, Apr,

Answer 61

Fill handle

Question 62

Dollar signs used in the cell reference is

Answer 62

Absolute

Question 63

``` What type of chart is best used to express the following information: # of students at SCC as percentage ```

Answer 63

Pie chart

Question 64

Your progress in Micro type

Answer 64

Line chart Pie chart Bar chart

Question 65

The Best formula for calculating the sum of the range A4through A6 would be:

Answer 65

=SUM(A4:A6)

Question 66

When you see the following in a spreadsheet, what does it mean? #####

Answer 66

A formatted number is too wide

Question 67

To update the pivot table with changes, click the PivotTable Tools

Answer 67

Option tab and then use the “Refresh” command

Question 68

To create a pivot chart:

Answer 68

Click anywhere in the Pivot table and select the Pivot Chart option

Question 69

To make it easier to refer to total specific block of cells in a formula, function, data table, etc, use a

Answer 69

range name.

Question 70

_____are a set of common characteristics for designing a table.

Answer 70

Fields

Question 71

An ____ is a field that uniquely identifies each record in a table.

Answer 71

Primary Key

Question 72

I Access, all data is stored in one or more

Answer 72

Tables

Question 73

An Access record is saved when you.

Answer 73

Move to the next record.

Question 74

The primary purpose of the ____ object is to create a user friendly interface for entering, editing

Answer 74

Form

Question 75

The lower area of the query window that displays the design of the query is the

Answer 75

Design grid

Question 76

A criteria that searches for fields that are empty is

Answer 76

Is Null

Question 77

The symbols of =, >, and < are known as:

Answer 77

Comparison operators

Question 78

In a query, you design in

Answer 78

design view

Question 79

The access view is

Answer 79

Layout

Question 80

If a record is deleted, what happens to the primary key assigned to that record?

Answer 80

It is never used again

Question 81

The process of displaying only a portion of the total records (a subset) based on matching a specific value.

Answer 81

Filter

Question 82

A database object that summarized the field

Answer 82

Report.

Question 83

In an Access database, which of the following fields would be a numeric key?

Answer 83

Salary

Question 84

In the relationship between the Account Table & the Customer Table what would prevents you from adding a record

Answer 84

Enforce record integrity

Question 85

TO create a calculated field in Access, use the _____.

Answer 85

Expression builder

Question 86

Which object adds functionality to a database and is written using VBA?

Answer 86

Macro

Question 87

Important about macros:

Answer 87

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.

Question 88

In the VB editor, you can do all of the following:

Answer 88

All of the above

Question 89

VBA editor

Answer 89

Create code statements for programming a database, modify code statements, test and debug a procedure.