Misc:Spreadsheet
Spreadsheet Basics
Cell Specifics
Business Uses of Spreadsheets
General Computer Review
100

Cell references that automatically change when copied are called this.


What is relative?


100
Cell
What is an individual location on a spreadsheet, (intersection of a row and a column)?
100
Cell Range
What is a group of adjacent cells, (group/block of cells). example: A6:E16 refers to a range of cells in a specific spreadsheet.
100
Payroll
What is it called when a company calculates the number of hours an employee works by the hourly payrate the employee earns and issues them a check in that amount?
100
Database
What is the name of the software that allows the user to Sort, and Filter information? The Internet is the largest in the world.
200

Cell references that stay the same when copied are called this.


What is absolute?


200
Column
What is identified by letters of the alphabet (vertical)? Refers to all of the contents in a vertical range of cells in a spreadsheet.
200
Cell Address
What refers to a specific location in a spreadsheet? It is the Column Letter and Row Number.
200
Financial Statement
What is a profit/loss statement for a business?
200
Desktop Publishing
What is the name of the software that enables the user to create brochures, flyers, and business cards?
300

This symbol has to be in front of every formula or function in order for it to calculate.

What is = equal sign?


300
Row
What is identified by numbers (horizontal), refers to all of the contents in a horizontal range of cells.
300
Cell Reference
What is another name for the cell address?
300

One of the main advantages of a spreadsheet is that they are good for answering this kind of question.


What is a What If Question?


300
Presentation Software
What is the type of software that allows the user to create PowerPoint Slideshows?
400

To tell the spreadsheet that a cell has an absolute value, you must type this symbol in front of the letter/number and behind the letter/number.


What is the $ dollar sign?


400
Spreadsheet
What is a worksheet which is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form?
400
Active Cell
What is the cell that is selected and ready to receive information in a spreadsheet?
400
Spreadsheet
What is the type of software that enables all businesses to calculate and report information in a numerical form?
400
Word Processing
What is the type of software that allows the user to create letters, memos, and reports?
500

When titles appear on two lines in the same cell above a column, it is the result of this command.


What is wrap text?


500

When the title of the entire spreadsheet crosses several cells, that is the result of this command.


What is merge text?


500

One of the main advantages of a spreadsheet is that they are good for answering this kind of question.


What is a What If? Question?


500
What are 5 reasons to use a spreadsheet?
Answers will vary
500
What are minutes and memos?
Answers will vary