Exam 1: Excel Functions and Features

To convert uppercase alphabets to lowercase we use _____

15-August-2020 was Saturday. Answer of =WEEKDAY("15-August-2020") will be_____

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?

Solver Option is available under ____ Ribbon/Menu.

Answer of =DAYS360("31-Dec-2020", "1-Jan-2020") will be ________

Charts are available under _______ Ribbon/Menu.

15-August-2020 was Saturday. Answer of =YEAR("15-August-2020") will be ________

Select odd man out from the following graph types.

Axis Title is not allowed in this type of graphs.

TODAY( ) returns current ______

Answer of =TIMEVALUE("6:00 PM") will be ________

Goal Seek Option is available under ____ Ribbon/Menu.

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT("A2")?

Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?

To search a value in the first row of a given range, we use _______.

Number of changing cells for a Scenario is limited to ____

15-August-2020 was Saturday. Answer of =MONTH("15-August-2020") will be ________

To count non blank cells, we use _____.

Which of the following is not a valid chart type in Excel.

Record Macro option is available under ____ Ribbon/Menu.