Excel | MCQs

Explanation

To duplicate values in a cell range in Excel 2016, follow these steps:

• Select the range of cells that you want to duplicate.
• Go to the Home tab in the ribbon.
• Click on the "Fill" handle (the small square at the bottom-right corner of the selection) and drag it down to the range where you want to duplicate the values.
• Alternatively, you can right-click on the selection and choose "Copy" (or press Ctrl+C), then select the range where you want to duplicate the values and right-click and choose "Paste" (or press Ctrl+V).

Explanation

To move between worksheets in a workbook in MS Excel, you can use the following shortcuts:

• Ctrl+Page Up: Move to the previous worksheet
• Ctrl+Page Down: Move to the next worksheet

Explanation

The best orientation to fit maximum columns on a single sheet for print is Landscape. 

Landscape orientation provides a wider layout.

This making it ideal for printing more columns compared to the narrower Portrait orientation.

Explanation

 “F2” shortcut key for editing in the cell.

Additional information:

Explanation

Explanation

The formula bar is used for the current cell and its constraint.

The formula bar displays the content of the active cell in MS Excel.

Explanation

A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations

the columns are normally represented by letters, "A," "B," "C," etc.,

while

rows are normally represented by numbers, 1, 2, 3, etc.

SH31-07-2023

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

***

Which is the shortcut key to display active cells in Excell?

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

Explanation

To add two cells (A1 and A2) together, you use the following formula *=A1+A2. 

Explanation

In a computer spreadsheet,

A preprogrammed Formula is basically a function graph range cell.

***

RY24012023