-
web.groovymark@gmail.com
- December 8, 2024
Question 01
Which of the following is a method for freezing rows and columns in Excel?
A. Use Conditional Formatting
B. Select “Freeze Panes” from the VIEW tab
C. Use the Insert tab to lock the cells
D. Highlight rows and click “Sort”
Answer: B. Select "Freeze Panes" from the VIEW tab
Explanation: The Freeze Panes option in the VIEW tab allows you to lock rows or columns, making them visible while scrolling through the rest of the worksheet.
Question 02
What does Excel display when the width of a column is too narrow to display the entire content of a cell?
A. #DIV/0!
B. ####
C. #VALUE!
D. Blank Cell
Answer: B. ####
Explanation: When the content exceeds the width of a column, Excel displays #### instead of the content.
Question 03
Which of the following features can be used to display the formula used in a cell?
A. Show Formula
B. Trace Precedents
C. Evaluate Formula
D. Conditional Formatting
Answer: A. Show Formula
Explanation: The Show Formula tool displays the formulas applied in a cell rather than the result.
Question 04
How can you modify the width of a column to automatically fit the longest entry?
A. Drag the column manually
B. Double-click the border between two column headings
C. Use the “AutoFill” option
D. Apply Wrap Text
Answer: B. Double-click the border between two column headings
Explanation: Double-clicking the border between column headings will automatically adjust the column to fit the longest entry.
Question 05
Which of the following Excel functions returns the highest value in a range of cells?
A. SUM
B. MIN
C. MAX
D. AVERAGE
Answer: C. MAX
Explanation: The MAX function identifies the largest number in a specified range.
Question 06
In Excel, what is the use of a PivotTable?
A. To store raw data
B. To summarize and analyze data
C. To create 3D models
D. To write complex formulas
Answer: B. To summarize and analyze data
Explanation: PivotTables allow you to summarize and analyze data, especially from large datasets.
Question 07
What is the shortcut to quickly duplicate the contents of a cell into another cell directly below it?
A. Ctrl + V
B. Ctrl + C
C. Ctrl + D
D. Ctrl + P
Answer: C. Ctrl + D
Explanation: Ctrl + D duplicates the contents of the selected cell into the cell directly below it.
Question 08
What does the VLOOKUP function do in Excel?
A. It vertically looks for a value in a table
B. It sums up all values in a column
C. It compares two different ranges
D. It extracts specific text from a string
Answer: A. It vertically looks for a value in a table
Explanation: VLOOKUP is used to search for a value in the first column of a table and return a value in the same row from a specified column.
Question 09
What is the function of the “Merge & Center” button?
A. Merge worksheets
B. Center the data across selected cells
C. Combine selected cells into one and center-align the content
D. Split the content of cells
Answer: C. Combine selected cells into one and center-align the content
Explanation: Merge & Center combines multiple cells into a single cell and centers the text or value within that cell.
Question 10
Which of the following is the correct formula to calculate the total of a range of cells?
A. =SUM(A1)
B. =MAX(A1)
C. =ADD(A1)
D. =AVG(A1)
Answer: A. =SUM(A1)
Explanation: The SUM function adds up the values in the specified range of cells.
Question 11
How do you add a comment to a cell in Excel?
A. Right-click the cell and select “Insert Comment”
B. Use the “Data” tab
C. Use the “Formulas” tab
D. Select “Conditional Formatting”
Answer: A. Right-click the cell and select "Insert Comment"
Explanation: You can add comments by right-clicking a cell and selecting "Insert Comment."
Question 12
What function in Excel can be used to calculate the average of a set of numbers?
A. SUM
B. AVERAGE
C. MEDIAN
D. MAX
Answer: B. AVERAGE
Explanation: The AVERAGE function calculates the arithmetic mean of a set of numbers.
Question 13
Which of the following would you use to lock cells so they cannot be edited?
A. Conditional Formatting
B. Cell Protection
C. Data Validation
D. Wrap Text
Answer: B. Cell Protection
Explanation: Cell Protection prevents users from editing or changing certain cells.
Question 14
What does the PMT function calculate?
A. Principal payment
B. Interest payment
C. Loan repayment
D. Future value of investment
Answer: C. Loan repayment
Explanation: The PMT function calculates the periodic payment for a loan based on constant payments and a constant interest rate.
Question 15
What key combination is used to open the Find and Replace dialog box?
A. Ctrl + F
B. Ctrl + R
C. Ctrl + H
D. Ctrl + G
Answer: C. Ctrl + H
Explanation: Ctrl + H opens the Find and Replace dialog box in Excel.
Question 16
What feature is used to create a series based on a pattern of values?
A. AutoFit
B. AutoFill
C. SUM
D. CONCATENATE
Answer: B. AutoFill
Explanation: AutoFill is used to extend a series of numbers, dates, or other patterns into adjacent cells.
Question 17
What is the default number format applied to cells in Excel?
A. Currency
B. Text
C. General
D. Date
Answer: C. General
Explanation: The General format is the default number format in Excel and does not apply specific formatting to numbers.
Question 18
What formula would you use to find the smallest value in a range of cells?
A. =SUM(A1)
B. =MIN(A1)
C. =MAX(A1)
D. =AVG(A1)
Answer: B. =MIN(A1)
Explanation: The MIN function returns the smallest value in the specified range of cells.
Question 19
Which feature allows you to limit the type of data entered in a cell?
A. Conditional Formatting
B. Data Validation
C. Trace Precedents
D. Protect Sheet
Answer: B. Data Validation
Explanation: Data Validation limits the type of data or values that can be entered into a cell.
Question 20
Which keyboard shortcut inserts a new worksheet in Excel?
A. Shift + F11
B. Ctrl + N
C. Ctrl + T
D. Alt + W
Answer: A. Shift + F11
Explanation: Shift + F11 inserts a new worksheet into the current workbook.
