Column | MCQs

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

Automatically adjust your table or columns to fit the size of your content by using the AutoFit button.

Select your table.

On the Layout tab, in the Cell Size group, click AutoFit.

Do one of the following.

To adjust column width automatically, click AutoFit Contents.

Explanation

Columns in MS Excel are numbered Alphabetically (A, B, C, etc.).

Rows in MS Excel are numbered Numerically (1, 2, 3, etc.).

Explanation

The minimum number of rows added in MS Word: 1

minimum number of columns in MS word: 1

Maximum number of columns in MS word: 63

ND4-672023

Explanation

The keyboard shortcut Ctrl+Shift+Enter also inserts a column break where you've placed your cursor.

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

The smallest width of a column in MS Word is 0.5 inches, which is the minimum allowed for fitting content within the document.

The largest width that a column can be set to is typically 22 inches, depending on the page size.

Explanation

A cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. 

Cell Address is also known as Cell Reference.

AGM 24-12-2022

Explanation

Most databases and spreadsheets (like Excel or Google Sheets) allow users to freely add or delete rows and columns.

This flexibility helps in updating or organizing data as per requirements.

Explanation

In Microsoft Excel 2007, each worksheet contains:

• Columns: 16,384, labeled from A to XFD.

• Rows: 1,048,576.