Basic & Advanced MS Excel Interview Questions and Answers
1) What is Microsoft Excel?
2) What is ribbon?
3) Explain Spreadsheet and its Basics.
4) How many data formats are available in Excel? Name some of them.
5) Specify the order of operations used for evaluating formulas in Excel.
6) How can you wrap the text within a cell?
7) Explain Macro in MS-Excel.
8) Which are the two macro languages in MS-Excel?
9) Is it possible to prevent someone from copying the cell from your worksheet?
10) What are charts in MS-Excel?
11) How can you sum up the Rows and Column number quickly in the Excel sheet?
12) Explain few useful functions in Excel.
13) What does a red triangle at the top right of a cell indicate?
14) How can you add a new Excel worksheet?
15) What is the use of NameBox in MS-Excel?
16) How can you resize the column?
17) Explain pivot tables and its uses.
18) What are three report formats that are available in Excel?
19) How would you provide a Dynamic range in “Data Source” of Pivot Tables?
20) Is it possible to make Pivot table using multiple sources of data?
21) Which event do you use to check whether the Pivot Table is modified or not?
22) How can you disable automatic sorting in pivot tables?
23) What is Freeze Panes in MS-Excel?
24) What could you do to stop the pivot table from loosing the column width upon refreshing?
25) Explain workbook protection types in Excel.
26) Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel?
27) Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel.
28) What is IF function in Excel?
29) Can we create shortcuts to Excel functions?
30) What is the use of LOOKUP function in Excel?
31) How can you apply the same formatting to every sheet in a workbook in MS-Excel?
32) What are left, right, fill and distributed alignments?
33) To move to the previous worksheet and next sheet, what keys will you press?
34) What filter will you use, if you want more than two conditions or if you want to analyze the list
using database function?
35) What is the quick way to return to a particular area of a worksheet?
36) Which function is used to determine the day of the week for a date?
37) What is the benefit of using formula in Excel sheet?
38) What is the “What If” condition in Excel formulas?
39) How can you disable the automating sorting in pivot tables?
40) What is the AND function does in Excel?
41) How cell reference is useful in the calculation?
Excel Competency Exam Practice Test
1. The AutoAdd function adds up numbers in a column or row you
specify.
a) True
b) False
2. "AAA" is an example of a ____ in Excel.
a) cell reference
b) column heading
c) name box
d) row heading
3. _______ quickly highlight(s) important information in a spreadsheet that match your
criteria by applying formatting options, data bars, color scales, or icon sets.
a) cell references
b) conditional formatting
c) Excel tables
d) pivot tables
4. The best formula to calculate Profits for January is:
a) =SUM(B2:B3)
b) =B2-B3
c) =B4-(B2+B3)
d) =A4-(A2+A3)
e) =SUBTRACT(B2:B3)
5. The best formula to calculate the Average for Profits is:
a) =(B4+C4+D4)/3
b) =MEAN(B4:E4)
c) =AVERAGE(B4:D4)
d) =AVERAGE(B4:E4)
6. As a general rule, Excel will _____-align numbers.
a) right
b) left
c) top
d) bottom
7. Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?
a) =C1+C2
b) =$C1+$C2
c) =D2+D3
d) =E6+E7
8. When you copy a formula that contains an absolute reference to a new location, the reference
____.
a) is updated automatically
b) does not change
c) becomes bold
d) has a dotted outline in its cell
9. Which of the following is a logical function?
a) AVERAGE
b) IF
c) SUMPRODUCT
d) VLOOKUP
10. The image above shows a:
a) Column chart
b) Bar graph
c) Line Chart
d) Pie Chart
11. Excel will reference the chart’s data source above as:
a) A1:B7
b) $A1:B7$
c) A$1:$B7
d) $A$1:$B$7
12. The words "Pre-sales" and “Conference Attendance” in the image above are called the chart
______:
a) accent
b) key
c) labels
d) legend
13. ____ order arranges content in reverse alphabetical order, from Z to
A.
a) Reverse
b) Major
c) Ascending
d) Descending
14. _______ are a powerful tool to quickly group, summarize, and rearrange larger
datasets.
a) Cell references
b) Functions
c) Pivot tables
d) Ranges
15. Selecting the “Food” button on the slicer on the right will mean that the data table on the left
will: a) Show items that match “Food” only.
b) Show items that match everything except for “Food”.
c) Not be impacted by the “Food” slicer at all.
d) All of the above.
16. A worksheet ____ is a collection of two or more selected
worksheets.
a) index
b) roster
c) group
d) cluster
17. A reference that refers to the same cell or range on multiple sheets is called a(n)
__________ reference.
a) 3-D
b) Clustered
c) Indexed
d) Pivotal
18. A(n) _______________ helps automate repetitive tasks in Excel by recording your
steps.
a) formula
b) macro
c) solver
d) process
19. You can use data ___________ to restrict the type of data or the values that users enter into a
cell.
a) auditing
b) checking
c) tracking
d) validation
20. The ______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE
if all of its arguments evaluate to FALSE.
a) AND
b) OR
c) SOME
d) LOOKUP
21. To determine the number of sales people by region who have 50 or more orders, we use
the: a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTIFS
22. _____________ calculates the payment for a loan based on constant payments and a
constant interest rate.
a) CPMT
b) LOAN
c) PMT
d) PPMT
23. A ________ analysis is the process of changing the values in cells to see how those changes
will affect the outcome of formulas on the worksheet.
a) Change
b) Performance
c) Pivotal
d) What-if
24. Returns the number of characters you specify from the right side of a
string.
a) CHAR
b) LEN
c) RIGHT
d) RSTRING
25. Removes all spaces from text except for single spaces between
words.
a) CODE
b) CLEAN
c) TRIM
d) SUBSTITUTE
