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;
113 Cards in this Set
- Front
- Back
facts and figures
|
data
|
|
an organized collection of facts and figures
|
database
|
|
created to store and organize data
|
table
|
|
used to find data to answer questions
|
queries
|
|
used to enter and view data
|
forms
|
|
used to display data in an easy to read format
|
reports
|
|
contains all the information about a person or item
|
record
|
|
one single piece of information about a person or item
|
field
|
|
a field chosen to identify each record in a table
|
primary key
|
|
allows you to enter data into a table
|
datasheet view
|
|
allows you to create and format a table or report
|
design view
|
|
determines the kind of data a field can hold
|
data type
|
|
allows you to arrange the information in a table or query in a certain order
|
sort
|
|
hides records in a table that do not match your criteria
|
filter
|
|
orders the data from
0-100 or A-Z |
ascending
|
|
orders the data from
100-0 or Z-A |
descending
|
|
a computer program used to record, report, and analyze data in worksheets
|
spreadsheet software
|
|
a type of spreadsheet software that contains data
|
microsoft excel
|
|
a spreadsheet file
|
worksheet
|
|
one section in a spreadsheet file
|
workbook
|
|
where a column and row intersects
|
cell
|
|
displays the application and current worksheet name
|
title bar
|
|
contains the drop down menu items
|
menu bar
|
|
identifies the active cell by the letter of the column and the number of the row that it intersects it also identifies the range of cells that are selected
|
cell reference box
|
|
displays the contents of the active cell and is used to create or edit text or values
|
formula bar
|
|
used to move horizontally or veritcally within a worksheet
|
scroll bars
|
|
highlighted with a thick border
|
active cell
|
|
identify the worksheet in a workbook
|
worksheet tabs
|
|
identifies excels current state and monitors what happens in a cell
|
status bar
|
|
a group of 2 or more cells in a worksheet
|
cell range
|
|
equations that perform calculations on values in a worksheet
|
formula
|
|
anything that is just text
|
label
|
|
any number
|
value
|
|
merges together two or more cells in a table or worksheet
|
merge cells
|
|
a predefined formula that can be used to perform calculations
|
function
|
|
the cell range used with the function
|
argument
|
|
the cross hairs that intersect and form cells
|
gridlines
|
|
What are the benefits of a Database?
|
1. easy to sort and organize large collections of information
2. analyze and group information 3. find specific information 4. look at patterns between information 5. you can use it in mail and reports |
|
List 2 examples of a hard copy Database.
List 2 examples of an electronic copy Database. |
Hard copy: phone books and
card catalogs Online copy: police records and powerschool |
|
Places you have used a Database?
|
internet
powerschool walmart checkout phone books student directory your phones contact list |
|
Databases are made up of ____.
|
files
records fields |
|
List and Describe the 7 data types.
|
1. text - text or #s
2. Memo - notes, descriptions, or summaries 3. Number - #s that you will calculate 4. Date/Time - for date and time ONLY 5. Currency - for money ONLY 6. Auto Number - #s assigned by MS Access 7. Yes/No - for data that can only be yes or no |
|
What are the 4 objects in MS Access?
|
Tables
Queries Forms Reports |
|
a feature that creates a form based on an open table and includes all the fields from the table
|
AutoForm
|
|
transfers numbers in to money format
|
currency style button
|
|
transfers numbers in to 100ths format
|
percent syle button
|
|
List some functions provided by MS Excel.
|
total
average min max |
|
How do you format the text in a worksheet?
|
Title = 14 pt font, bold,
merge center Labels = 12 pt font, bold, center Body = 10 pt font |
|
a side panel that opens up to give more detail
|
task pane
|
|
the small box in the bottom corner of the active cell
|
fill handle
|
|
Numbers can be ____, ____, ____, ____.
|
multiplied
divided added subtracted |
|
A _______ can be constructed to present a worksheet information graphically.
|
chart
|
|
When a number is changes, all related "answers" are _____ changed.
|
automatically
|
|
run vertically in a worksheet and are identified by a letter
|
columns
|
|
run horrizontally in a worksheet and are identified by a number
|
rows
|
|
Cells can be activated by ____, ____, and/or ____.
|
mouse
tab arrow keys |
|
Strike _______ to activate cell A1 from anywhere in the worksheet.
|
CTRL + HOME
|
|
What is the highest number of rows available on Excel worksheet?
|
65536
|
|
True or False;
Values are automatically right aligned. |
True
|
|
True or False;
Labels are automatically left aligned. |
True
|
|
Name the 3 main types of charts.
|
bar
column pie |
|
What kind of chart is displayed in vertical rectangles?
|
column chart
|
|
What kind of chart is displayed in horizantal rectangles?
|
bar chart
|
|
What kind of chart shows triangles out of a whole circle?
|
pie chart
|
|
Which two charts compare values across categories of data?
|
Bar and Column
|
|
Which chart shows how much each value is of a total value?
|
Pie
|
|
a chart placed on the same worksheet as the data used to create the chart
|
embedded chart
|
|
List the parts of a column and bar chart.
|
chart title
x-axis (category axis) y-axis (value axis) data points data labels gridline legend |
|
headings that identify chart contents
|
chart title
|
|
lines through a chart that identify points on the axes
|
gridline
|
|
a key used to identify the chart's data categories
|
legend
|
|
axis that is only used in pie charts
|
z-axis
|
|
the
"http://" |
protocol
|
|
anything between
"http://" and the second "/" |
domain name
|
|
anything between the
second "/" and the third "/" |
path name
|
|
anything between
the third "/" and the final "." whatever |
file name
|
|
The starting point of a website is a _____.
|
home page
|
|
text on a web page that is blue and often underlined which links you to other places on the internet whey you click on them
|
hypertext
|
|
Certain graphics, called _______, also used to access other resources by clicking them.
|
hyperlinks
|
|
The cursor from an arrow to a _______ when hovering over hypertext or hyperlinks.
|
pointing hand
|
|
To go online your computer must be equipped with a ________.
|
modem
|
|
a device that translates the digital signals form your computer into analog signals so that can travle over a standard phone line
|
modem
|
|
Modems come in different ____.
|
speeds
|
|
Modem speeds are measured in _______ (bps).
|
bits per second
|
|
If you need to purchase a modem buy an _____ one.
|
external
|
|
The standard connector on a telephone cable is called an _____.
|
RJ-11
|
|
With broadband, the _________ speed is faster than the ________ speed.
|
download
upload |
|
Why should you avoid using all caps online?
|
It looks like your shouting and it is difficult to read.
|
|
True or False;
Emoticons are figures you create using the characters on your keyboard. |
False;
Emoticons are "expressions" you create ....... keyboard. |
|
What is a URL?
|
a series of numbers that are unique to a specific web page
|
|
Your web browser is the _________ to the Internet.
|
gateway
|
|
VOIP
|
voice over internet protocol
allows you to make phone calls over the internet |
|
DSL
|
digital subscriber line
a type of internet connection |
|
Think about and formulate your answer to this Exam Question.
(it will be worth many points) What is the Internet, Anyway? |
i cant tell you my answer figure it out yourself :P
|
|
a software program that helps you find webpages containing certain information
|
search tool
|
|
Search tools fall into ____ general categories.
|
3
|
|
What are the 3 types of search tools?
|
subject directory
search engine keyword system |
|
the search tool that is good at identifying general info
|
subject directory
|
|
What is the most popular subject directory?
|
Yahoo!
(created by 2 stanford graduates) |
|
the search tool that uses queries
|
search engine
|
|
What is the most popular type of search engine?
|
google
|
|
the search tool that uses search terms
|
keyword system
|
|
What is the most popular type of keyword system?
|
google advanced system
|
|
the English mathmatician, George Boole, developed an algebra of logic that has become the basis of computer database searches called ....
|
Boolean Logic
|
|
What are the 3 operators that the Boolean logic use?
|
AND
OR NOT |
|
the hypertext list of websites returned from a web query
|
hits
|
|
automated programs that scour the Internet, analyzing billions of web pages, group and blog postings and idexing all of the words
|
spider
|
|
Tables store ___ and are made up of ____.
|
data ; records
|
|
______ can include all or selected fields in tables.
|
queries
|
|
______ can also sort data.
|
queries
|
|
hides records in a table that do not meet the given criteria
|
filter
|
|
____ can be turned off and all records will be displayed. Turn it on and they are hidden.
|
filter
|
|
In a _____ data can be grouped, sorted, and formatted in various styles.
|
report
|