Explanation

A constant is a set value that doesn't change and that's directly inserted into a cell.

It's not a formula and it's not calculated by a formula.

*******

VU CBT FIA  PAPER 19-12-2021

Explanation

Explanation

A worksheet consists of rows (horizontal) and columns (vertical) where data is entered into cells at their intersections.

Explanation

****

Explanation

• The main window in a computer spreadsheet is called a workbook
• while 
• The title bar in MS Excel displays the name of the  worksheet
• **
• In Excel, when we create a new document, we always select a blank workbook, as you already have done in the previous chapter.
• When this blank workbook opens up, an interface you see is called a workbook window.
  

Explanation

A value in Excel refers to numerical data, dates, or text that can be used in calculations.

"Obtained marks - 87" is a text string, not a value directly usable in calculations.

Explanation

In Ms Excell, the horizontal scroll bar is located on the bottom right of the screen.

There are two scroll bars in Excel:

1. vertical scroll bar is used to view the data in Excel from up and down,
2. horizontal scroll bar used to view the data from left to right.
   

Explanation

• Type the entire equation: = B1+B2+B3+B4+B5
• Use the SUM function: = SUM(B1: B5)
• Press the Enter key to complete the formula

Explanation

20 x 10 = 200

200 / 5 = 40

40 x 8 = 320

So, Excel evaluates the formula and returns 320.

Explanation

In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells.

COUNT Function:
The COUNT function counts the number of cells that contain numeric values within a specified range.

For example: =COUNT(A1:A10)
This formula will return the number of cells containing numbers in the range A1 through A10.