Java Games: Flashcards, matching, concentration, and word search.

Excel Study Guide 2

AB
It is always best to buy the most powerful computer availableFalse
Smart shoppers ask plenty of questions before they buy a computer.True
When you buy a new computer, you may wish to purchase additional software programs that are not included with the basic software package.True
Generally, the better the hardware components the more expensive the computer.True
The best deal on a computer is always the lowest price.False
In a network, computers are all connected to the same system.True
Networks can only be used for large organizations.False
An Excel worksheet is made up tabs and boxes.False
The Excel file that contains multiple worksheets is called a workbook.True
Spreadsheet software lets you create spreadsheets, or worksheets, to compare and contrast data and perform various calculations on the data.True
In each cell of a worksheet you can enter rows and columns.False
You may enter, replace, edit, and copy data into a cell.True
Excel can automatically change the height and width of columns and rows using the AutoFit feature.True
The lines on an Excel worksheet are called the columns and rows.False
A built-in formula in Excel is called a functionTrue
A basic computer system usually includes a ____.computer, monitor, keyboard and mouse
A(n) ____ is the computer manufacturer’s promise to pay for specific repairs for a certain length of time.warranty
____ refers to how fast a computer works.Performance
How much RAM is usually needed to run complex programs such as video games and graphic programs?2 GB
How much hard disk space is usually needed to store and create movies?200 GB
What is the average speed of a conventional modem?56k
A ____ lets computers “talk” to each other.network
____ is a spreadsheet program.Microsoft Excel
Spreadsheet software ____.lets you compare and contrast information
A worksheet is a table that is organized into ____.rows and columns
The column letter and row number of a cell, such as A1, is called a ____.cell address
When you open a worksheet, the cell in the ____ is usually selected automatically.top left corner
The box that indicates which cell in a worksheet is selected is called a ____.cell pointer
In a well organized worksheet, every column should have a label, or ____, at the top to identify it.header
Header rows are found at the ____ of a worksheet.top
A(n) _____________________ is each piece of hardware that is part of a computer system.component
The _____________________ of a computer is how long a computer can be used before it becomes outdated.useful life
A(n) _____________________ is usually a monthly charge you will have to pay if you want to use the Internet and e-mail.Internet service fee
The key to good computer performance is _____________________.good hardware
Buying a computer online may be more expensive due to _____________________ charges.shipping and handling
Setting up a network can be a way to _____________________ money, especially for large organizations.save
The most popular spreadsheet software is _____________________.Microsoft Excel
A(n) _____________________ is a horizontal line of cells.row
A(n) _____________________ is a vertical line of cells.column
_____________________ can be used to create budgets, organized student grades, or compare various products or service.Workbooks
In each cell of a worksheet, you can enter numbers, letters, or _____________________.formulas
The _____________________ options button lets you copy the text instead of inserting the next higher number.AutoFill
A group of cells is called a(n) _____________________.range
Setting the _____________________ is when you tell Excel which cells to print.print area
A(n) _____________________ is a symbol that represents a specific action.arithmetic operator
Before shopping for a computer, what five questions should you ask?1. What can a basic, inexpensive computer do?
What are three components that can affect the price of the computer?Microprocessor
When you enter data in a cell, you may see ####. What is the problem, and how would you fix it?The column you are working is to narrow for all the data to show. Widen the column to see all the data.
How do you insert cells, rows, or columns?To insert a new cell, row, or column, click the Insert menu and choose row, cell, or column. By default, a new row is added above the cell pointer. A new column appears to the left of the pointer. If you want to insert a cell, an Insert box appears, and you can choose where you want the new cell to appear.
What are the five common excel functions?sum


instructor
Grinnell High School
Grinnell, IA

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities