26. Which of the following functions is used to round a number to a specified number of decimal places in Excel?
a) =ROUND()
b) =TRUNC()
c) =CEILING()
d) =FLOOR()
Answer: a
27. What is the purpose of the "Text to Columns" feature in Excel?
a) To split text into multiple columns based on a delimiter
b) To merge multiple columns into one
c) To change the text color in a cell
d) To wrap text within a single cell
Answer: a
28. Which function in Excel calculates the average of a range of numbers?
a) =AVERAGE()
b) =SUM()
c) =MEDIAN()
d) =MODE()
Answer: a
29. Which of the following options is used to make text bold in Excel?
a) Ctrl + B
b) Ctrl + U
c) Ctrl + I
d) Ctrl + T
Answer: a
30. Which of the following is the correct formula to calculate the total number of characters in a cell?
a) =LEN()
b) =CHAR()
c) =COUNT()
d) =LENGTH()
Answer: a
31. What does the "Flash Fill" feature in Excel do?
a) Automatically fills data based on a pattern
b) Highlights duplicates in a range
c) Protects a worksheet from editing
d) Calculates the sum of a range
Answer: a
32. What is the purpose of the "Goal Seek" feature in Excel?
a) To find the input value needed to achieve a desired result
b) To change multiple values at once
c) To calculate the average of a range of cells
d) To forecast future trends based on historical data
Answer: a
33. What is the keyboard shortcut to insert a new row in Excel?
a) Ctrl + R
b) Ctrl + Shift + "+"
c) Ctrl + N
d) Ctrl + Shift + I
Answer: b
34. How do you insert a page break in Excel?
a) Go to the Page Layout tab and select "Breaks"
b) Press Ctrl + Enter
c) Go to the View tab and select "Page Break Preview"
d) Right-click a cell and select "Insert Page Break"
Answer: a
35. How do you change the font size of a cell in Excel?
a) Use the "Font Size" drop-down in the Home tab
b) Press Ctrl + F
c) Right-click the cell and select "Change Font Size"
d) Go to the Insert tab and choose "Font Size"
Answer: a
36. Which Excel function returns the current time without the date?
a) =NOW()
b) =TIME()
c) =TODAY()
d) =CURRENTTIME()
Answer: b
37. What is the maximum number of characters that can be entered into a single Excel cell?
a) 1,024
b) 32,767
c) 65,536
d) 256
Answer: b
38. Which function would you use to count the number of cells that are empty in a range?
a) =COUNT()
b) =COUNTA()
c) =COUNTBLANK()
d) =COUNTIF()
Answer: c
39. How can you change the width of a column in Excel?
a) Right-click the column header and select "Column Width"
b) Drag the border of the column header
c) Go to the View tab and select "Adjust Width"
d) Both a and b
Answer: d
40. What does the "Concatenate" function do in Excel?
a) Joins two or more text strings into one
b) Finds the largest number in a range
c) Returns the current date and time
d) Sums the values of two cells
Answer: a
41. How do you insert a function in Excel?
a) Type "=function_name" in the cell
b) Click the "Insert Function" button on the Formulas tab
c) Right-click a cell and select "Insert Function"
d) All of the above
Answer: d
42. What is the keyboard shortcut to open the Format Cells dialog box in Excel?
a) Ctrl + 1
b) Ctrl + F
c) Ctrl + Shift + F
d) Ctrl + P
Answer: a
43. Which function is used to get the current system date in Excel?
a) =DATE()
b) =TODAY()
c) =NOW()
d) =TIME()
Answer: b
44. What is the shortcut key for Undo in Excel?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + U
d) Ctrl + X
Answer: a
45. Which of the following functions is used to remove extra spaces in a text string?
a) =REMOVE()
b) =TRIM()
c) =CLEAN()
d) =CLEAR()
Answer: b
46. What is the correct formula to calculate the square root of a number in Excel?
a) =SQRT()
b) =SQR()
c) =POWER()
d) =ROOT()
Answer: a
47. How do you add a border around a cell in Excel?
a) Go to the Home tab and click on "Borders"
b) Right-click the cell and select "Add Border"
c) Press Ctrl + B
d) Use the Format Cells dialog box
Answer: a
48. What is the purpose of the "Pivot Table" feature in Excel?
a) To summarize and analyze data
b) To create charts
c) To calculate totals and averages
d) To filter and sort data
Answer: a
49. How do you change the background color of a cell in Excel?
a) Use the "Fill Color" button on the Home tab
b) Press Ctrl + F
c) Right-click the cell and select "Background Color"
d) Use the "Cell Styles" button
Answer: a
50. What does the "COUNTBLANK" function do in Excel?
a) Counts the number of blank cells in a range
b) Counts the number of non-blank cells
c) Counts the number of cells with a certain value
d) Counts the number of cells with text
Answer: a
