Excel | 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

The F11 key allows you to activate full-screen mode in your browser.

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

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

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

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

The Right answer is Ctrl + ;

***

Shift+Backspace

**

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

 Ctrl+;

Which key is used for the GO TO tab in Ms. Excel?

 F5 

Which key is used for excel column highlight?

CTRL + space

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

Explanation

In MS Excel ready-made templates are available under file tab in new option .

When considering Microsoft Word, Microsoft Excel, Microsoft Power Point, the templates are in files tab

_____________________________________-

 Use Excel's Table command to convert a list of data into a named Excel Table.

These tables have useful features, like sorting and filtering, to help organize and view data.

Explanation

Explanation

The Name Box normally displays the address of the "active cell" on the worksheet.

Data or Formula of the Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar

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

F11 Creates a chart of the data in the current range in a separate Chart sheet.

Some important shortcuts used in MS Excel

•F1 Opens Excel Help

•F2 Edit contents of an excel

•F3 Paste Named Range or Named List

•F4 Toggles between cell references - Absolute, Relative, and Mixed Reference

•F5 Displays the "Go To" dialog box

•F6 Switch between the panes of an Excel workbook if you have a split window

•F7 Opens the "Spelling" option in Excel using which you can check the spellings in your workbook

•F8 Enables and disables the "Extend Mode" selection in Excel.

•F9 Recalculates the output of all formulas in your Excel workbook.

• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips

• F12 Opens the "Save As" dialog box like the "Alt + F2" keys

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.