Term
|
Definition
| Distance between pixels on a computer monitor |
|
|
Term
|
Definition
| Access time from the CPU to RAM is measured in |
|
|
Term
|
Definition
|
|
Term
| # of users at the same time |
|
Definition
| Criteria by which computers are catagorized |
|
|
Term
|
Definition
| Not a WORD delection technique |
|
|
Term
|
Definition
|
|
Term
| A document should have no more than ___ fonts |
|
Definition
|
|
Term
|
Definition
| the extra space added to a line and should be 20% of its point size |
|
|
Term
|
Definition
| # of bits a CPU can work with at one time |
|
|
Term
| The size of registers does not determine _______________ |
|
Definition
|
|
Term
|
Definition
| the arrangement that makes up a slide layout |
|
|
Term
| To demote an item, press the ______ |
|
Definition
|
|
Term
| If you want to convert a formula contained in one cell to its value in a nother cell use ___________ |
|
Definition
|
|
Term
| In the PMT function, type 0 indicates to excel that the payment is an ________________________ |
|
Definition
| ordinary annuity, paid at the end |
|
|
Term
|
Definition
| =AND (c12="f", D2<45, E@="yes") |
|
|
Term
| If excel designates the rows as data series than columns_________ |
|
Definition
|
|
Term
| When Excel interprets data and assigns a series, the series name ______________ |
|
Definition
|
|
Term
| _____________ are created by default |
|
Definition
|
|
Term
| To restore a filtered data base, click ___________ |
|
Definition
|
|
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
|
Definition
| number of pixels displayed on the screen is called |
|
|
Term
|
Definition
| The grid like pattern created on the hard drive during formatting is composed of: |
|
|
Term
|
Definition
| -two separate CPU chips installed on the same system |
|
|
Term
|
Definition
| A set of wires or circuits that connects the CPU to other devices is called |
|
|
Term
|
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
|
|
Term
| A computer with a 32-bit word size can send ____bytes through the machine cycle at one time |
|
Definition
|
|
Term
|
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
|
|
Term
| .____ports connect special types of musical instruments to sound cards. |
|
Definition
|
|
Term
|
Definition
| A printers speed is measured in |
|
|
Term
| - is set by using the tab dialog box |
|
Definition
|
|
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
|
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
|
Definition
| the processing power of the CPU doubles every 18 months |
|
|
Term
|
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
|
|
Term
| 2nd generation computers are categorized by having |
|
Definition
|
|
Term
|
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
|
|
Term
|
Definition
| The difference between people with access to a computer with an internet connection and those without is called |
|
|
Term
|
Definition
| checks computers hardware against the CMOS chip |
|
|
Term
| An active matrix LCD monitor |
|
Definition
|
|
Term
|
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
|
|
Term
|
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
|
|
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
|
|
Term
| financial function finds the present value of a stream of unequal cash flows |
|
Definition
|
|
Term
| will allow you to scroll the worksheet below the freeze but not above |
|
Definition
|
|
Term
|
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
|
|
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
|
|
Term
|
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
|
|
Term
| The table design view is used to define |
|
Definition
| field names and data types |
|
|
Term
| Each is an access data type except |
|
Definition
|
|
Term
| query that uses another query |
|
Definition
|
|
Term
| Query has row for setting data as row headings, column headings or value called |
|
Definition
|
|
Term
| A multiple tab data base? |
|
Definition
|
|
Term
|
Definition
|
|
Term
| in the access function IIFF when you see <> |
|
Definition
| it represents the logical test |
|
|
Term
| Access PMT function <> represents |
|
Definition
|
|
Term
|
Definition
| A document that contains a list of the tables in a data base , including descriptions of the fields is called a |
|
|
Term
|
Definition
|
|
Term
| Before applying subtotals _________ |
|
Definition
|
|
Term
| When you change the data of a chart in excel the chart |
|
Definition
|
|
Term
| The default value field setting in a pivot table is |
|
Definition
|
|
Term
| When data is changed in an excel database, all pivot tables created using database will automatically update? |
|
Definition
|
|
Term
| Deleting records from a record set also deletes that record from its data source? |
|
Definition
|
|
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
|
|
Term
| you have saved an access table, it cant be edited |
|
Definition
|
|
Term
| Excel, a crossover filter allows you to set a greater than or equal to criteria |
|
Definition
|
|
Term
| When using the filter tool, you must highlight the first row containing the column headings for the drop down arrows to appear |
|
Definition
|
|
Term
| What happened to the missing rows? |
|
Definition
| Were AUTOMATICALLY hidden when the.... |
|
|
