MS Excel | MCQs

Explanation

Click the cell that contains the data that you want to edit, and then press F2.

This starts Edit mode and positions the cursor at the end of the cell contents.

F1 to F12 keys are known as function keys.

**** 

RY18012023

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

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

ND11-12-2022

Explanation

In MS Excel 2016, you can split the window into two panes using the following steps:

• Go to the "View" tab in the ribbon
• Click on "Window" in the "Window" group
• Select "Split" from the dropdown menu

Alternatively, you can also use the shortcut key:

Alt + W + S

Explanation

A workbook is a collection of one or more spreadsheets and charts in a single file.

Explanation

As a default in Microsoft Excel, text typed into a cell is aligned to the left border of the cell while numbers are aligned to the right.

Explanation

Explanation

With a hyperlink cannot be used to link Excel worksheet data to a Word document for dynamic updates.

Hyperlinks can only direct to the Excel file but do not embed or link data directly.

Explanation

The VLOOKUP function in Excel is used to search for a value in the first column of a range

And return a value in the same row from a specified column.

It is commonly used for looking up data in a table or range.

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

***

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

ND11-3-2023