0
What else can I help you with?
Which report output format should you choose When creating a spreadsheet of data?
CSV should be used when creating a spreadsheet of data.
What function a spreadsheet have to help organize data?
Spreadsheets have many functions to help organise data. Organising data is one of the purposes of a spreadsheet, particulary if it is a lot of numerical data. If it is things like names, address etc., a database can be better. Spreadsheets can do things like sort data and extract data. They can lay data out in a tabular format using the rows and columns in the spreadsheet. There are some specific database functions that can be used in a spreadsheet that are used for organising data.
What is meant by a spreadsheet model?
A spreadsheet model is the model (the type) of the spreadsheet. - how it looks like.
What is the name of a workbook used to collect data?
It is a spreadsheet.
Can a spreadsheet only be used to show numerical data?
No
Can a spreadsheet collect data?
You can collect data and store it in a spreadsheet.
When data in a spreadsheet programs changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
When data in a spreadsheet program is changed what occurs?
If the spreadsheet contains formulas that rely on the data in the spreadsheet, then changing the data changes the cells on the spreadsheet that utilize the formulas.
What is a function in spreadsheet program?
Spreadsheet is a computer program used for calculating, organising, analysing data, and display results
Is a spreadsheet application frequently used to analyze numbers and data?
yes
Spreadsheet application software is widely used to organize data in?
yes
What are the four steps that must be done to implement any LP problem in a spreadsheet?
1. Organize the data for the model on the spreadsheet 2. Reserve separate cells in the spreadsheet to represent each decision variable in the algebraic model. 3. Create a formula in a cell in the spreadsheet that corresponds to the objective function in the algebraic model. 4. For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand-side of the constraint.
