In this article, you will find 50 MS Excel objective questions and answers in PDF format. Most of the questions are very basic. As a result, anyone with a basic understanding of Excel will be able to answer the questions. These questions will be helpful for job examinations. Moreover, you should know the following: introduction to Excel VBA, enable the Developer tab, the basics of an Excel spreadsheet, use of the INDEXMATCH formula, application of the AGGREGATE, AVERAGE, AVERAGEIF, CEILING.MATH, COUNT, COUNTBLANK, IF, IFS, COUNTIF, COUNTA, COUNTIFS, DATEDIF, DAY, FIND, IFERROR, LEN, MROUND, RAND, RANDBETWEEN, ROW, ROWS, SUM, SUMIF, TODAY, VLOOKUP, and XLOOKUP functions to solve them. You should use at least Excel 2019 to solve the problems without any issues.
Download Practice Workbook
You can download the PDF & Excel files by giving your valid Email Address only:
Problem Overview
The Excel and PDF files each contain fifty MS Excel objective questions and answers in PDF format. The questions are provided in the “Problem” sheet. Additionally, the answers are highlighted in the “Solution” sheet. We can see a snapshot of the sample dataset for this article below. This dataset represents the sales achieved by twenty employees for a particular company.
Let’s go through the objective questions.
 Q1. Which Function can be used to Find the Number of Females?

 COUNTIFS

 COUNTIF

 COUNT

 Both a & b
 Q2. The function to find the highest sales value is –

 MAX

 MAXIMUM

 AGGREGATE

 Both a & c
 Q3. The total value of sales for the male employees can be calculated by using –

 SUMIF

 IFS

 MAX

 INDEXMATCH
 Q4. To find the employee who generated the most sales, you will use the following formula –

 =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,0))

 =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,1))

 =INDEX(B5:B24,MAX(F5:F24),0)

 =INDEX(B5:B24,MATCH(MAX(F5:F24),F5:F24,1))
 Q5. To find the distinct job position names, you can use –

 AGGREGATE

 UNIQUE

 Combination of IFERROR, INDEX, MATCH

 Both b & c
 Q6. To determine the total number of characters in the employee names, you can use the function named –

 LENGTH

 LEN

 LENB

 STRINGLENGTH
 Q7. To extract the day value from the Date Joined column, which of the following features can be used?

 DAY Function

 Insert an adjacent helper column and use Flash Fill

 LEFT Function

 Both a,b & c
 Q8. Which function can be used to determine the number of empty cells in the dataset?

 COUNT

 COUNTA

 COUNTEMPTY

 COUNTBLANK
 Q9. Using which function from the list you can return a random name –

 =INDEX(B5:B24,MATCH(RANDBETWEEN(1,20),B5:B24,0))

 =INDEX(B5:B24,RANDBETWEEN(1,20))

 =INDEX(B6:B25,RAND())

 =INDEX(B6:B25,RAND(20))
 Q10. To create a Pie Chart using the Position column, you will –

 Select the cell range D5:D24 and select Pie Chart from the Insert tab.

 Select the cell range D5:D24 and select Recommended Chart from the Insert tab, and then select the Pie Chart.

 Find the unique values and their instances and then create a Pie Chart.

 None of these.
 Q11. To determine the number of sales greater than $100,000 AND dates joined after 30th April, the following formula needs to be used –

 =COUNTIFS(F5:F24,”>100000″,E5:E24,”>44681″)

 =COUNTIF(F5:F24,”>100000″)+COUNTIF(E5:E24,”>44681″)

 Both a & b

 None of these
 Q12. To determine the number of sales greater than $100,000 OR dates joined after 30th April, the following formula needs to be used –

 =COUNTIFS(F5:F24,”>100000″,E5:E24,”>44681″)

 =COUNTIF(F5:F24,”>100000″)+COUNTIF(E5:E24,”>44681″)

 Both a & b

 None of these
 Q13. To calculate the average sales by the male employees, the following formula need to be used –

 =AVERAGEIF(C5:C24,”Male”,F5:F24)

 =AVERAGEIFS(C5:C24,”Male”,F5:F24)

 =IF(C5:C24=”Male”,AVERAGE(F5:F24),””)

 =MEANIF(C5:C24,”Male”,F5:F24)
 Q14. To find the arithmetic mean, you can use the following function –

 MEAN

 AVERAGE

 GEOMEAN

 MIDPOINT
 Q15. Shortcut to find the total of some numbers is –

 Alt+=

 Ctrl+=

 Shift+=

 Ctrl+Alt+=
 Q16. To insert chart from a data selection, you will need to press –

 F5

 F7

 F11

 F2
 Q17. To open the Spelling dialog box, you need to press –

 F5

 F7

 F11

 F2
 Q18. To bring up the custom cell Formatting press –

 Ctrl+1

 Ctrl+2

 Ctrl+3

 Ctrl+4
 Q19. To repeat the previous action, you will need to press on –

 F5

 F4

 F7

 F3
 Q20. The latest version of Microsoft Office is called –

 Excel 366

 Microsoft 365

 Excel 2023

 Office 365
 Q21. The following shortcut key will open the Find and Replace dialog box, and activate the Replace tab –

 Ctrl+H

 Ctrl+R

 Ctrl+F

 Alt+F
 Q22. To return value from the left side of the matched value, we can use –

 VLOOKUP Function

 Combination of VLOOKUP and IF Functions

 HLOOKUP Function

 ZLOOKUP Function
 Q23. Which formula is correct for returning the name of the salesperson for the $25,010 sales?

 =VLOOKUP(F5,IF({1,0},F5:F24,B5:B24),2,0)

 =ZLOOKUP(F5,F5:F24,B5:B24)

 =XLOOKUP(F6,F5:F24,B5:B24)

 Both a&c
 Q24. The cell C15 is empty and F15 is $135,430. So, the output of =C15*F15 is –

 $135,430

 0

 #VALUE!

 #DIV/0
 Q25. Different types of Font Formatting are available in the –

 Home Tab

 Insert Tab

 Data Tab

 Format Tab
 Q26. There x number of functions inside the AGGREGATE Function, here the value of x is –

 17

 18

 19

 21
 Q27. The maximum number of rows and columns in Excel are –

 1,048,576 columns and 16,384 rows

 1,048,576 rows and 16,384 columns

 256 columns and 65,536 rows

 None of these
 Q28. The last column in Excel is –

 XFA

 XFB

 XFC

 XFD
 Q29. The first version of Excel is released in –

 1982

 1985

 1987

 1989
 Q30. Which of the following functions will you use to determine the number of values in the Sales column?

 NUM

 NUMBER

 COUNT

 None of these
 Q31. Microsoft Excel is the most popular spreadsheet program in the world. Which of the following is the first spreadsheet program?

 Microsoft Excel

 Lotus 123

 VisiCalc

 SuperCalc
 Q32. If you want show the current date with time, you can use –

 =NOW()

 =TODAY()

 Both

 None of these
 Q33. The difference between the SEARCH and FIND function is –

 The FIND function is case sensitive and the SEARCH function is not.

 The SEARCH function is case sensitive and the FIND function is not.

 There is no difference between them, only for compatibility, both are listed.

 None of these.
 Q34. The following function is not available in the VBA WorksheetFunction method

 IF

 COUNTIF

 SUM

 COUNTA
 Q35. If there is a Red triangle in the top right corner of the cell, then it signifies –

 There is a note in that cell.

 The cell is formatted as text.

 There is an error on that cell.

 There is a circular reference.
 Q36. If there is a Green triangle in the top left corner of the cell, then it signifies –

 There is a note in that cell.

 The cell is formatted as a number.

 There is an error on that cell.

 There is a circular reference.
 Q37. You will press the following shortcut to bring up the VBA window –

 Alt+F8

 Alt+F9

 Alt+F11

 Alt+F7
 Q38. Which of the formulas will you use to round up the sales figure from cell F17 to the nearest thousand?

 =MROUND(F17,1000)

 =FLOOR.MATH(F17,1000)

 =CEILING.MATH(F17,1000)

 =ROUNDUP(F17,1000)
 Q39. You can assign sequential serial number (1,2,3, etc.) to the rows by using the formula and AutoFill –

 =ROWS($B$5:B5)

 =ROWS(B5)

 =ROW(B5)3

 Both a&c
 Q40. Which of the following are not valid Excel functions –

 NUM

 MEAN

 TRUE

 Both a&b
 Q41. In the VBA Cells function, the argument is Cells (x, y), which means –

 x = row number, y = column number

 x = column number, y = row number

 x = row index y = column index

 x = column index, y = row index
 Q42. The maximum height of a row is

 409.5 Units

 403.5 Units

 410 Units

 412 Units
 Q43. You can copy a cell by using the shortcut –

 Ctrl+P

 Ctrl+V

 Ctrl+C

 Ctrl+X
 Q44. Which of the following functions is available but not shown in Excel Tooltip?

 DATEVALUE

 DATEDIF

 KLOOKUP

 MEAN
 Q45. Which of the following is an absolute cell reference?

 F15

 F$15

 $F$15

 $F15
 Q46. Which of the following is a mixed cell reference?

 F15

 $F$16

 $F$15

 $F15
 Q47. When you move your cursor to the bottom right corner of a cell, it turns into a plus (+) sign. This icon is known as –

 AutoFill Tool

 Fill Handle

 Fill Tool

 Drag Handle
 Q48. If you select a range of cells and type something, then pressing a specific shortcut will copy the value to the selected range. Now, that shortcut key is –

 Shift+Enter

 Ctrl+Enter

 Alt+Enter

 None of these
 Q49. If there is a VBA code in your Excel file, then you should save the file as ____ format –

 .xlsx

 .xls

 .xlsm

 .csv
 Q50. Google has developed their own spreadsheet program, which is known as –

 Sheets

 Docs

 Spreadsheet

 Slides
The image below depicts the first five solutions to the objective questions. So, this concludes the article on the topic MS Excel objective questions and answers PDF”.
Download Practice Workbook
You can download the PDF & Excel files by giving your valid Email Address only:
Conclusion
Thank you for reading this article. By completing this article, we hope that you have gained knowledge about MS Excel objective questions and answers in PDF format. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!
Get FREE Advanced Excel Exercises with Solutions!