Spreadsheet | MCQs

Explanation

Microsoft Excel is a spreadsheet software widely used for creating tables of columns and rows for statistical or mathematical calculations.

It provides various features such as formulas, functions, charts, and pivot tables to manage and analyze data.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter,

which is located at the top of the worksheet.

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

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

Getting data from a cell located in a different sheet is called Cell reference.

There are Three types of Cell reference in Excel

1. Relative
2. Absolute
3. Mixed

****

RY17-012-23

Explanation

Minimum zooming is 10% and Maximum zooming is allowed in 400%.

So, 500% is invalid zoom percentage in Excel.

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

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• Apply conditional formatting to text
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Point to Highlight Cells Rules, and then click Text that Contains.
• Type the text that you want to highlight, and then click OK.

• ****

  RY 16-01-2023

Explanation

Formula Bar area in an Excel window allows entering values and formulas.

It is labeled with a function symbol (fx).

By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

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

In a spreadsheet, the data is organised in columns and rows. 

Explanation

To activate a cell in MS Excel, you can use any of the following methods:

• Clicking the cell: Simply click on the cell you want to activate.
• Pressing an arrow key: Use the arrow keys (↑, ↓, ←, →) to navigate to the cell you want to activate.
• Pressing the Tab key: Pressing Tab will move the focus to the next cell in the worksheet, activating it.

Additionally, you can also activate a cell by:

• Using the mouse to right-click on the cell
• Using the keyboard shortcut Ctrl + Arrow key (e.g., Ctrl + →) to move to the next cell
• Using the keyboard shortcut F2 to edit the active cell