dig litty tets

cell

a box or rectangle in a spreadsheet where data may be entered

label

any word entered into a spreadsheet

income

money earned from a job

balance sheet

a statement of the company's financial position at a certain time

function

a built-in formula in a spreadsheet

pie graph

a diagram that looks like a circle to display data

a label is

any word that appears in a cell of a spreadsheet.

in a database it is possible to make changes such as ,….

font , text style, text color, line color , and background color .

Order of operations is

BEDMAS ,,,,,,,,,,,,,,,,BRACKETS EXPONENTS DIVISION MULTIPLICATION ADDITION AND SUBTRACTION.

ways that databases can help you manage and manipulate data is ,

updating info in more than one place at a time , arranging the data in a certain order , querying data, merging data into a word-processing document,

which steps do you follow to create a graph ?

highlight the data and labels, use the insert graph command , and select the type of graph .

You enter a formula in a celll ina spreadsheet and presses enter but instead of the answer ,you see B2+B3/C5. what mistake did you make?

you forgot to start with the equal sign.

you have just finished entering the feild names for your database . you need to choose the primary key or key feild , but none of your fields are unique . what should you do?

let the database assign a unique number in a new field.

You keep a database for product pricing . one of the prices changed . you need to——————————-

UPDATE THE RECORD BY EDITING THE PRICE

You notice that somehow you have duplicate records for some of your clients in your database. what should you do?

delete the duplicate records

you need to keep client info such as names and addresses . you should use a ——

DATABASE.

You receive and email from your manager letting you know that you need to add a field to the database. What should you do ?

insert a column into you database table

You want to find the average rainfall for the city you live in . you should use a

SPREADSHEET.

You would like to find the spreadsheet to add the values in cell A1 and A2 and then multiply this answer by the value in cell B1 . What would your formula look like .

A1+A2)*B1

you would like to create a graph that shows how much of your total investments are in stocks , savings, and mutual funds . you should create a

PIE GRAPH

You would like to know how many cells contain data . which function should you use

COUNT

You would like to have a simple method for entering data into a database. you should create a

DATA ENTRY FORM

You would like to send a letter to more than one hundred people . you would like the letter to have names and addresses inserted on the text. You should create a

FORM LETTER

Your manager asks you to calculate the sale price if the product is marked down 20 percent . You enter the original price in cell A2. what formula should you have ?

= A2*.80