Asked in PPSC, FPSC and other one-paper exams (compiled from unofficial resources).

Which of the following formulas will MS-Excel 2016 not be able to calculate?

A.=SUM(A1:A5)-10
B.=SUM(A1:A5)*.5
C.=SUM(A1:A5)/(10-10)
D.=SUM(Sales)-A3Correct answer

Timed quizzes, instant results, track your progress — free

Quick fact: MS-Excel 2016 cannot calculate =SUM(Sales)-A3 because "Sales" is an undefined named range or text string that cannot be interpreted as a numeric range by the SUM function.

Related MCQs

Which feature in MS Excel is used for organizing data in ascending or descending order?
In Microsoft Excel, what do the letters at the top of the spreadsheet represent?
What is a group of cells called in Microsoft Excel?
In Excel, what is a data series?
In MS Excel 2016, which option is used to split the window into two panes?
Which program in Microsoft Office is used for creating spreadsheets?
Which button in MS Excel is used to quickly sum a series of numbers?
What symbol is used in Excel to include all cells between two cell references?

Which of the following formulas will MS-Excel 2016 not be able to calculate?

Related MCQs

Subjects

Exams

Platform

Legal