Data | MCQs

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

Hard disk storage devices can store a maximum amount of data.

It has the highest capacity to store data up to 2 Terabytes.

Hard Disk is an electromechanical data storage device that stores and retrieves digital data using magnetic storage.

Explanation

A hard disk is a secondary storage device used to store data permanently.

RAM and ROM are primary storage (main memory).

Diodes and Semiconductors are basic electronic components.

Explanation

Goal Seek, Solver, and Scenario Manager are all tools in Excel used for What-If Analysis.

It helping to analyze different possible outcomes.

Goal Seek adjusts a single input to reach a desired result.

Solver handles complex optimizations.

Scenario Manager compares multiple data scenarios.

Explanation

Getting data from a cell located in a different sheet is called Cell reference.

There are Three types of Cell reference in Excel

1. Relative
2. Absolute
3. Mixed

****

RY17-012-23

Explanation

Explanation

categorical meaning: دو ٹوک

conditional  meaning : مشروط طور پر

SH24-8-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

Formula Bar area in an Excel window allows entering values and formulas.

It is labeled with a function symbol (fx).

By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.