Question
Download Solution PDFWhich formula should be entered in cell C2 to multiply the values of cells A2 and B2 in Excel?
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe correct answer is Option 3) =A2*B2.
Key Points
- To multiply values in Excel, use the asterisk symbol (
*
). - Formula
=A2*B2
multiplies the value in cell A2 by the value in cell B2. - Excel does not have a built-in
MULTIPLY()
function for worksheets; multiplication is done using*
.
Additional Information
- Option 1 – =A2+B2: Adds the values, not multiplies.
- Option 2 – =MULTIPLY(A2,B2): Invalid in Excel; no such function exists.
- Option 4 – =A2-B2: Subtracts B2 from A2.
- To divide: use
=A2/B2
; to add: use=A2+B2
; to subtract: use=A2-B2
.
Last updated on Jun 7, 2025
-> RRB JE CBT 2 answer key 2025 for June 4 exam has been released at the official website.
-> Check Your Marks via RRB JE CBT 2 Rank Calculator 2025
-> RRB JE CBT 2 admit card 2025 has been released.
-> RRB JE CBT 2 city intimation slip 2025 for June 4 exam has been released at the official website.
-> RRB JE CBT 2 Cancelled Shift Exam 2025 will be conducted on June 4, 2025 in offline mode.
-> RRB JE CBT 2 Exam Analysis 2025 is Out, Candidates analysis their exam according to Shift 1 and 2 Questions and Answers.
-> The RRB JE Notification 2024 was released for 7951 vacancies for various posts of Junior Engineer, Depot Material Superintendent, Chemical & Metallurgical Assistant, Chemical Supervisor (Research) and Metallurgical Supervisor (Research).
-> The selection process includes CBT 1, CBT 2, and Document Verification & Medical Test.
-> The candidates who will be selected will get an approximate salary range between Rs. 13,500 to Rs. 38,425.
-> Attempt RRB JE Free Current Affairs Mock Test here
-> Enhance your preparation with the RRB JE Previous Year Papers.