All categories

4 years ago

Options....HELP ASAP PLEASE Columns Rows Sheets Workbook

Computers and Technology

1 answer:

Nezavi [6.7K]4 years ago

6 0

Answers:

<u>Columns</u> are oriented vertically on a spreadsheet.

<u>Rows</u> are oriented horizontally on a spreadsheet.

<u>Columns</u> are labeled with letters.

<u>Rows</u> are labeled with numbers.

<u>Sheets</u> are used for independent variables.

<u>Workbooks</u> are used for dependent variables.

<h2>Columns:</h2>

Columns are formed when all the cells are combined in vertical series. Each column is labeled with the Alphabets like A, B , C, D and so on. Columns in a sheet may have values of a single entity(subject) changing respectively with rows.

For example:

A column can have the marks of Mathematics of all the students.

Rows are formed when the cells are combined in horizontal series. Rows are labeled with numbers like 1, 2 , 3 and so on. A row may has the values of different entities(subject) changing according to columns.

For example:

A row can has numbers of different subject o a single student.

<h2>Work Sheets:</h2>

Worksheets are the part o excel having rows, columns gridlines etc. It is the area where main work is done.

<h2>Sheets:</h2>

Sheets can be of different types depending upon the need. Such as chart sheet, Macro sheet, Dialog sheet etc. A worksheet is also counted as a sheet.

You might be interested in

Which of these is a way of making applications less vulnerable to hacking?

Alecsey [184]

(First one )
---------------------

7 0

3 years ago

Read 2 more answers

Write a C++ function, smallestIndex, that takes as parameters an int array and its size and returns the index of the first occur

Oduvanchick [21]

Answer:

Explanation:

The code in C++ is written as:

#include <iostream>

using namespace std;

int smallestIndex(int arr[],int size)

{

int min=arr[0],ind=0;

for(int i=0;i<size;i++)

{

if(min>arr[i])

{

min=arr[i];

ind=i; NOTE: ind serves as a variable that is holding the smallest

} element index of array

}

return ind;

}

int main() {

int arr[15];

cout<<"Enter 15 integers: ";

for(int i=0;i<15;i++)

cin>>arr[i];

for(int i=0;i<15;i++)

cout<<arr[i]<<" "<<endl;

int index=smallestIndex(arr,15);

cout<<"The position of the first occurrence of the smallest element in list is: "<<index<<endl;

cout<<"The smallest element in list is: "<<arr[index];

}

OUTPUT:

Enter 15 integers:

4 5 8 4 6 1 2 1 4 5 7 9 5 7 8

The position of the first occurrence for the smallest element in the list is 5

The smallest element in the list is: 1

7 0

3 years ago

What is looping in QBASIC

Elden [556K]

A looping is a set of instructions which is repeated a certain number of times until a condition is met. hlo dai k xa halkhabar

3 0

3 years ago

HACTEHA [7]

Question 6 west Germany

3 0

3 years ago

Suppose that the format for license plates in a certain state is two letters followed by four numbers. (a) How many different pl

Ymorist [56]

Answer:

(a) 6,760,000 plates

(b) 3,407,040 plates

Explanation:

The very first thing to note about this question is the number of characters involved in the license plate format (6 characters in this case; 2 letters and 4 numbers). The letters come first and then the numbers follow.

There are a total of 26 possible letters (A-Z) and 10 possible numbers (0 - 9) that can be chosen. We can then proceed to the first question;

(a) Here, the total number of possible plates is to be determined. This is done as follows:

Character 1 (Letter): There are 26 possible letters

Character 2 (Letter): There are 26 possible letters

Character 3 (number): There are 10 possible numbers

Character 4 (number): There are 10 possible numbers

Character 5 (number): There are 10 possible numbers

Character 6 (number): There are 10 possible numbers

So, total number of different plates will be obtained by multiplying all the possibilities: 26 × 26 × 10 × 10 × 10 × 10 = 6,760,000 plates

(b) This second part puts a constraint on the usage of the numbers, unlike the question (a), where there was no constraint at all.

Since there is no constraint on the letters, we can write that:

Character 1 (Letter): There are 26 possible letters

Character 2 (Letter): There are 26 possible letters

For the first number as well, we can write:

Character 3 (number): There are 10 possible numbers

However, for the remaining characters, the possibilities will continually reduce by a value of 1, since we can not use a number that has been used before. So,

Character 4 (number): There are 9 possible numbers

Character 5 (number): There are 8 possible numbers

Character 6 (number): There are 7 possible numbers

So, total number of different plates will be: 26 × 26 × 10 × 9 × 8 × 7 = 3,407,040 plates

(c) Here, repetitions are allowed as in questions (a), but there can not be four zeros. This implies that the maximum number of zeros in any plate will be three. Thus, there will be maximum possibilities on all characters until the last one which will be constrained.

Character 1 (Letter): There are 26 possible letters

Character 2 (Letter): There are 26 possible letters

Character 3 (number): There are 10 possible numbers

Character 4 (number): There are 10 possible numbers

Character 5 (number): There are 10 possible numbers

Character 6 (number): There are 9 possible numbers

Total number of plates will therefore be: 26 × 26 × 10 × 10 × 10 × 9 = 6,084,000 plates.

7 0

3 years ago