Question 1

15-August-2020 was Saturday. Answer of =WEEKDAY("15-August-2020") will be_____
A)saturday
B)sat
C)7
D)6

Accepted Answer

The WEEKDAY function in Excel returns a number representing the day of the week, where 1 is Sunday and 7 is Saturday.

Question 2

15-August-2020 was Saturday. Answer of =MONTH("15-August-2020") will be ________
A)august
B)aug
C)8
D)7

Accepted Answer

The MONTH function in Excel returns the month of a date as a number between 1 (January) and 12 (December). For the date "15-August-2020", the function will return 8, as August is the 8th month of the year.

Question 3

15-August-2020 was Saturday. Answer of =YEAR("15-August-2020") will be ________
A)2020
B)1920
C)20
D)2200

Accepted Answer

The function =YEAR("15-August-2020") extracts the year part from the given date, which is 2020.

Question 4

Answer of =DAYS360("1-Jan-2020", "31-Dec-2020") will be ________
A)365
B)366
C)360
D)364

Accepted Answer

The DAYS360 function calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is common in accounting calculations. Therefore, from January 1, 2020, to December 31, 2020, it counts as 360 days.

Question 5

Answer of =YEAR("15-Aug-20") will be
A)20
B)2020
C)1920
D)2200

Accepted Answer

The YEAR function in Excel returns the year part of a date as a four-digit number. For the date "15-Aug-20", Excel interprets the year "20" as "2020" according to the 1900 date system, which is commonly used in Excel.

Question 6

Answer of =TIMEVALUE("6:00 PM") will be ________
A)6:00
B)6:00 am
C)18:00
D)0.75

Accepted Answer

The TIMEVALUE function in Excel converts a time in the form of text to a serial number that Excel recognizes as a time. Since Excel stores dates and times as serial numbers, where 1 represents a full day, the time "6:00 PM" translates to 0.75 of a day (since 6:00 PM is three-quarters of the way through a 24-hour day).

Question 7

TODAY( ) returns current ______
A)date
B)time
C)day
D)date & time

Accepted Answer

The TODAY() function returns the current date.

Question 8

Answer of =DAYS360("31-Dec-2020", "1-Jan-2020") will be ________
A)365
B)366
C)360
D)-360

Accepted Answer

The DAYS360 function calculates the number of days between two dates based on a 360-day year (used in some financial calculations), and since the start date is after the end date in this case, the result is negative, hence -360.

Question 9

To convert uppercase alphabets to lowercase we use _____
A)lcase( )
B)lower( )
C)upper( )
D)ucase( )

Accepted Answer

The function lower() is used to convert uppercase alphabets to lowercase in various programming languages such as Python and SQL.

Question 10

To find number of characters in a string we use _____
A)count( )
B)len( )
C)length( )
D)sum( )

Accepted Answer

The len() function is used in Python to find the number of characters in a string.

Question 11

To search a value in the first row of a given range, we use _______.
A)vllokup( )
B)hlookup( )
C)search( )
D)locate( )

Accepted Answer

HLOOKUP function is used to search for a value in the first row of a table or range and returns a value in the same column from a specified row.

Question 12

To count non blank cells, we use _____.
A)count( )
B)counta( )
C)countblank( )
D)countnonblank( )

Accepted Answer

The COUNTA function is used to count the number of non-blank cells in a range.

Question 13

To count number of cells that contains numbers, we use _____.
A)count( )
B)counta( )
C)sum( )
D)countif( )

Accepted Answer

The COUNT function is used to count the number of cells that contain numbers in a range.

Question 14

Which of the following is not a valid chart type in Excel.
A)line
B)bar
C)pie
D)graph

Accepted Answer

In Excel, "graph" is not a specific chart type. Instead, Excel offers specific chart types such as line, bar, and pie, among others. "Graph" is a general term that can refer to various types of charts, but it is not recognized as a distinct chart type within Excel.

Question 15

Axis Title is not allowed in this type of graphs.
A)line
B)bar
C)column
D)pie

Accepted Answer

Pie charts typically do not have axis titles because they display data in a circular format without the traditional x and y axes found in other chart types like line, bar, and column graphs. Axis titles are used to label these axes, which are not present in pie charts.

Question 16

Select odd man out from the following graph types.
A)line
B)bar
C)column
D)pie

Accepted Answer

Pie charts are different from line, bar, and column charts because they show parts of a whole as slices of a pie, whereas the others compare values along axes.

Question 17

Charts are available under _______ Ribbon/Menu.
A)home
B)insert
C)data
D)view

Accepted Answer

Charts are available under the Insert Ribbon/Menu.

Question 18

Goal Seek Option is available under ____ Ribbon/Menu.
A)home
B)insert
C)data
D)view

Accepted Answer

The Goal Seek option is available under the Data ribbon/menu in Excel, which is used for performing what-if analysis.

Question 19

Number of changing cells for a Scenario is limited to ____
A)16
B)32
C)1
D)2

Accepted Answer

In Excel, the number of changing cells (variables) you can use in a Solver model is limited to 32. This limitation is specific to the Solver add-in, which is used for optimization problems.

Question 20

Number of changing cells for a Goal Seek is limited to ______
A)16
B)32
C)1
D)2

Accepted Answer

Goal Seek in Excel is designed to find a single input value that will achieve a desired result for a formula, thus it can only change one cell at a time.

Quiz 1: Excel Functions and Features

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

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

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

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

Answer of =YEAR("15-Aug-20") will be

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

TODAY( ) returns current ______

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

To convert uppercase alphabets to lowercase we use _____

To find number of characters in a string we use _____

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

To count non blank cells, we use _____.

To count number of cells that contains numbers, we use _____.

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

Axis Title is not allowed in this type of graphs.

Select odd man out from the following graph types.

Charts are available under _______ Ribbon/Menu.

Goal Seek Option is available under ____ Ribbon/Menu.

Number of changing cells for a Scenario is limited to ____

Number of changing cells for a Goal Seek is limited to ______