Excel Function | MCQs

Explanation

In MS Excel, all formulas and functions start with the equal sign (=).

This tells Excel to perform a calculation instead of treating the input as plain text.

Explanation

ALT + Shift + F1 is also used to create a new worksheet

Ms. Excel is a Spreadsheet program

MS Excel is based on WINDOWS

shortcut key in  MS Excell:

which key is used for help in MS excel?

F1

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

Ctrl+;

Explanation

The MOD function in Excel is used to find the remainder after the division of one number (dividend) by another (divisor).

The syntax for the MOD function in Microsoft Excel is: MOD( number, divisor )

***

Explanation

Goal Seek, Solver, and Scenario Manager are all tools in Excel used for What-If Analysis.

It helping to analyze different possible outcomes.

Goal Seek adjusts a single input to reach a desired result.

Solver handles complex optimizations.

Scenario Manager compares multiple data scenarios.

Explanation

F2 function key is used to edit the content of a cell in MS-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, you can copy data or formulas using Edit menu commands, shortcut menu options, or toolbar buttons like "Copy" and "Paste."
• These methods offer flexibility for users to quickly replicate data or formulas across cells or worksheets.

Additional Points:

• Keyboard Shortcuts: Use Ctrl + C (Copy) and Ctrl + V (Paste) for efficiency.
• Drag and Drop: Copy formulas by dragging the fill handle at the corner of a selected cell.
• Right-Click Menu: Provides quick access to copy/paste commands directly.
• Paste Special: Allows pasting specific attributes (e.g., values, formats) using Alt + E + S.

Explanation

In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells.

COUNT Function:
The COUNT function counts the number of cells that contain numeric values within a specified range.

For example: =COUNT(A1:A10)
This formula will return the number of cells containing numbers in the range A1 through A10.

Explanation

The maximum function calculates the largest value in a set of numbers in Excel.

Explanation