MS | MCQs

Explanation

The F12 key used for 'Save As' 

But Ctrl + F12 will open a document from File Explorer.

Shift + F12 acts in the same way as Ctrl + S to save the document,

Ctrl + Shift + F12 will print a document with the default settings. 

***

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

"Superscript" is not a font style in MS Word; it is a text effect used to raise characters above the normal line of text.

Font styles include options like Bold, Italic, and Regular.

Explanation

Enter key is used to start a new paragraph in MS Word

*****

• Most repeated questions about shortcut key
• Goes to the beginning of the current line = Home
• 
  
• Goes to beginning of document = Ctrl + Home
• 
  
• Goes to end of current line = End
• 
  
• Goes to end of document = Ctrl + End
• 
  
• Highlights from the current position to the beginning of line = Shift + Home
• 
  
• Highlights from current position to end of line = Shift + End
• 
  
• Cut selected item = Shift + Del & Ctrl + X
• 
  
• Copy selected item = Ctrl + C
  
• 
  
• Paste selected item = Ctrl + V

Explanation

Important Short cut keys

• Copy: Ctrl+C
• Cut: Ctrl+X
• Paste: Ctrl+V

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

Ctrl+J is the shortcut to justify a paragraph in Word 

Additional information:

Crtl + S to save the document

Crtl + R to align a paragraph in the current document

Crtl + Y is a keyboard shortcut most often used to redo an action reversed using the undo command

The shortcut key to select Text in MS Word is the Shift key + use mouse.

Explanation

Using navigation keys

Page Up: Move the cursor or page up one screen.

Ctrl + Home: Move to the top of a document.

Ctrl + End: Move to the bottom of a document.

Page Down: Move the cursor or page down one screen.