10 Extra Credit Points
What is "privacy"?
Information shared with visiting web pages, how the information is used, who the information is shared with, or if the information is used to track others.
What are the requirements of public domain works?
Public domain status allows the user unrestricted access and unlimited creativity! There are three main categories of public domain works: Works that automatically enter the public domain upon creation, because they are not copyrightable: Titles, names, short phrases and slogans, familiar symbols, numbers.
How do I modify the date value when formatting a cell?
Define Access and Oracle.
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.
What is the difference between accessibility and usability in a web page?
Web accessibility means that everyone can equally perceive, understand, navigate, and interact with websites and tools.
Usability: is about designing products to be effective, efficient, and satisfying. Usability includes user experience design.
What are digital footprints?
A trial of data you create while using the internet.
How does the AutoSum command calculate data?
Go to the cell where you want the total value to appear. Type =sum(number1:number2) then press the enter key. Then on the Home Tab select AutoSum.
In Excel, if ##### is displayed, how would I adjust the column?
Change the column width.
Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
In the Column width box, type the value that you want. Click OK.
How do you apply graphics to a webpage?
Embedding Images into a Web Page. Once you've created your image, saved it as either GIF, PNG or JPEG format, then uploaded it to a web server, you can embed it into a web page. Embedding an image into a web page is done using HTML. HTML has a special tag for this - the <img> tag.
How do I sort records in a database?
What is copyright infringement?
A violation of an individual or organization's copyright. The unauthorized use of copyrighted material, such as text, photos, videos, music, software, and other original content.
How do you enter a MAX function into a spreadsheet?
Select a blank cell to apply the max function beyond the range that you want to search for the max data. 1. Then click Formula > Autosum > Max, and then select the range you want to find the max data.
How would you merge and center cells?
In Excel, how would you select multiple cells?
To select non sequential cells, click the first cell, hold down the Ctrl key, and click each additional cell (or row or column) you want to select.
How would you copy and paste information from one cell to another?
What are adjacent cells?
A contiguous range of cells in a group of highlighted cells that are right next to each other.
What is the formula for an absolute reference?
An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference.
What is the function of a filter tool?
Use this tool to identify records in your data that meet a specified criteria.
How do you delete a column?
In Excel spreadsheet, what is the purpose of a table?
Microsoft Excel can be used to analyze vast amounts of data, and one of the best features in Excel for this purpose is changing your data range to a table. With tables, you can quickly sort and filter your data, add new records, and see your charts and PivotTables update automatically.
Name two things that ARE appropriate to post online?
Name two things that AREN'T appropriate to post online?
Appropriate:
1) Favorite color, Artist, or book.
2) Favorite TV Show, Park or School.
Inappropriate:
1) Current Location
2) Family or personal information.
In database, what is SQL ?
SQL (pronounced "ess-que-el") stands for Structured Query Language. ... SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.
What is the purpose of a primary key?
The main purpose of a primary key is to implement a relationship between two tables in a relational database.
How do you adjust a column?
Where would you go to sort data alphabetically in a spreadsheet?