Check Your Knowledge

 (1) What is the result of the formula =SUMPRODUCT ({1, 2, 3}, {4, 5, 6})  in Excel?

Answer is on the last page

excelguruji.in

 (2) What will be the result of the formula shown in the image below?

Answer is on the last page

Woman Reading

Check Your Knowledge

excelguruji.in

 (3) What action in Microsoft Excel is performed using the keyboard shortcut 'Ctrl + Shift + :'

Answer is on the last page

Books

Check Your Knowledge

excelguruji.in

 (4) What is the maximum number of rows in an Excel worksheet?

Answer is on the last page

Woman Reading 02

Check Your Knowledge

excelguruji.in

 (5) What will be the result of the formula shown in the image below?

Answer is on the last page

Check Your Knowledge

excelguruji.in

 (6) Which function allows you to return the current date in a cell?

Answer is on the last page

Check Your Knowledge

excelguruji.in

 (7) What is the correct value of the function? =ROUND(123.123,-2)

Answer is on the last page

Check Your Knowledge

excelguruji.in

Answers

32

14

1,048,576

Inserting current time into a cell

25-09-2023 11:00

1.

2.

3.

4.

5.

Today()

100

6.

7.

Visit our website for Free Online test

Check Your Knowledge