Functions | MCQs

Explanation

Center the text. Ctrl+E

Align the text to the left. Ctrl+L

Align the text to the right. Ctrl+R

Cancel a command. Esc

Explanation

In C language, printf() function is used to print formatted output to the standard output stdout (which is generally the console screen).

The printf function is a part of the C standard library and it can allow formatting the output in numerous ways.

Explanation

An arithmetic-logic unit (ALU) is the part of a computer processor (CPU) that carries out arithmetic and logic operations on the operands in computer instruction words.

Explanation

To calculate the average in Excel, you can use the AVERAGE function: 

• Formula =AVERAGE(number1, [number2], …) 
• Arguments: Number1 is required, and Number2 is optional 
• Example =AVERAGE(A1:A20) returns the average of the numbers in the range A1:A20

Explanation

CTRL+SHIFT+F6 Switch to the previous workbook window

Additional information:

CTRL+F7 When a workbook window is not maximized, perform the Move command 

CTRL+F6 When more than one workbook window is open, switch to the next workbook window.

Ctrl+Shift+F12 Prints the current worksheet.

 F7 Displays the Spelling dialog box to check spelling

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 Microsoft Access, pressing SHIFT+F10 is used to Display the shortcut menu.
• The shortcut menu, also known as the context menu, is a menu that provides options related to the selected object or area.
• It typically contains commands that are relevant to the current context, allowing you to perform various actions without navigating through multiple menus.

Explanation

The Esc key is usually used to escape from a particular environment or cancel an ongoing action. 

It allows users to exit menus, dialogs, or other modes without making changes.

Explanation

The Title Bar is a horizontal bar placed at the top of a window.

Menu Bar is located below the title bar.

The title bar in MS Excel displays the name of the workbook

Explanation

In C++, 'b' escape sequence is used for backspace. 

In C++, 'f' escape sequence is used for Formfeeding.