FUNDAMENTALS OF COMPUTER

APPLICATION SYSTEM SOFTWARE

APPLICATION SOFTWARE FOR PERSONAL ENTERPRISE WORKGROUP OBJECTIVES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
how is data organized in a spreadsheet?
A
lines and spaces
B
layers and places
C
height and width
D
rows and columns
Explanation: 

Detailed explanation-1: -Columns are vertical series of individual blocks (cells) that are denoted by letters of the English alphabet such as A, B, C and so on. The series of cells that run across the spreadsheet horizontally are referred to as rows. Rows are denoted by a number like row 1, row 3, row 67 and so on.

Detailed explanation-2: -Data organization guidelines Put similar items in the same column Design the data so that all rows have similar items in the same column. Keep a range of data separate Leave at least one blank column and one blank row between a related data range and other data on the worksheet.

Detailed explanation-3: -A table is divided into columns and rows. The first column lists items to be compared. The row across the top lists the specific characteristics being compared. Within the grid of the table, the collected data is recorded.

Detailed explanation-4: -A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

There is 1 question to complete.