Excel | MCQs

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

Transposing is a process in data management where rows are converted into columns and vice versa.

This is a common operation in data analysis, reporting, and visualization.

In Microsoft Excel, for example, you can use the "Transpose" feature to switch rows and columns.

It allowing you to view and analyze data from a different perspective.

Explanation

To show the gridlines, in Excel, PowerPoint, or Word, click the View tab,

and then check the Gridlines box.

To hide the gridlines, clear the Gridlines check box.

The keyboard shortcut to remove the gridlines is to press Alt and enter W, V, G.

Explanation

A formula always begins with an equal sign (=)

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

In Excel, the default row height is 15 (20 pixels),

and the column width is 8.43 (64 pixels).

Explanation

The active cell in MS-Excel is simply a rectangular box that highlights the sheet in excel.

Explanation

A pie chart is a circular statistical graphic, which is divided into slices to illustrate numerical proportion.

In a pie chart, the arc length of each slice is proportional to the quantity it represents.

****

RY17-012-23

Explanation

The .xls extension is used for excel files .

MS word = ..docx
MS Power Point: .pptx

Explanation

F1: To open Microsoft Excel help.

**** 

RY18012023

Explanation

Difference means فرق

Distinction means امتیاز، فرق یا تفریق