-
A. =SUM(C1:C12)
-
B. None of these
-
C. =TOTAL(C1:C12)
-
D. =SUM(C1 + C12)
Explanation
=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.
The colon : denotes a continuous range of cells.
-
A. 42
-
B. 360
-
C. 325
-
D. None of these
Explanation
Let's calculate:
F7 = 12
H12 = 30
Formula: F7 * H12 = 12 * 30 = 360
اف فنکشن ایکسل میں کس لیے استعمال ہوتا ہے؟
-
A. None of these
-
B. Performing logical comparisons
-
C. Creating charts
-
D. Formatting text
Explanation
- The IF function checks a condition and returns different values based on TRUE or FALSE.
- Example:
=IF(A1>50, "Pass", "Fail") (Returns "Pass" if A1 is greater than 50, otherwise "Fail").
ایم ایس ایکسل میں ، _____ فنکشن کسی تعداد کے مربع جڑ کا حساب لگاتا ہے۔
-
A. SQUARE
-
B. SQR
-
C. SQRT
-
D. None of these
Explanation
In MS Excel, the SQRT(number) function is used to calculate the square root of a given number.
Example: =SQRT(25) will return 5.
ایکسل میں تقسیم کے لئے کون سی علامت استعمال کی جاتی ہے؟
Explanation
In Microsoft Excel, the divide symbol is a forward slash (/).
-
A. TODAY()
-
B. DATE()
-
C. NOW()
-
D. CURRENT_DATE()
Explanation
To insert the current date into an Excel cell, use the TODAY() function.
Simply type =TODAY() in the cell and press Enter.
-
A. Filter in data tab
-
B. Sort in review tab
-
C. Sort 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).
***
ایک ورک بک ابتدائی طور پر ________ ورک شیٹس پر مشتمل ہوتی ہے، جو ایک فائل میں محفوظ ہوتی ہیں۔
-
A. One
-
B. Three
-
C. Five
-
D. Four
Explanation
A Workbook is a group of Worksheets.
A workbook is a file that contains one or more worksheets to help you organize data.
A workbook initially contains three worksheets, which are saved in a single file.
1. Sheet1
2. Sheet2
3. Sheet3
-
A. Rows
-
B. Columns
-
C. None of these
-
D. Worksheets
Explanation
A Workbook is a group of Worksheets.
A workbook is a file that contains one or more worksheets to help you organize data.
A workbook initially contains three worksheets, which are saved in a single file.
1. Sheet1
2. Sheet2
3. Sheet3
-
A. Enter assumptions data
-
B. Format cells containing numbers
-
C. Create and edit formula containing functions
-
D. none
Explanation
Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell.
✅ Correct: 0 |
❌ Wrong: 0 |
📊 Total Attempted: 0
