MS Excel | MCQs

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

****

SH31-07-23

ND30-4-2023

Explanation

There is no function in Excel like AVG, at the time of writing,

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

****

ND7-5-2023

Explanation

$ sign is used to create an absolute cell reference in MS Excel.

In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Explanation

• A worksheet is an electronic spreadsheet that lets users to Calculate, Enter & Analyze data.
  

  A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.

  
  

Explanation

MS Excel (Microsoft Excel) is a popular spreadsheet software program used for data analysis, calculation, and visualization.

It allows users to create and edit spreadsheets, charts, and graphs.

It is widely used in various fields such as business, finance, and education.

MS Excel is a part of the Microsoft Office suite and is used for:

• Data entry and management
• Calculations and formulas
• Chart and graph creation
• Data analysis and visualization
• Budgeting and forecasting

In MS Excel you can enter 3 types of Data in a cell,labels, values and formulas.

Explanation

In MS Excel, "character" is not a valid data type.

There are Three types of data in cells: labels, values, and formulas.

1. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
2. Values (numbers) are generally raw numbers or dates.
3.  Formulas are instructions for Excel to perform calculations.

Explanation

• The formula bar displays the content of the active cell in MS Excel.
  • The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.

Additional Information 

• The name box in the worksheet displays the address of the selected cell.
• The title bar displays the title of the window and It includes the close, minimize, and maximize buttons.
• An active cell refers to a cell in an Excel spreadsheet that is currently selected by clicking the mouse pointer or keyboard keys.

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

 Columns are denoted and identified by a unique alphabetical header letter,

which is located at the top of the worksheet.

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

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

DATE: returns the serial date value for a date

TODAY: returns today's date

NOW: returns the current date and time

TIME: assemble a proper time.

***

RY24012023