Spreadsheet-Theory

Question 1

Column

Answer 1

• Vertical Strips of SS
• Identified by letters, top
• Called Column Header

Question 2

Cell

Answer 2

• Intersection of row and column

* Activated by clicking on it

Question 3

Formula Bar

Answer 3

Data or formulae can be entered directly into the active cell or entered into the formula bar. If you click on a cell that already has a formula, then it will be displayed in the formula bar.

Question 4

Name Box

Answer 4

Located before the formula bar and lists the location of the active cell.

Question 5

Worksheet

Answer 5

Grid of rows and columns.

Question 6

Workbook

Answer 6

Contains one or more worksheets.

Question 7

Scroll Bars

Answer 7

These components help to scroll the content and body of the spreadsheet. There are horizontal and vertical scroll bars.

Question 8

Address

Answer 8

• Each cell is identified by reference/address
• Format: Columnno.Rowno.
• Eg: B1, C15

Question 9

Active Cell

Answer 9

Cell with a dark boundary which is ready for entering or editing data.

Question 10

A range of cells

Answer 10

A group of adjacent cells which looks like a square or a rectangle.

Question 11

+

Answer 11

Addition

Question 12

-

Answer 12

Subtraction

Question 13

*

Answer 13

Multiply

Question 14

/

Answer 14

Divide

Question 15

%

Answer 15

Percentage

Answer 16

(It’s called a caret)

Exponentiation

Question 17

One cell up

Answer 17

Up arrow key

Question 18

One cell down

Answer 18

Down arrow key or Enter

Question 19

One cell left

Answer 19

Left arrow key or Shift+Tab

Question 20

One cell right

Answer 20

Right arrow key or Tab

Question 21

Top of the W.S

Answer 21

Ctrl+Home

Question 22

End of W.S (Last cell containing data)

Answer 22

Ctrl+End

Question 23

End of the row

Answer 23

Ctrl+Right arrow key

Question 24

End of the column

Answer 24

Ctrl+Down arrow key

Question 25

One page up

Answer 25

Page up key

Question 26

One page down

Answer 26

Page down key

Question 27

What is stock register?

Answer 27

It is a type of record of transactions of a publicly-trades company which consists of information related to transfer issues of stocks, buyback and other actions related to the company's stock. Stock refers to the total capital or equity state of the company.

Question 28

Suggestions

Answer 28

Select any of the suggested correctly spelled words

Question 29

Change

Answer 29

Change the current words only

Question 30

Change All

Answer 30

Change all appearances of the word in the entire document

Question 31

Ignore Once

Answer 31

No corrections required

Question 32

Ignore All

Answer 32

Ignore all occurrences of the word in the document

Question 33

Add to dictionary

Answer 33

Self-explanatory, much?😂😂

Question 34

Row

Answer 34

* Horizontal strips of SS * Identified by no., LHS * Called Row header