-
A. Column number
-
B. None of these
-
C. Cell address
-
D. Row number
Explanation
In MS Excel, letters (like B) represent columns, while numbers (like 3) represent rows.
So, in cell address B3, B is the column number, and 3 is the row number.
-
A. Active cell
-
B. Cell
-
C. Range
-
D. Cell address
Explanation
A cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.
Cell Address is also known as Cell Reference.
AGM 24-12-2022
مندرجہ ذیل میں سے کون سا بیانات کسی ڈیٹا بیس یا اسپریڈشیٹ میں کالموں اور قطاروں کو شامل کرنے/حذف کرنے کے بارے میں درست ہے؟
-
A. You cannot add new columns or rows
-
B. You can add columns/rows but cannot delete them
-
C. None of these
-
D. You can add and delete columns/rows as needed
Explanation
Most databases and spreadsheets (like Excel or Google Sheets) allow users to freely add or delete rows and columns.
This flexibility helps in updating or organizing data as per requirements.
آپ ایک کالم کو 2 یا زیادہ کالموں میں کیسے تقسیم کر سکتے ہیں؟
-
A. Select the cell that you want to split. Then, navigate to the Data Tab, after that, select Text to Column.
-
B. Select the cell that you want to split. Then, navigate to the Insert Tab, after that, select Text to Column.
-
C. Select the cell that you want to split. Then, navigate to the Design Tab, after that, select Text to Column.
-
D. Select the cell that you want to split. Then, navigate to the Home 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".
ایکسل میں حروف اشارہ کرتے ہیں
-
A. Columns
-
B. reference
-
C. rows
-
D. numbers
Explanation
By default, Excel uses the A1 reference style,
which refers to columns as letters
and refers to rows as numbers
These letters and numbers are called row and column headings.
Type the column letter followed by the row number.
✅ Correct: 0 |
❌ Wrong: 0 |
📊 Total Attempted: 0