MS Excel | MCQs

Explanation

• Pressing F2 in MS Excel allows you to edit
• Insert text in the selected cell.

Explanation

As of now, Excel 2021 is the latest standalone version of Microsoft Excel, released alongside Office 2021.

However, Office 365 (now known as Microsoft 365) is continuously updated with new features and improvements.

This making it the most up-to-date version in terms of features.

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

Filtering in Excel enables you to display rows that meet certain criteria, hiding the others.

This Excel feature allows you to display only the rows that meet specific conditions while hiding the others.

Explanation

When applying conditional formatting in spreadsheet software like Microsoft Excel, Google Sheets, or LibreOffice Calc, you can check conditions against:

• Cell value: You can specify a condition based on the value in a cell, such as "greater than", "less than", "equal to", etc.
• Formula: You can also specify a condition based on a formula, which can include references to other cells, functions, and operators.

Explanation

The Insert tab in MS Excel contains options to create charts, tables, pivot tables, etc.

It allows users to visualize data in various chart formats like bar, pie, line, and more.

Explanation

The SUM function in MS Excel is used to add numbers from selected cells or ranges (e.g., =SUM(A1:A5)).

It is one of the most commonly used functions for quick total calculations in spreadsheets.

Explanation

Explanation

VLOOKUP stands for Vertical Lookup.

It is used to search for a value in the first column of a table.

It is categorized under Lookup and Reference functions in Excel.

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.