Explanation

The SUM function in MS Excel is used to add numbers from selected cells or ranges (e.g., =SUM(A1:A5)).

It is one of the most commonly used functions for quick total calculations in spreadsheets.

Explanation

A progress bar is a graphical control element used to visualize the progression of an extended computer operation, such as a download, file transfer, or installation. 

*************

VU FIA SUB INSPECTOR PAPER 30-1-2021

Explanation

Explanation

A spreadsheet is also known as a workbook.

A workbook is a file that contains one or more spreadsheets, which are made up of cells, rows, and columns.

The terms "spreadsheet" and "workbook" are often used interchangeably, but a workbook can contain multiple spreadsheets, while a spreadsheet is a single sheet within a workbook.

Explanation

COUNT function counts only numerical values in a selected range.

It ignores text, blank cells, and logical values (TRUE/FALSE).

Explanation

In MS Excel, letters (like B) represent columns, while numbers (like 3) represent rows.

So, in cell address B3, B is the column number, and 3 is the row number.

Explanation

In Microsoft Windows, you can split the window into two panes by using the "Split" option in the "Window" menu.
This feature is useful for comparing documents, viewing multiple files simultaneously, or organizing your workspace.
To split the window, follow these steps:

• 1. Open a window (e.g., a document, file explorer, or web browser).
• 2. Click on the "Window" menu in the top menu bar.
• 3. Select "Split" from the drop-down menu.
• 4. The window will divide into two panes, allowing you to view different content in each pane.

Explanation

=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.

The colon : denotes a continuous range of cells.

Explanation

Select the objects you want to align.

Press Shift to select multiple objects.

Select Picture format > Align and select how you want to align them:

Align Left, Align Center, or Align Right. Align the Top, Align the Middle, or Align the Bottom. Distribute Horizontally or Distribute Vertically.

Explanation

The maximum number of rows in MS Excel is 1,048,576, starting from row 1.

Excel has a maximum of 16,384 columns, labeled from A to XFD.