Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
29 Cards in this Set
- Front
- Back
What is the:
-The software that manages the cpu -the core of the operating system - it directs other programs not in memory to perform task that support application programs |
-The Kernel
|
|
What is the components of the processor that directs and coordinates most operations in the computer?
|
The control unit
|
|
What is a series of cells in a rectangle
Its measured by top left corner: bottom right hand corner |
Range
|
|
what is the black box in the bottom right hand corner in a selected cell used to drag down cell info to multiple cells?
|
Fill Handler
|
|
what is the primary text code system most widely used & is stored as 1 byte or 8 BITS?
|
American Standard Code for Information Interchange
|
|
what is the smallest unit of data that a computer can process
-BIT is the acronym |
Binary Digit
|
|
Small, high-speed storage locations in a process that temporarily hold data and instructions.
|
Register
|
|
What is the main circuit board of the computer?
|
The Motherboard
|
|
what makes users more productive/ assist them with personal task?
|
Application Software
|
|
How to write out 1 character of data
|
1 BYTE [B]
|
|
How to write out 1million characters of data
|
1 MEGABYTE [MB]
|
|
what is a 16 bit coding scheme that has the capability of representing more than 65,000 characters and symbols?
|
Unicode
|
|
What is the area of memory that stores the contents of frequently used data or instructions?
|
Cache
|
|
What performs arithmetic comparisons and other operations?
|
The Arithmetic Logic Unit
(ALU) aka (The queen) |
|
________ allows various devices both inside and attached to the system to communicate with each other.
|
BUS
|
|
__________ is a type of interface that allows a user to interact with software using text, graphics, and visual images, such as icons.
|
Graphical User Interface (GUI)
|
|
________ is the number of bits that a processor can interpret and execute at a given time.
|
Word size
|
|
What do you call the intersection of a column and a row in a worksheet?
|
Cell
|
|
what counts the number of cells within a range that meet a given condition?
|
COUNTIF
|
|
What is the difference between alpha numeric and numeric data?
|
Numeric means Numbers
Alphabetic means Letters Alphanumeric is the combo of both |
|
Why is it better to use CELL Addresses in formulas as opposed to using hard-coded data?
|
because it means that if you change the value in a particular cell, the formula will automatically
|
|
what is the name of the function that i would use to perform a search in a vertical table?
|
VLookup
|
|
What is the format for the MID function? How is it used?
|
=MID(target cell, starting postition, #of characters to extract)
-used to remove such unwanted characters |
|
What does the pointer need to look like before i can "drag and drop" a range of cells or even just a cell?
|
FOUR HEADED ARROW
|
|
What does the pointer look like when positioned over the home ribbon and column header in EXCEL 2007?
|
home ribbon- white single headed arrow pointing in upward left direction
column header- black single headed downward pointing arrow |
|
what does the floating cursor need to look like before i can use the fill handle?
|
thin black cross
|
|
what is the difference between absolute cell referencing and relative cell referencing?
|
absolute- uses a constant in a formula when cell is fill handled downward
relative- adjusts formula relative to its new location when its fill handled downward |
|
Where is the quick access toolbar located?
|
in the top left corner next to the windows button it portrays icons
|
|
Using cell address in formulas is called?
|
Cell referencing
|