Excel quiz for Job Interview quiz bank 2024

Excel quiz bank for job interview 2024

Beginner’s Excel Quiz:

 

1. What is the keyboard shortcut to paste content from the clipboard in Excel?

  1. A) Ctrl + C
  2. B) Ctrl + V
  3. C) Ctrl + X
  4. D) Ctrl + P

Correct answer: B) Ctrl + V

 

2. Which function is used to add numbers in a range in Excel?

  1. A) =SUM()
  2. B) =ADD()
  3. C) =TOTAL()
  4. D) =COUNT()

Correct answer: A) =SUM()

 

3. What is the maximum number of rows in an Excel worksheet?

  1. A) 256
  2. B) 512
  3. C) 1024
  4. D) 1,048,576

Correct answer: D) 1,048,576

 

4. Which Excel feature is used to display a preview of how your data will look when printed?

  1. A) Print Preview
  2. B) Page Layout
  3. C) Print Options
  4. D) Quick Print

Correct answer: A) Print Preview

 

5. Which chart type is best suited for showing trends over time?

  1. A) Pie Chart
  2. B) Bar Chart
  3. C) Line Chart
  4. D) Scatter Plot

Correct answer: C) Line Chart

 

6. What does the function =AVERAGE(A1:A10) do in Excel?

  1. A) Finds the total of cells A1 to A10
  2. B) Counts the number of cells in the range A1 to A10
  3. C) Finds the highest value in the range A1 to A10
  4. D) Calculates the average of values in cells A1 to A10

Correct answer: D) Calculates the average of values in cells A1 to A10

 

7. Which symbol is used to begin a formula in Excel?

  1. A) @
  2. B) =
  3. C) $
  4. D) #

Correct answer: B) =

 

8. What is the function of the CONCATENATE function in Excel?

  1. A) To split text into separate cells
  2. B) To combine multiple cells into one cell
  3. C) To count the number of characters in a cell
  4. D) To format text in bold

Correct answer: B) To combine multiple cells into one cell

 

9. Which Excel feature allows you to freeze rows and columns to keep them visible while scrolling?

  1. A) Split
  2. B) Freeze Panes
  3. C) Lock Cells
  4. D) Protect Sheet

Correct answer: B) Freeze Panes

 

10. Which keyboard shortcut is used to autosum selected cells in Excel?

  1. A) Alt + =
  2. B) Ctrl + S
  3. C) Shift + S
  4. D) Alt + S

Correct answer: A) Alt + =  

Excel Quiz Bank

 

11. How can you add a new worksheet in Excel?

  1. A) Right-click on the sheet tab and select “Insert”
  2. B) Go to File > New > Worksheet
  3. C) Use the shortcut Ctrl + A
  4. D) Double-click on the sheet tab

Correct answer: A) Right-click on the sheet tab and select “Insert”

 

12. Which Excel feature allows you to visually represent data using bars of different lengths?

  1. A) Scatter Plot
  2. B) Bar Chart
  3. C) Line Graph
  4. D) Pivot Table

Correct answer: B) Bar Chart

 

13. What does the function =IF(A1>B1, “Yes”, “No”) do in Excel?

  1. A) Adds the values in cells A1 and B1
  2. B) Checks if the value in A1 is greater than the value in B1 and returns “Yes” if true, “No” if false
  3. C) Divides the value in A1 by the value in B1
  4. D) Concatenates the values in cells A1 and B1

Correct answer: B) Checks if the value in A1 is greater than the value in B1 and returns “Yes” if true, “No” if false

 

14. What is the purpose of sorting data in Excel?

  1. A) To combine cells with similar values
  2. B) To arrange data in alphabetical or numerical order
  3. C) To calculate the total of selected cells
  4. D) To create a backup of the worksheet

 Correct answer: B) To arrange data in alphabetical or numerical order

 

15. Which formula would you use to multiply cells A1 and B1 in Excel?

  1. A) =MULT(A1, B1)
  2. B) =A1 * B1
  3. C) =SUM(A1, B1)
  4. D) =PRODUCT(A1, B1)

Correct answer: B) =A1 * B1

 

16. How can you add a border to a cell or range of cells in Excel?

  1. A) Use the “Highlight” tool
  2. B) Go to Format > Border
  3. C) Right-click and select “Add Border”
  4. D) Use the shortcut Ctrl + B

Correct answer: B) Go to Format > Border

 

17. What is the purpose of the function =VLOOKUP() in Excel?

  1. A) To find and return values from a vertical lookup table
  2. B) To add values in a column
  3. C) To create a visual representation of data
  4. D) To count the number of cells with specific content

Correct answer: A) To find and return values from a vertical lookup table

 

18. How do you rename a worksheet in Excel?

  1. A) Right-click on the worksheet tab and select “Rename”
  2. B) Use the shortcut Ctrl + R
  3. C) Double-click on the worksheet tab
  4. D) Go to File > Rename

Correct answer: A) Right-click on the worksheet tab and select “Rename”

 

19. What is the purpose of the function =COUNTIF() in Excel?

  1. A) To calculate the total count of cells in a range
  2. B) To count the number of cells meeting a specific condition
  3. C) To find the average of cells in a range
  4. D) To sort data in ascending order

Correct answer: B) To count the number of cells meeting a specific condition

 

20. Which function would you use to round a number in Excel to the nearest integer?

  1. A) =ROUNDUP()
  2. B) =ROUNDDOWN()
  3. C) =ROUND()
  4. D) =ROUNDTO()

Correct answer: C) =ROUND()

 

 Basic Excel Quiz

  

21. Which symbol should be used to begin a formula in Excel?

  1. A) @
  2. B) %
  3. C) =
  4. D) #

Correct answer: C) =

 

22. What does the function =SUM(A1:A5) do in Excel?

  1. A) Adds the numbers in cells A1 to A5
  2. B) Subtracts the numbers in cells A1 to A5
  3. C) Multiplies the numbers in cells A1 to A5
  4. D) Divides the numbers in cells A1 to A5

Correct answer: A) Adds the numbers in cells A1 to A5

 

23. Which menu option in Excel allows you to change the font style and size?

  1. A) File
  2. B) Edit
  3. C) Format
  4. D) View

Correct answer: C) Format

 

24. What is the keyboard shortcut for undoing the last action in Excel?

  1. A) Ctrl + Z
  2. B) Ctrl + X
  3. C) Ctrl + U
  4. D) Ctrl + Y

Correct answer: A) Ctrl + Z

 

25. Which function can be used to find the highest value in a range of cells in Excel?

  1. A) =MAX()
  2. B) =MIN()
  3. C) =AVERAGE()
  4. D) =SUM()

Correct answer: A) =MAX()

 

26. In Excel, what is the purpose of freezing panes?

  1. A) To lock cells from editing
  2. B) To protect the worksheet from changes
  3. C) To keep specific rows or columns visible while scrolling
  4. D) To hide selected rows or columns

Correct answer: C) To keep specific rows or columns visible while scrolling

 

27. Which chart type is suitable for comparing values across categories in Excel?

  1. A) Pie Chart
  2. B) Line Chart
  3. C) Bar Chart
  4. D) Scatter Plot

Correct answer: C) Bar Chart

 

28. How can you insert a new row in an Excel worksheet?

  1. A) Right-click and select “Insert”
  2. B) Press Enter key
  3. C) Press Delete key
  4. D) Use the shortcut Ctrl + C

Correct answer: A) Right-click and select “Insert”

 

29. What does the function =COUNT(A1:A10) do in Excel?

  1. A) Finds the total of cells A1 to A10
  2. B) Counts the number of cells in the range A1 to A10
  3. C) Finds the highest value in the range A1 to A10
  4. D) Calculates the average of values in cells A1 to A10

Correct answer: B) Counts the number of cells in the range A1 to A10

 

30. Which Excel feature is used to perform calculations with data in a table?

  1. A) AutoSum
  2. B) AutoFormat
  3. C) AutoFill
  4. D) AutoCalculate

Correct answer: A) AutoSum

  ms excel quiz

 

31. What is the keyboard shortcut to open a new, blank workbook in Excel?

  1. A) Ctrl + N
  2. B) Ctrl + W
  3. C) Ctrl + B
  4. D) Ctrl + O

Correct answer: A) Ctrl + N

 

32. Which function in Excel is used to combine text from different cells into one cell?

  1. A) =MERGE()
  2. B) =CONCATENATE()
  3. C) =COMBINE()
  4. D) =TEXTJOIN()

Correct answer: B) =CONCATENATE()

 

33. Which option allows you to protect specific cells from editing in Excel?

  1. A) Lock Cells
  2. B) Freeze Panes
  3. C) Protect Worksheet
  4. D) Hide Cells

Correct answer: A) Lock Cells

 

34. Which formula would you use to find the average of cells A1 to A10 in Excel?

  1. A) =AVERAGE(A1:A10)
  2. B) =TOTAL(A1:A10)
  3. C) =MEAN(A1:A10)
  4. D) =AVG(A1:A10)

Correct answer: A) =AVERAGE(A1:A10)

 

35. In Excel, what does the function =NOW() do?

  1. A) Returns the current date
  2. B) Returns the current time
  3. C) Returns both the current date and time
  4. D) Returns the number of seconds since Excel was opened

Correct answer: C) Returns both the current date and time

 

36. Which Excel feature is used to find and remove duplicate values from a dataset?

  1. A) Data Validation
  2. B) Conditional Formatting
  3. C) Remove Duplicates
  4. D) Data Sorting

Correct answer: C) Remove Duplicates

 

37. How can you add dollar signs to the reference of cell B2 to make it an absolute reference in Excel?

  1. A) $B$2
  2. B) $B2
  3. C) B$2
  4. D) B2$

Correct answer: A) $B$2

 

38. Which Excel feature is used to create a chart based on selected data?

  1. A) Chart Builder
  2. B) Graph Wizard
  3. C) Data Visualization
  4. D) Insert Chart

Correct answer: D) Insert Chart

 

39. What does the function =COUNTBLANK() do in Excel?

  1. A) Counts the number of empty cells in a range
  2. B) Counts the number of cells with formulas
  3. C) Counts the number of cells with a specific value
  4. D) Counts the number of non-empty cells in a range

Correct answer: A) Counts the number of empty cells in a range

 

40. Which Excel feature is used to display different scenarios based on changing input values?

  1. A) Data Analysis ToolPak
  2. B) Goal Seek
  3. C) Scenario Manager
  4. D) Solver

Correct answer: C) Scenario Manager

  

free excel quiz

 

41. What does the function =VLOOKUP() do in Excel?

  1. A) Finds and returns values from a vertical lookup table
  2. B) Calculates the average of selected cells
  3. C) Adds values in a row or column
  4. D) Searches for specific text within a cell

Correct answer: A) Finds and returns values from a vertical lookup table

 

42. How can you select the entire worksheet in Excel?

  1. A) Click on the column header
  2. B) Click on the row number
  3. C) Press Ctrl + A
  4. D) Right-click and select “Select All”

Correct answer: C) Press Ctrl + A

 

43. What is the purpose of the function =COUNTIF() in Excel?

  1. A) Counts the number of cells with a specific value
  2. B) Multiplies values in a range
  3. C) Finds the average of selected cells
  4. D) Adds values in a range

Correct answer: A) Counts the number of cells with a specific value

 

43. How can you insert a new column in an Excel worksheet?

  1. A) Right-click and select “Insert”
  2. B) Use the shortcut Ctrl + C
  3. C) Press Enter key
  4. D) Use the shortcut Ctrl + I

Correct answer: A) Right-click and select “Insert”

 

45. Which function is used to round a number down to the nearest integer in Excel?

  1. A) =ROUNDDOWN()
  2. B) =ROUNDUP()
  3. C) =ROUND()
  4. D) =INT()

Correct answer: A) =ROUNDDOWN()

 

46. What does the function =SUBTOTAL() do in Excel?

  1. A) Finds the subtotal of values in a range
  2. B) Subtracts values in a range
  3. C) Divides values in a range
  4. D) Multiplies values in a range

Correct answer: A) Finds the subtotal of values in a range

 

47. How can you apply a currency format to a cell in Excel?

  1. A) Use the shortcut Ctrl + $
  2. B) Right-click and select “Format as Currency”
  3. C) Go to Format > Cells > Currency
  4. D) Use the shortcut Ctrl + Shift + $

Correct answer: C) Go to Format > Cells > Currency

 

48. Which option in Excel allows you to filter data based on specific criteria?

  1. A) Sort
  2. B) Conditional Formatting
  3. C) Data Validation
  4. D) AutoFilter

Correct answer: D) AutoFilter

 

49. What is the purpose of the function =IFERROR() in Excel?

  1. A) Returns an error if a condition is met
  2. B) Checks if a cell contains an error value and replaces it with another value
  3. C) Performs calculations only if there is an error
  4. D) Ignores all errors in the worksheet

Correct answer: B) Checks if a cell contains an error value and replaces it with another value

 

50. Which Excel feature is used to create a formula that can be applied to adjacent cells?

  1. A) AutoFill
  2. B) AutoSum
  3. C) AutoCalculate
  4. D) AutoComplete

Correct answer: A) AutoFill

 

51. What does the function =IFERROR() do in Excel?

  1. A) Returns an error if a condition is met
  2. B) Checks if a cell contains an error value and replaces it with another value
  3. C) Performs calculations only if there is an error
  4. D) Ignores all errors in the worksheet

Correct answer: B) Checks if a cell contains an error value and replaces it with another value

 

52. How can you create an absolute reference for cell B2 in Excel?

  1. A) B2
  2. B) $B$2
  3. C) B$2
  4. D) $B2

Correct answer: B) $B$2

 

53. Which Excel feature allows you to display different sections of a worksheet simultaneously?

  1. A) Split
  2. B) Freeze Panes
  3. C) Window Panes
  4. D) Worksheet View

Correct answer: A) Split

 

54. What is the purpose of the function =COUNTA() in Excel?

  1. A) Counts the number of empty cells in a range
  2. B) Counts the number of cells with a specific value
  3. C) Counts the number of non-empty cells in a range
  4. D) Counts the number of cells with formulas

Correct answer: C) Counts the number of non-empty cells in a range

 

55. How can you copy cell formatting in Excel?

  1. A) Use the shortcut Ctrl + V
  2. B) Use the shortcut Ctrl + C
  3. C) Use the Format Painter
  4. D) Right-click and select “Copy Format”

Correct answer: C) Use the Format Painter

 

56. Which Excel feature allows you to visually represent data trends over time?

  1. A) Line Chart
  2. B) Bar Chart
  3. C) Pie Chart
  4. D) Scatter Plot

Correct answer: A) Line Chart

 

57. How do you add a comment to a cell in Excel?

  1. A) Right-click and select “Insert Comment”
  2. B) Use the shortcut Ctrl + Shift + C
  3. C) Go to Format > Cell > Add Comment
  4. D) Use the shortcut Ctrl + K

Correct answer: A) Right-click and select “Insert Comment”

 

58. What is the purpose of the function =SUMIF() in Excel?

  1. A) Adds values in a range based on a specified condition
  2. B) Counts the number of cells with a specific value
  3. C) Calculates the total number of cells in a range
  4. D) Finds the average of values in a range

Correct answer: A) Adds values in a range based on a specified condition

 

59. How can you hide a worksheet in Excel?

  1. A) Right-click on the worksheet tab and select “Hide”
  2. B) Use the shortcut Ctrl + H
  3. C) Go to Format > Hide Worksheet
  4. D) Drag the worksheet tab outside the Excel window

Correct answer: A) Right-click on the worksheet tab and select “Hide”

 

60. Which function would you use to find the highest value in a range of cells in Excel?

  1. A) =MAX()
  2. B) =MIN()
  3. C) =LARGE()
  4. D) =HIGHEST()

Correct answer: A) =MAX()

 

Leave a Reply