Which of the following is the shortcut to open the “Format Cells” dialog box?
Correct answer:
A) Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog box, where you can change various formatting options.
Which of the following is the shortcut to open the “Format Cells” dialog box?
Correct answer:
A) Ctrl + 1
Explanation: Ctrl + 1 opens the Format Cells dialog box, where you can change various formatting options.
What does the VLOOKUP function do in Excel?
Correct answer:
B) Looks up values in columns
Explanation: VLOOKUP is used to find a value in the leftmost column and returns a value in the same row from a specified column.
What does the SUBTOTAL function in Excel do?
Correct answer:
B) Performs calculations like sum, average, count, etc., on visible cells
Explanation: SUBTOTAL allows you to perform calculations (sum, count, average) only on visible cells, ignoring hidden ones.
How do you protect a worksheet in Excel?
Correct answer:
B) Use the Review tab and select “Protect Sheet”
Explanation: The Protect Sheet option in the Review tab allows you to restrict users from making changes to a worksheet.
Which Excel function is used to count only cells that contain numbers?
Correct answer:
B) COUNT
Explanation: COUNT only counts the cells that contain numerical data.
What happens when you double-click the fill handle in Excel?
Correct answer:
A) It fills the series down to the end of the data range
Explanation: Double-clicking the fill handle automatically fills the series down based on adjacent data.
What is the main purpose of the PivotTable feature in Excel?
Correct answer:
B) To summarize and analyze large datasets
Explanation: PivotTables allow users to summarize, analyze, and explore large amounts of data interactively.
Which of the following error codes represents an invalid cell reference?
Correct answer:
B) #REF!
Explanation: #REF! occurs when a formula contains an invalid cell reference.
How can you insert multiple rows at once in Excel?
Correct answer:
B) Right-click and choose “Insert” after selecting multiple rows
Explanation: You can insert multiple rows by selecting the same number of rows as you want to insert, right-clicking, and selecting “Insert.”
Which of the following is the correct syntax for the IF function?
Correct answer:
A) IF(condition, value_if_true, value_if_false)
Explanation: The IF function takes a condition, followed by the values to return if the condition is true or false.
How do you apply a filter to a data range in Excel?
Correct answer:
A) Use the “Data” tab and select “Filter”
Explanation: Filters can be applied to a data range through the Filter option in the Data tab.
Which of the following features allows you to apply specific formatting based on cell values?
Correct answer:
A) Conditional Formatting
Explanation: Conditional Formatting lets you apply different formats to cells based on their values or specific conditions.
What is the main purpose of the “Goal Seek” feature in Excel?
Correct answer:
A) To find an input value needed to reach a desired result
Explanation: Goal Seek is used to calculate the input value required to achieve a specified output in a formula.
Which of the following is the shortcut for creating a new chart?
Correct answer:
A) F11
Explanation: Pressing F11 creates a new chart based on the selected data in Excel.
How do you lock a specific cell to prevent it from changing when copying a formula?
Correct answer:
B) Use absolute cell references with $
Explanation: Absolute cell references (e.g., $A$1) prevent cell references from changing when copying formulas.
What does the CONCATENATE function do in Excel?
Correct answer:
B) Joins text from multiple cells into one
Explanation: CONCATENATE combines text from different cells into a single cell.
Which of the following is the correct formula to calculate the average of a range of cells A1 ?
Correct answer:
A) =AVERAGE(A1 )
Explanation: The AVERAGE function calculates the mean of a specified range.
What does pressing Ctrl + Z do in Excel?
Correct answer:
B) Undoes the last action
Explanation: Ctrl + Z is the standard shortcut for undoing the most recent action.
Which of the following functions is used to return the current date and time in Excel?
Correct answer:
A) NOW()
Explanation: The NOW() function returns the current date and time.
What does the term “cell range” refer to in Excel?
Correct answer:
B) A collection of adjacent cells
Explanation: A cell range refers to a block of adjacent cells in a worksheet.
What is the purpose of the HLOOKUP function in Excel?
Correct answer:
B) Looks up values in rows
Explanation: HLOOKUP searches for a value in the first row of a table and returns a value in the same column from another row.
Which of the following is a valid Excel formula?
Correct answer:
A) =SUM(A1, B2, C3)
Explanation: Excel uses commas to separate arguments in a function.
Which of the following tools helps visualize data in Excel?
Correct answer:
B) PivotChart
Explanation: PivotCharts are visual representations of the summarized data in PivotTables.
How do you group rows or columns in Excel?
Correct answer:
A) Use the Data tab and select “Group”
Explanation: The Group option in the Data tab allows you to group rows or columns.
What is the purpose of the TEXT function in Excel?
Correct answer:
A) Converts numbers to text in a specific format
Explanation: The TEXT function formats numbers as text according to a specified format.
Which of the following is the shortcut to insert the current date in Excel?
Correct answer:
C) Ctrl + ; (semicolon)
Explanation: Pressing Ctrl + ; inserts the current date into the selected cell.
What is the purpose of the FIND function in Excel?
Correct answer:
A) Searches for a text string within another text string
Explanation: FIND locates the position of a substring within another text string.
How do you remove gridlines from a worksheet in Excel?
Correct answer:
A) Use the View tab and uncheck the “Gridlines” box
Explanation: The View tab contains the option to show or hide gridlines in a worksheet.
What does the MATCH function do in Excel?
Correct answer:
A) Finds the relative position of a value in a range
Explanation: MATCH returns the position of a specific value in a range of cells.
How do you create a named range in Excel?
Correct answer:
A) Use the Formula tab and select “Define Name”
Explanation: The Define Name option in the Formula tab allows you to create named ranges
What is the shortcut for switching between worksheets in Excel?
Correct answer:
C) Ctrl + Page Up/Page Down
Explanation: Ctrl + Page Up/Page Down allows you to navigate between different worksheets in a workbook.
What does the LEFT function do in Excel?
Correct answer:
B) Extracts a substring from the beginning of a text string
Explanation: LEFT returns a specified number of characters from the beginning of a text string.
What is the purpose of the OFFSET function in Excel?
Correct answer:
A) Returns a reference to a range offset from a given reference
Explanation: OFFSET returns a reference to a cell or range of cells that is a specific number of rows and columns from a given reference.
How do you create a drop-down list in Excel?
Correct answer:
A) Use Data Validation and select “List”
Explanation: You can create a drop-down list in Excel using Data Validation and selecting the “List” option.
What is the purpose of the SUBSTITUTE function in Excel?
Correct answer:
A) Replaces text in a string with another text
Explanation: SUBSTITUTE replaces occurrences of specified text within a text string.
What does the MID function do in Excel?
Correct answer:
A) Extracts a substring from the middle of a text string
Explanation: MID returns a specified number of characters from a text string, starting from a given position.
What is the correct formula to calculate the square root of a number in Excel?
Correct answer:
A) =SQRT(number)
Explanation: The SQRT function returns the square root of a given number.
How do you remove all formulas from a worksheet while keeping the results?
Correct answer:
A) Copy and paste values only
Explanation: Copying the cells and pasting them as values replaces formulas with their results.
Which of the following is the correct function to return the remainder of a division in Excel?
Correct answer:
A) MOD
Explanation: MOD returns the remainder of a division between two numbers.
What is the purpose of the INDIRECT function in Excel?
Correct answer:
A) Returns the reference specified by a text string
Explanation: INDIRECT converts a text string into a valid cell reference.
How do you insert a new worksheet in Excel?
Correct answer:
A) Press Shift + F11
Explanation: Pressing Shift + F11 inserts a new worksheet into the workbook.
What does pressing Ctrl + A do in Excel?
Correct answer:
A) Selects the entire worksheet
Explanation: Ctrl + A selects all the cells in the current worksheet.
What does the COUNTA function do in Excel?
Correct answer:
A) Counts non-empty cells
Explanation: COUNTA counts the number of cells that are not empty.
How do you apply borders to a selected range of cells in Excel?
Correct answer:
A) Use the Home tab and select “Borders”
Explanation: The Borders option in the Home tab lets you add borders to the selected range of cells.
Which of the following tools is used to track changes made to a workbook?
Correct answer:
A) Track Changes
Explanation: Track Changes records the changes made in a shared workbook.
What is the shortcut for selecting the entire column in Excel?
Correct answer:
A) Ctrl + Space
Explanation: Ctrl + Space selects the entire column of the active cell.
Which of the following is the purpose of the CHOOSE function in Excel?
Correct answer:
A) Selects a value from a list based on an index number
Explanation: The CHOOSE function returns a value from a list of values based on an index number.
What does the CLEAN function do in Excel?
Correct answer:
A) Removes all non-printable characters from text
Explanation: CLEAN removes non-printable characters from a text string.
How do you delete multiple worksheets at once in Excel?
Correct answer:
A) Hold down Ctrl, select the sheets, right-click, and choose Delete
Explanation: You can delete multiple worksheets by selecting them while holding Ctrl, right-clicking, and selecting Delete.
What does the LARGE function do in Excel?
Correct answer:
A) Returns the k-th largest value in a data set
Explanation: LARGE returns the k-th largest value from a data set based on the specified position.
If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.