Social Media
Functions and Data Organization
Creating Charts
Advanced Spreadsheet Techniques
Using a Relational Database
100
These internet sites are usually maintained by an individual with regular entries of commentary, descriptions of events, or other material such as graphics or video.
What is a Blog?
100
This performs a calculation that results in a single value.
What is a function?
100
This is a visual representration of worksheet data.
What is a Chart?
100
This is a column in a worksheet.
What is a field?
100
This is an organized collection of related data.
What is a database?
200
This is a collaborative website that allows for the creation and editing of many interlinked webpages.
What is is a Wiki?
200
This is a way of arranging data values, either from Low to High, or High to Low.
What is ascending and descending order?
200
These are also refered to as the value axis and the category axis, or the horizontal and vertical axis.
What is the x-axis and y-axis?
200
This is pasted data that is not connected to the source file or to the source application.
What is Static?
200
This is used to make one field in each record unique.
What is a Primary Key?
300
If this website was a country, it would be the 4th largest in the world.
What is Facebook?
300
These cells contain a reference to the original data and will automatically update if the source data changes.
What are linked cells?
300
This is the technical term for a chart that's embedded in the worksheet.
What is a static chart?
300
Tjis is a series of recorded commands and actions that perform a specific task
What is a Macro?
300
This defines the data within a field.
What is an entry?
400
Businesses use this term to refer to social media. It's acronym is CGM.
What is Consumer-Generated Media?
400
This is a worksheet that includes related data and formulas for analyzing data.
What is a spreadsheet model?
400
This is the part of the chart that displays the data.
What is the plot area?
400
This is a function that is used to return a value from a table of values stored in the worksheet.
What is VLOOKUP?
400
This data is imported and then added to an existing table, or used to create a completely new table.
What is appended data?
500
This website was launched on January 15th, 2001 by Jimmy Wales and Larry Sanger.
What is Wikipedia?
500
These are used to compare two values. Operators include =, <, >, <=, >=, <>.
What are Relational Operators?
500
These are the four common types of chart.
What is a column chart, bar chart, line chart, and pie chart?
500
This is a sungle formula entered in a table cell and then automatically copied t oall of the other table cells in the column.
What is a Calculated Column?
500
These are two different ways to manage data in Access. Placing records in a specified order, and displaying records based on specific criteria.
What is Sorting and Filtering?