50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
Which of the following is a method for freezing rows and columns in Excel?
Correct 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 2 of 50
What does Excel display when the width of a column is too narrow to display the entire content of a cell?
Correct answer: B) ####
Explanation: When the content exceeds the width of a column, Excel displays #### instead of the content.
Question 3 of 50
Which of the following features can be used to display the formula used in a cell?
Correct answer: A) Show Formula
Explanation: The Show Formula tool displays the formulas applied in a cell rather than the result.
Question 4 of 50
How can you modify the width of a column to automatically fit the longest entry?
Correct 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 5 of 50
Which of the following Excel functions returns the highest value in a range of cells?
Correct answer: C) MAX
Explanation: The MAX function identifies the largest number in a specified range.
Question 6 of 50
In Excel, what is the use of a PivotTable?
Correct answer: B) To summarize and analyze data
Explanation: PivotTables allow you to summarize and analyze data, especially from large datasets.
Question 7 of 50
What is the shortcut to quickly duplicate the contents of a cell into another cell directly below it?
Correct answer: C) Ctrl + D
Explanation: Ctrl + D duplicates the contents of the selected cell into the cell directly below it.
Question 8 of 50
What does the VLOOKUP function do in Excel?
Correct 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 9 of 50
What is the function of the “Merge & Center” button?
Correct 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 of 50
Which of the following is the correct formula to calculate the total of a range of cells?
Correct answer: A) =SUM(A1 )
Explanation: The SUM function adds up the values in the specified range of cells.
Question 11 of 50
How do you add a comment to a cell in Excel?
Correct 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 of 50
What function in Excel can be used to calculate the average of a set of numbers?
Correct answer: B) AVERAGE
Explanation: The AVERAGE function calculates the arithmetic mean of a set of numbers.
Question 13 of 50
Which of the following would you use to lock cells so they cannot be edited?
Correct answer: B) Cell Protection
Explanation: Cell Protection prevents users from editing or changing certain cells.
Question 14 of 50
What does the PMT function calculate?
Correct 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 of 50
What key combination is used to open the Find and Replace dialog box?
Correct answer: C) Ctrl + H
Explanation: Ctrl + H opens the Find and Replace dialog box in Excel.
Question 16 of 50
What feature is used to create a series based on a pattern of values?
Correct answer: B) AutoFill
Explanation: AutoFill is used to extend a series of numbers, dates, or other patterns into adjacent cells.
Question 17 of 50
What is the default number format applied to cells in Excel?
Correct answer: C) General
Explanation: The General format is the default number format in Excel and does not apply specific formatting to numbers.
Question 18 of 50
What formula would you use to find the smallest value in a range of cells?
Correct answer: B) =MIN(A1)
Explanation: The MIN function returns the smallest value in the specified range of cells.
Question 19 of 50
Which feature allows you to limit the type of data entered in a cell?
Correct answer: B) Data Validation
Explanation: Data Validation limits the type of data or values that can be entered into a cell.
Question 20 of 50
Which keyboard shortcut inserts a new worksheet in Excel?
Correct answer: A) Shift + F11
Explanation: Shift + F11 inserts a new worksheet into the current workbook.
Question 21 of 50
How can you format cells to display values as percentages?
Correct answer: A) Right-click and choose “Number Format”
Explanation: Right-clicking a cell and selecting "Number Format" allows you to choose Percentage as the format.
Question 22 of 50
What does the COUNT function do in Excel?
Correct answer: C) Counts the number of numeric values in a range
Explanation: The COUNT function only counts the numeric values in the specified range.
Question 23 of 50
Which of the following tools automatically totals the selected cells in Excel?
Correct answer: B) AutoSum
Explanation: AutoSum quickly adds up the values of selected cells and displays the total.
Question 24 of 50
Which tool allows you to organize and view large datasets by category?
Correct answer: A) PivotTable
Explanation: PivotTables help you organize large datasets by summarizing data into categories.
Question 25 of 50
What type of chart is used to show trends over time?
Correct answer: B) Line Chart
Explanation: A Line Chart is commonly used to display trends or changes over time.
Question 26 of 50
What function would you use to return the current date in a cell?
Correct answer: C) =TODAY()
Explanation: The TODAY function returns the current date without the time.
Question 27 of 50
Which of the following is NOT a valid argument in the IF function?
Correct answer: C) Condition
Explanation: The correct arguments for an IF function are Logical Test, Value_if_True, and Value_if_False.
Question 28 of 50
How can you quickly remove the formatting from a range of cells?
Correct answer: B) Clear Formats
Explanation: The Clear Formats option removes only the formatting, leaving the cell content intact.
Question 29 of 50
Which of the following can be used to compare the parts of a whole?
Correct answer: B) Pie Chart
Explanation: Pie Charts are used to compare individual sections to the whole.
Question 30 of 50
What does the CONCATENATE function do in Excel?
Correct answer: A) Combines the values of multiple cells into one
Explanation: The CONCATENATE function joins together multiple text values or cell references into a single cell.
Question 31 of 50
Which of the following represents an absolute cell reference?
Correct answer: B) $A$1
Explanation: An absolute reference has dollar signs before both the column letter and row number to prevent it from changing when copied.
Question 32 of 50
What is the shortcut to display formulas instead of their results in Excel?
Correct answer: C) Ctrl + `
Explanation: Ctrl + ` toggles between displaying formulas and results in cells.
Question 33 of 50
What type of chart is best used to display the relationship between two variables?
Correct answer: D) Scatterplot
Explanation: A Scatterplot is used to show the relationship or correlation between two variables.
Question 34 of 50
How do you repeat the last action in Excel?
Correct answer: B) Ctrl + Y
Explanation: Ctrl + Y repeats the last action performed in Excel.
Question 35 of 50
What feature allows you to visualize the magnitude of values in Excel cells with colors?
Correct answer: C) Conditional Formatting
Explanation: Conditional Formatting can apply colors, icons, or bars to cells based on the magnitude or conditions of their values.
Question 36 of 50
Which function calculates the number of non-empty cells in a range?
Correct answer: B) COUNTA
Explanation: COUNTA counts the number of non-empty cells, regardless of whether they contain text, numbers, or formulas.
Question 37 of 50
What would you use to remove duplicate values from a dataset in Excel?
Correct answer: D) Remove Duplicates
Explanation: The Remove Duplicates tool eliminates repeated values from a dataset.
Question 38 of 50
How do you apply a filter to a dataset in Excel?
Correct answer: B) Use the Filter option under the DATA tab
Explanation: You can apply a filter using the Filter option found in the DATA tab.
Question 39 of 50
What is the default alignment for text in Excel cells?
Correct answer: A) Left
Explanation: By default, text in Excel is aligned to the left of the cell.
Question 40 of 50
Which Excel function rounds a number to a specified number of decimal places?
Correct answer: A) ROUND
Explanation: The ROUND function rounds a number to the specified number of decimal places.
Question 41 of 50
What is the shortcut to open the Format Cells dialog box?
Correct answer: A) Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog box, allowing you to format cell contents.
Question 42 of 50
How can you create a chart from a selected range of cells in Excel?
Correct answer: C) Press F11
Explanation: Pressing F11 creates a default chart from the selected range of data in a new worksheet.
Question 43 of 50
Which of the following tools checks for errors in a worksheet’s formulas?
Correct answer: B) Evaluate Formula
Explanation: The Evaluate Formula tool allows you to step through and analyze formulas to check for errors.
Question 44 of 50
What does the TRIM function do in Excel?
Correct answer: B) Removes extra spaces from text
Explanation: The TRIM function eliminates any leading, trailing, or extra spaces in text.
Question 45 of 50
How do you remove gridlines from a worksheet in Excel?
Correct answer: B) Go to the Page Layout tab and uncheck Gridlines
Explanation: You can remove or hide gridlines by going to the Page Layout tab and unchecking the Gridlines option.
Question 46 of 50
What feature allows you to identify cells that influence the value of a selected cell?
Correct answer: B) Trace Precedents
Explanation: Trace Precedents shows the cells that are referenced in the selected cell's formula.
Question 47 of 50
What is the shortcut to hide selected rows in Excel?
Correct answer: A) Ctrl + 9
Explanation: Ctrl + 9 hides the selected rows in the worksheet.
Question 48 of 50
How can you display the contents of a long text entry on multiple lines in a single cell?
Correct answer: B) Apply the Wrap Text option
Explanation: The Wrap Text option automatically adjusts the cell content to display on multiple lines within a single cell.
Question 49 of 50
Which of the following is NOT a function in Excel?
Correct answer: D) SEARCHVALUE
Explanation: SEARCHVALUE is not a function in Excel, while HLOOKUP, MATCH, and LOOKUP are valid functions.
Question 50 of 50
Which of the following will you use to generate a random number in Excel?
Correct answer: A) =RAND()
Explanation: The RAND function generates a random number between 0 and 1.
Set 2 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).