I am building an ODK excel sheet(xls form) from scratch and am at a point where I need the sheet to do a calculate score command. I have many questions and each question has its various answers where only one answer is the correct one (which means the right answer is the '1'). Let's say I have 10 questions which means 10 marks and all have various answers unlike the just YES ns No answers. If all are answered, what is the calculate command on how it can calculate so that it will pick only the right answer as 1 point (marks out of 10)?

In addition, I know the YES and NO questions can easily appear as a table-list. In the case of my dilemma, how will these questions with many answers appear. will they still appear as a table or differently? Please advise.

Short answer: experiment and play around to find a solution that works for
you.

Note that the choice values for a select one and select multiple question
are considered to be strings, not integers (i.e., the string "1", not the
integer number 1).

useful, and you might convert those right answers into 1's and wrong
answers into 0's with:

if( selected(${fieldname}, 'rightAnswer'), 1, 0)

ยทยทยท
------------
As for the various layouts, unless you explicitly group things, each
question will appear on a separate screen. See
https://opendatakit.org/help/form-design/examples/ for the available
widgets.

I am building an ODK excel sheet(xls form) from scratch and am at a point
where I need the sheet to do a calculate score command. I have many
questions and each question has its various answers where only one answer
is the correct one (which means the right answer is the '1'). Let's say I
have 10 questions which means 10 marks and all have various answers unlike
the just YES ns No answers. If all are answered, what is the calculate
command on how it can calculate so that it will pick only the right answer
as 1 point (marks out of 10)?

In addition, I know the YES and NO questions can easily appear as a
table-list. In the case of my dilemma, how will these questions with many
answers appear. will they still appear as a table or differently? Please
advise.