w3resource

C Exercises: Develop a small part of spreadsheet software

C Basic Declarations and Expressions: Exercise-148 with Solution

Your task is to develop a small part of spreadsheet software.

Write a C program, which adds up columns and rows of given table as shown in the following figure.

C Programming: Develop a small part of spreadsheet software.

Input:
n (the size of row and column of the given table)
1st row of the table
2nd row of the table
:
:
n th row of the table
The input ends with a line consisting of a single 0.
Output:
For each dataset, print the table with sum of rows and columns.

Sample Solution:

C Code:

#include <stdio.h>

int main() {
  // Declare a 2D array to store cell data
  int cell_data[11][11];
  int i, j, n, sum_val;

  // Prompt user for input
  printf("Input number of rows/columns:\n"); 
  scanf("%d", &n);

  // Prompt user for cell values
  printf("Input the cell value\n"); 

  // Check if n is a positive value
  if (n > 0) {
    // Loop through rows
    for(i = 0; i < n; i++) {
      printf("\nRow %d input cell values\n", i);

      // Loop through columns
      for(j = 0; j < n; j++) {
        // Read cell value and store it in the array
        scanf("%d", &cell_data[i][j]);
      }
    }

    // Calculate row sums and update array
    printf("\nResult:\n");
    for(i = 0; i < n; i++) {
      sum_val = 0;
      for(j = 0; j < n; j++) {
        sum_val += cell_data[j][i];
      }
      cell_data[n][i] = sum_val;
    }

    // Calculate column sums and update array
    for(i = 0; i < n; i++) {
      sum_val = 0;
      for(j = 0; j < n; j++) {
        sum_val += cell_data[i][j];
      }
      cell_data[i][n] = sum_val;
    }

    // Calculate total sum and update array
    sum_val = 0;
    for(i = 0; i < n; i++) {
      sum_val += cell_data[n][i];
    }
    cell_data[n][n] = sum_val;

    // Print the updated array
    for(i = 0; i < n + 1; i++) {
      for(j = 0; j < n + 1; j++) {
        printf("%5d", cell_data[i][j]);
      }
      printf("\n");
    }
  }

  // Return 0 to indicate successful execution
  return 0;
}

Sample Output:

Input number of rows/columns:
4
Input the cell value

Row 0 input cell values
25
69
51
26

Row 1 input cell values
68
35
29
54

Row 2 input cell values
54
57
45
63

Row 3 input cell values
61
68
47
59

Result:
   25   69   51   26  171
   68   35   29   54  186
   54   57   45   63  219
   61   68   47   59  235
  208  229  172  202  811

Flowchart:

C Programming Flowchart: Develop a small part of spreadsheet software.

C programming Code Editor:

Previous: Write a C program to find the number of combinations that satisfy p + q + r + s = n where n is a given number <= 4000 and p, q, r, s in the range of 0 to 1000.
Next: Write a C program, which reads a list of pairs of a word and a page number, and prints the word and a list of the corresponding page numbers.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/c-programming-exercises/basic-declarations-and-expressions/c-programming-basic-exercises-148.php