Explanation

In older versions of Excel (up to 2003), a worksheet contains 256 columns.

Newer versions have expanded this limit to 16,384 columns.

A single worksheet in Excel contains 65,536 rows.

Explanation

The Slide Master and Title Master for a template is called a slide-title master pair.

The Slide Master controls the properties of every slide in the presentation.

All of the characteristics of the Slide Master appear on every slide in the presentation:

• background-color
• text color
• font
• and font size

****

• ND20-1-2023

Explanation

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

Explanation

 press Ctrl+1 to open the Format Cells dialog box.

In the Format Cells dialog box, in the Category list, click Currency or Accounting.

ND7-5-2023

CTRL+Shift+4 is used for Currency Format. CTRL+Shift+1 is used for decimal Format Shift +1 is used to insert ! CTRL+1 is used to open "Format Cells" Dialogue Box

Explanation

The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.

Explanation

In MS Excel, an embedded formula can be removed by pressing the DELETE key.

It clears the formula from the selected cell without affecting the formatting or other content in the worksheet.

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.

Explanation

In Excel, each row of a table corresponds to a record.

It is a complete set of data.

Field corresponds to columns in Excel.

Each column represents a field or a specific type of data within the records.

Explanation

The F5 key is a function key found at the top of almost all computer keyboards.

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

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

Excel uses three types of references:

1. Relative
2. Absolute
3. Mixed

These determine how cell references adjust when formulas are copied across cells.