Spreadsheet: People use spreadsheet in order to do calculations and also they create charts. The rows and columns in a spreadsheet are called as worksheet. Example: Microsoft Excel. It contains many worksheets. In a worksheet, only few cells are visible at a time which can be further extended by scrolling it. It contains both raw data and processed data. The raw data is the data which is directly obtained from the source and it needs to be processed. It is otherwise called as primary data. After processing the data, the data is referred to as processed data. Organizing data in a spreadsheet: In a spreadsheet information is organized in rows (data is stored horizontally) and columns (data is stored vertically). Each cell in a worksheet has specific name in the form of alphabets and numbers. The column names start from A, B, C, and so on. The row names start from 1, 2, 3, and so on.

Question

Want to see the full answer?

Answer 1

Question

Chapter 12, Problem 34E

Program Plan Intro

Spreadsheet:

People use spreadsheet in order to do calculations and also they create charts. The rows and columns in a spreadsheet are called as worksheet.

Example: Microsoft Excel. It contains many worksheets.

In a worksheet, only few cells are visible at a time which can be further extended by scrolling it.

It contains both raw data and processed data.

The raw data is the data which is directly obtained from the source and it needs to be processed. It is otherwise called as primary data.

After processing the data, the data is referred to as processed data.

Organizing data in a spreadsheet:

In a spreadsheet information is organized in rows (data is stored horizontally) and columns (data is stored vertically).

Each cell in a worksheet has specific name in the form of alphabets and numbers.

The column names start from A, B, C, and so on.

The row names start from 1, 2, 3, and so on.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

I need help writing pseudocode for calculating class score average by putting in 5 test scores, and showing the average from all 5 inputs and the GPA score.Starting with 3 functions outside of a main module. The functions are getScore(), getGPAPoint(Integer score), and getAverage(). Function getscore is an input for a grade as a class percentage. Function getGPAPoint will calculate the score into a GPA point and return as a float (values of 90-100 as 4.0, 80-89 as 3.0, 70-79 as 2.0, 60-69 as 1.0, and anything below 60 as 0.) Function averageGPA will finally make a call to both previous functions when the user inputs numbers 5 times that then calculates the average (add up all the scores, divide by 5) and the average grade alongside displaying the average GPA. End result is a main module that makes a proper call to the averageGPA function and display its results. Need help with this!

Please original work Why is integration between data collection and business analysis so important to success in an organization that uses business analytics? How can a company that is just starting to use business analytics set up its program for success right from the beginning? Please cite in text references and add weblinks

How to make a 1 bit adder with CLA?