A. Sort in data tab
B. Sort in review tab
C. Filter in data tab
D. Filter in review tab
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 ). ***
Show/Hide Explanation
A. 1.40 MB
B. 1.40 GB
C. 1.44 MB
D. 1.44 GB
Explanation
The capacity of 3.5 inch floppy disk was 1.44 MB
The double-sided, high-density 1.44 MB (actually 1440 KiB = 1.41 MiB) disk drive, which would become the most popular, first shipped in 1986.
Show/Hide Explanation
A. Magnetic Storage
B. Optical
C. Flash memory
D. Both A & B
Explanation
Magnetic storage devices: Today, magnetic storage is one of the most common types of storage used with computers.
This technology found mostly on extremely large hybrid hard drive s
Show/Hide Explanation
ڈیٹا اور پاس ورڈ کی حفاظت کون کرتا ہے۔
A. Authentication
B. Encryption
C. None
D. Authorization
Explanation
Encryption is a means of securing digital data using one or more mathematical techniques, along with a password or "key" used to decrypt the information.
Show/Hide Explanation
ڈیٹا ربن میں درج ذیل میں سے کون سی خصوصیات نہیں مل سکتی ہیں؟
A. Data Validation
B. What-If Analysis
C. PivotTable
D. Text to Columns
Explanation
In the Data ribbon of Microsoft Excel, the feature "PivotTable" cannot be found.
The PivotTable feature is located in the Insert ribbon.
The Data ribbon includes features such as What-If Analysis, Data Validation, and Text to Columns.
Show/Hide Explanation
آپ ایک کالم کو 2 یا زیادہ کالموں میں کیسے تقسیم کر سکتے ہیں؟
A. Select the cell that you want to split. Then, navigate to the Insert Tab, after that, select Text to Column.
B. Select the cell that you want to split. Then, navigate to the Design Tab, after that, select Text to Column.
C. Select the cell that you want to split. Then, navigate to the Home Tab, after that, select Text to Column.
D. Select the cell that you want to split. Then, navigate to the Data Tab, after that, select Text to Column.
Explanation
Split data into multiple columns
Select the " Sales Rep " column, and then select Home > Transform > Split Column. Select Choose the By Delimiter. Select the default Each occurrence of the delimiter option, and then select OK. ... To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".
Show/Hide Explanation
ایکسل میں کس فنکشن کا استعمال ٹیبل میں معلومات تلاش کرنے اور متعلقہ ڈیٹا کو نکالنے کے لیے کیا جاتا ہے۔
A. FETCH
B. LET
C. VLOOKUP
D. GET
Explanation
The VLOOKUP is used when data is listed in columns.
This function searches for a value in the left-most column
You can use VLOOKUP to find data in a sorted or unsorted table .
VLOOKUP stands for Vertical Lookup function
Show/Hide Explanation
کون سی کلید جدول میں ہر ریکارڈ کی منفرد شناخت کرتی ہے۔
A. Alternate key
B. Composite key
C. Foreign key
D. Primary key
Explanation
Primary Key - a field containing a value that uniquely identifies each record in a table.
Show/Hide Explanation
ایکسل ڈیٹا کس سیریز میں ہے؟
A. A row or column of numbers that are plotted in a chart
B. Spreed sheet
C. None
D. Work sheet
Explanation
In Excel, a Data Series is defined as a collection of related data.
Show/Hide Explanation
ایم ایس ایکسل میں چارٹس میں کون سا آپشن دستیاب نہیں ہے؟
A. Volume
B. Line
C. Pie
D. Bar
Explanation
MS Excel offers various chart types, including:
Line charts Pie charts Bar charts However, " Volume " is not a chart type in MS Excel.
Volume is a measure of the amount of three-dimensional space enclosed by a container or a shape, and is not a chart type.
Show/Hide Explanation
✅ Correct: 0 |
❌ Wrong: 0 |
📊 Total Attempted: 0
