MS Excel

high importance⚡ 11 shortcuts4 subtopics

Exam-level questions worked step by step. Try each one yourself first — then expand the solution and compare routes.

Q1.

Cells A1:A5 contain: 72, Fail, 85, (blank), 90. What does =COUNT(A1:A5) return?

Q2.

Cell A1 contains 72. The formula =IF(A1>50,"Pass","Fail") displays:

Q3.

B1 contains the formula =$A$1*2 and is copied to B2. B2 will contain:

Q4.

Which error results from =A1/B1 when B1 is empty?

Q5.

How many rows and columns does an Excel 2019 worksheet have?