Shared Flashcard Set

Details

Management Information Systems Final
Karen Moore, Baylor
85
Computer Science
Undergraduate 1
05/06/2009

Additional Computer Science Flashcards

 


 

Cards

Term
Dot Pitch
Definition
Distance between pixels on a computer monitor
Term
Nano or Gigahertz
Definition
Access time from the CPU to RAM is measured in
Term
DRAM chips
Definition
Used as ordinary RAM
Term
# of users at the same time
Definition
Criteria by which computers are catagorized
Term
Alt-(Click word)
Definition
Not a WORD delection technique
Term
Times New Roman font
Definition
serif, porportional
Term
A document should have no more than ___ fonts
Definition
3
Term
Leading
Definition
the extra space added to a line and should be 20% of its point size
Term
Word size
Definition
# of bits a CPU can work with at one time
Term
The size of registers does not determine _______________
Definition
CPU Processing power
Term
Placeholders
Definition
the arrangement that makes up a slide layout
Term
To demote an item, press the ______
Definition
TAB key
Term
If you want to convert a formula contained in one cell to its value in a nother cell use ___________
Definition
paste special
Term
In the PMT function, type 0 indicates to excel that the payment is an ________________________
Definition
ordinary annuity, paid at the end
Term
AND function example
Definition
=AND (c12="f", D2<45, E@="yes")
Term
If excel designates the rows as data series than columns_________
Definition
contain categories
Term
When Excel interprets data and assigns a series, the series name ______________
Definition
becomes the legend
Term
_____________ are created by default
Definition
Grand Totals
Term
To restore a filtered data base, click ___________
Definition
the filter icon
Term
The total rows in the query design grids are added by ____________
Definition
clicking the total on the Query Design tag ribbon
Term
Which of the following statements are TRUE concerning virtual memory?
Definition
Virtual memory is the space on the hard drive where the operating system begins to store information when it becomes memory bound
Term
Resolution
Definition
number of pixels displayed on the screen is called
Term
tracks and sects
Definition
The grid like pattern created on the hard drive during formatting is composed of:
Term
dual processing
Definition
-two separate CPU chips installed on the same system
Term
a bus
Definition
A set of wires or circuits that connects the CPU to other devices is called
Term
parity
Definition
The extra bit appended to a byte to detect transmission error is known as a ____ bit.
Term
OCR and MICR are both examples of
Definition
source data automation
Term
A computer with a 32-bit word size can send ____bytes through the machine cycle at one time
Definition
4
Term
Application
Definition
Systems software is the set of programs that enables your computer's hardware and ____software to work together.
Term
The binary language consists of ___digits.
Definition
2
Term
.____ports connect special types of musical instruments to sound cards.
Definition
MIDI
Term
pages per min
Definition
A printers speed is measured in
Term
- is set by using the tab dialog box
Definition
a tab leader
Term
To move to a set tab in a Word table, you
Definition
Depress the Ctrl + Tab keys
Term
When you highlight a table in Word and press the delete key,
Definition
the contents of the table are deleted , but the table is not.
Term
To balance columns
Definition
you need to insert one continuous break
Term
An advantage of a CRT monitor over an LCD monitor is
Definition
images are viewable from more angles
Term
Moores Law
Definition
the processing power of the CPU doubles every 18 months
Term
Head Crash
Definition
the read/write head touches the metal surface of the hard disk platter
Term
Which one of the following is the address book created when you format a magnetic disk
Definition
FAT or NTFS
Term
2nd generation computers are categorized by having
Definition
transistors
Term
ASCII
Definition
___is most used for coding a word or scheme and is used by personal computers
Term
an _____ mouse is more expensive than an ____________ mouse
Definition
optical, mechanical
Term
Digital Divide
Definition
The difference between people with access to a computer with an internet connection and those without is called
Term
the POST
Definition
checks computers hardware against the CMOS chip
Term
An active matrix LCD monitor
Definition
charges pixels as needed
Term
advantages of XML
Definition
sharing data across systems
-reduced file size
-reduced chance of file corruption
Term
When you have an object selected in WORD
Definition
a contextual tab will appear with tools to manipulate the selected object
Term
Which of the following modifier keys places a shortcut letter or number by a c....
Definition
ALT
Term
Absolute Cell Refrences
Definition
are often necessary when a formula needs to be copied to another cell
-forces the cell reference to remain the same even if the formula is filled down or right
AND -are created by adding $ in front of the letter and number of the cell reference
Term
Which time and date function returns both the current day and the current time
Definition
=NOW
Term
The first step if you want to protect your worksheet but leave some cells changeable is to
Definition
Unlock the cells that will change
Term
The GOAL SEEK command will...
Definition
- Run iterations that let you set one cell's value to a spe..?
Term
Which function do you use to count non-numeric values
Definition
COUNTA
Term
financial function finds the present value of a stream of unequal cash flows
Definition
NPV
Term
will allow you to scroll the worksheet below the freeze but not above
Definition
Freezing Panes
Term
accelerated depreciation
Definition
Both sum of year's digits and double-declining balance methods
Term
A slice of pie, the top of a column, and a symbol on a line chart are all
Definition
Data Markers
Term
#####
Definition
Value is too large for the cell
Term
Worksheet text label will, by default
Definition
-display more characters than will fit across the width of one cell as long as its empty
-Be left aligned
Term
defined in class, what is the definition of Interest?
Definition
Cost of borrowing money
Term
F4
Definition
What is the key you press to make a cell address absolute without using the Shift Key and typing in a symbol?
Term
What is true about a pivot table
Definition
You can find averages and sums using a pivot table
Term
In an access table each column contains a category called _____
Definition
a field
Term
The table design view is used to define
Definition
field names and data types
Term
Each is an access data type except
Definition
data
Term
query that uses another query
Definition
nested query
Term
Query has row for setting data as row headings, column headings or value called
Definition
cross-tab query
Term
A multiple tab data base?
Definition
A foreign key
Term
When you see <>
Definition
delete it
Term
in the access function IIFF when you see <>
Definition
it represents the logical test
Term
Access PMT function <> represents
Definition
type of payment
Term
Data Dictionary
Definition
A document that contains a list of the tables in a data base , including descriptions of the fields is called a
Term
Data reviewed by a query
Definition
record set
Term
Before applying subtotals _________
Definition
sort the data
Term
When you change the data of a chart in excel the chart
Definition
automatically changes
Term
The default value field setting in a pivot table is
Definition
SUM
Term
When data is changed in an excel database, all pivot tables created using database will automatically update?
Definition
false
Term
Deleting records from a record set also deletes that record from its data source?
Definition
true
Term
What is the database hierarchy
Definition
field, record, file, database
Term
when adding the value fields to a pivot table, you should drag and drop the first value to the data field, but drop the rest in the value and row fields?
Definition
false
Term
you have saved an access table, it cant be edited
Definition
false
Term
Excel, a crossover filter allows you to set a greater than or equal to criteria
Definition
true
Term
When using the filter tool, you must highlight the first row containing the column headings for the drop down arrows to appear
Definition
false
Term
What happened to the missing rows?
Definition
Were AUTOMATICALLY hidden when the....
Supporting users have an ad free experience!