Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CIS 105 > Final exam review > Flashcards

Final exam review Flashcards

1
Q

Know 4 functions of a computer

A

Input, Output, and Storage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Speaker

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Default

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Know the 2 Major Function of an operating system:

A

Memory & Device Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Know the difference between application & system software.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Application software includes all of the following except ______software.

A

System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Microprocessor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is our operating system?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Know the difference between bits & bytes.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Computers execute instructing using cod____

A

Binary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of the following represents a byte?

A

11001010

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Communication speed is measured in bps, which stands for:

A

Bits per second. Storage is in bytes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Temporary storage is:

A

ROM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When a program loads…

A

instructions are loaded from Disk to RAM memory

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Storing user data from memory to disk is called _______.

A

Saving

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

______ are rules that govern data communications

A

Protocols

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

RAM

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Peer to Peer LAN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

30 billion bytes is equal to ____GB.

A

30 GB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

The sender of the file uploads.

A

The receiver of the file downloads.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

Encrypted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

DELETE!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

Firewall

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

Protocol

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

important internet applications existed before the World Wide Web was invented

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

All of the following are broadband connections except:

A

Dial Up

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

Header

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

How do you deselect an image?

A

Click outside the image.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

Text box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

A

CTRL+Home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A

Tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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

A

Square

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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

A

Column

37
Q

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

A

Thesaurus

38
Q

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

A

Tab Stop

39
Q

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

A

Be of equal width

40
Q

Effects that include boarders, shadows, and reflection are:

A

Picture Styles

41
Q

The formatting mark that represents a tab is an:

A

Arrow

42
Q

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

A

CTRl+ Home

43
Q

To copy formatting from one paragraph to another, use ______

A

Format Painter

44
Q

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

A

Header or footer

45
Q

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.

A

Headings

46
Q

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

A

Ctrl: enter

47
Q

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

A

Delete

48
Q

A function is a

A

Prewritten formula in Excel

49
Q

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

A

Absolute cell reference

50
Q

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

A

MIN

51
Q

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

A

Explode

52
Q

All formulas begin with the ____ symbol.

A

=

53
Q

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

A

Fill Handle

54
Q

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

A

Word Art

55
Q

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

A

Arguments

56
Q

MIN and MAX are examples of functions.

A

Statistics

57
Q

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

A

IF

58
Q

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

A

Now function

59
Q

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

A

Text, Numbers, Formulas.

60
Q

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

A

The formula will automatically recalculates to reflect the changed data.

61
Q

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

A

Fill handle

62
Q

Dollar signs used in the cell reference is

A

Absolute

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

Pie chart

64
Q

Your progress in Micro type

A

Line chart
Pie chart
Bar chart

65
Q

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

A

=SUM(A4:A6)

66
Q

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

A

A formatted number is too wide

67
Q

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

A

Option tab and then use the “Refresh” command

68
Q

To create a pivot chart:

A

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

69
Q

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

A

range name.

70
Q

_____are a set of common characteristics for designing a table.

A

Fields

71
Q

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

A

Primary Key

72
Q

I Access, all data is stored in one or more

A

Tables

73
Q

An Access record is saved when you.

A

Move to the next record.

74
Q

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

A

Form

75
Q

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

A

Design grid

76
Q

A criteria that searches for fields that are empty is

A

Is Null

77
Q

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

A

Comparison operators

78
Q

In a query, you design in

A

design view

79
Q

The access view is

A

Layout

80
Q

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

A

It is never used again

81
Q

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

A

Filter

82
Q

A database object that summarized the field

A

Report.

83
Q

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

A

Salary

84
Q

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

A

Enforce record integrity

85
Q

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

A

Expression builder

86
Q

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

A

Macro

87
Q

Important about macros:

A

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.

88
Q

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

A

All of the above

89
Q

VBA editor

A

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

CIS 105 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions