Which of the following is not a valid formula?
A) =D3
B) =2*2
C) =sum(1,2,3,4,5)
D) =#12 / 31 / 2018#-#12 / 31 / 2019#

Name: Which of the following is not a valid formula? A) =D3 B) =2*2 C) =sum(1,2,3,4,5) D) =#12 / 31 / 2018#-#12 / 31 / 2019#
Brand: Quizplus
Rating: 4.9 (36 reviews)

Question

Quizplus · Accepted Answer

The formula in option D is not valid because it uses an incorrect syntax for date subtraction. In Excel, dates should be enclosed in double quotes and use the DATE function or be formatted as serial numbers for arithmetic operations.

Which of the Following Is Not a Valid Formula