Explanation

A function is a predefined formula that performs calculations using specific values in a particular order.

All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.

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

Existing Templates

To create a workbook based on an existing template, follow these steps.

1. On the File tab, then click New.

2. Use the search box to search for online templates or click a template from one of the Office templates.

Explanation

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Explanation

Browser is not a term pertaining to spreadsheets.

Spreadsheets are not included in the definition of "browser."

Explanation

 In MS Excel, the 'Wrap Text' feature is used to wrap extra-long text into multiple lines so that you can see all text.

ND5-2-2023

Explanation

When the CPU detects an interrupt:

• then it saves its  Current State 
• The processor responds by suspending its current activities
• saving its state
• and executing a function

ND5-2-2023

Explanation

Excel 2003 and earlier 65,536 Rows.

Excel 2007 and higher 1,048,576 Rows.

and 16,384 columns

ND5-2-2023

Explanation

The tables' columns are referred to as fields.

Within a record, a field holds a specific piece of data.

columns and rows make up the two-dimensional structure known as a table.

The columns are referred to as fields in more formal computer terminology, while the rows are referred to as records.