Excel Skill Assessment
Quizack provides Excel MCQ practice question answers in an interactive format.
Excel MCQ
Learn and practice your skills with our MCQ question answers to improve your knowledge. MCQs list
Start Practice with MCQsExcel Online Quiz
Quizack 10 minutes test will assess your knowledge and give you comprehensive results along feedback.
Start QuizExcel PDF Download
Download Free Excel MCQ questions answers PDF to practice and learn while are offline.
Download PDF
Used by 100s of Jobseekers and students
Focused questions for skill assessment
Premium questions with correct answers
Related Skill Assessment
Free Sample Questions for Excel
What formula generates a fractional number that is greater than 0 and less than 1?
=RAND()
=RANDBETWEEN(0,1)
=RANDOM(0,1)
=VARIABLE(0,1)
Answer:
Which of the following formulas yields the work hours between dates on a custom schedule?
{=SUM(CHOOSE(WEKDAY(ROW(INDIRECT(date1&":"&date2)),1,2,3,4,5,6,7))}
{=SUM(CHOOSE(WEEKDAY(ROW(INDIRECT(date1":"date2))),1,2,3,4,5,6,7))}
{=SUM(CHOOSE(WEEKDAY(ROW(INDIRECT(date1&":"&date2))),1,2,3,4,5,6,7))}
{=SUM(CHOOSE(WEEKDAY(ROW(INDIRECT(date1&";"&date2)),1,2,3,4,5,6,7))}
Answer:
{=SUM(CHOOSE(WEEKDAY(ROW(INDIRECT(date1&":"&date2))),1,2,3,4,5,6,7))}
Enterprise Resource Planning (ERP) 
QUIZACK
