What does the CONCAT function do in Excel?
Correct answer:
A) Combines text from multiple cells into one
Explanation: The CONCAT function combines text from multiple cells into a single cell.
What does the CONCAT function do in Excel?
Correct answer:
A) Combines text from multiple cells into one
Explanation: The CONCAT function combines text from multiple cells into a single cell.
What is the shortcut for saving a workbook in Excel?
Correct answer:
A) Ctrl + S
Explanation: Ctrl + S is the standard shortcut for saving a workbook in Excel.
Which of the following functions returns the current date in Excel?
Correct answer:
A) TODAY()
Explanation: The TODAY() function returns the current date without the time.
How do you quickly switch to the next worksheet in Excel?
Correct answer:
B) Press Ctrl + Page Down
Explanation: Ctrl + Page Down switches between worksheets in Excel.
Which chart type is best for showing parts of a whole?
Correct answer:
C) Pie Chart
Explanation: A Pie Chart is used to display parts of a whole as slices of a circle.
What does the MAX function do in Excel?
Correct answer:
A) Returns the highest value in a range
Explanation: The MAX function returns the largest value in a specified range of cells.
What is the purpose of the Fill Handle in Excel?
Correct answer:
C) It extends a series or copies content to adjacent cells
Explanation: The Fill Handle is used to quickly copy or fill a pattern in cells.
Which of the following functions can you use to return the current day of the week in Excel?
Correct answer:
A) WEEKDAY()
Explanation: The WEEKDAY() function returns a number representing the day of the week for a date.
What is the default file extension for Excel workbooks?
Correct answer:
B) .xlsx
Explanation: The default file extension for Excel workbooks is .xlsx.
How do you create a comment in an Excel cell?
Correct answer:
C) Use the Review tab and select “New Comment”
Explanation: Comments can be added to cells through the Review tab by selecting “New Comment.”
What does the COUNTA function do in Excel?
Correct answer:
B) Counts all the non-blank cells in a range
Explanation: COUNTA counts all cells that are not empty, regardless of the type of data.
What is a Sparkline in Excel?
Correct answer:
A) A mini chart displayed inside a single cell
Explanation: Sparklines are small charts that fit into a single cell to show trends.
Which of the following functions calculates the number of years between two dates in Excel?
Correct answer:
B) DATEDIF()
Explanation: DATEDIF can calculate the difference in years, months, or days between two dates.
How do you merge two or more cells in Excel?
Correct answer:
B) Use the Merge & Center option on the Home tab
Explanation: The Merge & Center feature merges multiple selected cells and centers the content.
What is the shortcut to insert a new worksheet in Excel?
Correct answer:
B) Shift + F11
Explanation: Shift + F11 quickly inserts a new worksheet into the workbook.
What does the ROUND function do in Excel?
Correct answer:
C) Rounds a number to a specified number of digits
Explanation: ROUND allows you to specify the number of digits to round a number.
Which of the following error messages indicates a divide-by-zero error?
Correct answer:
A) #DIV/0!
Explanation: #DIV/0! occurs when a formula attempts to divide by zero.
How can you convert text to columns in Excel?
Correct answer:
A) Use the “Text to Columns” feature in the Data tab
Explanation: The Text to Columns feature splits text in one column into multiple columns based on a delimiter.
What is the result of the formula =AVERAGE(10, 20, 30)?
Correct answer:
A) 20
Explanation: The AVERAGE function calculates the mean value of the numbers provided, which is 20.
What is the purpose of Freeze Panes in Excel?
Correct answer:
B) To lock certain rows or columns in place
Explanation: Freeze Panes locks specified rows or columns so that they remain visible while scrolling through the worksheet.
What is the purpose of the TRIM function in Excel?
Correct answer:
C) To remove extra spaces from text except for single spaces between words
Explanation: The TRIM function removes any extra spaces in text, leaving only single spaces between words.
How can you quickly duplicate a worksheet in Excel?
Correct answer:
D) Hold Ctrl and drag the sheet tab
Explanation: Holding the Ctrl key and dragging the sheet tab will create a duplicate of the worksheet.
Which of the following formulas returns the current date and time?
Correct answer:
A) NOW()
Explanation: The NOW() function returns the current date and time.
How do you open the “Find and Replace” feature in Excel?
Correct answer:
B) Ctrl + H
Explanation: Ctrl + H opens the Find and Replace dialog in Excel.
What is the shortcut for hiding a row in Excel?
Correct answer:
B) Ctrl + 9
Explanation: Pressing Ctrl + 9 hides the currently selected row.
Which of the following functions would you use to find the smallest number in a range?
Correct answer:
A) MIN
Explanation: The MIN function returns the smallest number in a specified range of cells.
What does the LEN function do in Excel?
Correct answer:
A) Returns the length of text in characters
Explanation: LEN returns the number of characters in a text string.
What is the shortcut to open a new workbook in Excel?
Correct answer:
C) Ctrl + N
Explanation: Ctrl + N opens a new workbook in Excel.
Which of the following Excel features allows you to perform what-if analysis?
Correct answer:
C) Scenario Manager
Explanation: Scenario Manager allows you to perform what-if analysis by comparing different sets of input values.
What is the default number of sheets in a new Excel workbook?
Correct answer:
A) 1
Explanation: In recent versions of Excel, a new workbook opens with a default of 1 sheet.
How do you insert a new row in Excel?
Correct answer:
A) Ctrl + Shift + + (Plus)
Explanation: This shortcut inserts a new row in Excel above the currently selected row.
What does the IF function do in Excel?
Correct answer:
C) Returns one value if a condition is true and another if false
Explanation: The IF function allows you to test a condition and return different results based on whether the condition is true or false.
How do you clear all the formatting in a cell?
Correct answer:
A) Use the “Clear All” option
Explanation: The “Clear All” option removes all formatting, contents, and comments from a cell.
What is the purpose of the CONCATENATE function in Excel?
Correct answer:
B) To combine text from multiple cells into one
Explanation: CONCATENATE joins two or more text strings into one.
What does Ctrl + D do in Excel?
Correct answer:
C) Fills the cell below with the content of the current cell
Explanation: Ctrl + D copies the content of the active cell to the cell below.
Which of the following functions returns the highest value in a range?
Correct answer:
B) MAX
Explanation: The MAX function returns the largest number in a specified range of cells.
What does the ISBLANK function do in Excel?
Correct answer:
A) Checks if a cell is empty
Explanation: ISBLANK returns TRUE if the cell is empty and FALSE otherwise.
How do you copy the contents of a cell to the clipboard in Excel?
Correct answer:
A) Press Ctrl + C
Explanation: Ctrl + C copies the contents of the selected cell to the clipboard.
Which of the following features enables you to view two parts of a worksheet at once?
Correct answer:
B) Split
Explanation: The Split feature divides the worksheet window into separate panes so you can view multiple parts simultaneously
What is the shortcut for opening the Print dialog in Excel?
Correct answer:
A) Ctrl + P
Explanation: Ctrl + P opens the Print dialog for printing the worksheet.
What does the RANK function do in Excel?
Correct answer:
B) Calculates the position of a number in a list
Explanation: The RANK function returns the rank of a number within a list of numbers.
How do you toggle between displaying formulas and values in Excel?
Correct answer:
A) Press Ctrl + ` (grave accent)
Explanation: Pressing Ctrl + ` toggles between displaying formulas and the resulting values in the worksheet.
What is the purpose of Data Validation in Excel?
Correct answer:
B) To restrict the type of data that can be entered in a cell
Explanation: Data Validation ensures that only specific types or ranges of data can be entered into a cell
Which Excel function would you use to count cells that meet a specific condition?
Correct answer:
B) COUNTIF
Explanation: COUNTIF counts the number of cells in a range that meet a given condition.
What is the purpose of conditional formatting in Excel?
Correct answer:
B) To highlight cells that meet specific criteria
Explanation: Conditional formatting applies formatting to cells based on the conditions you set.
How do you remove duplicates in a dataset in Excel?
Correct answer:
A) Use the “Remove Duplicates” feature in the Data tab
Explanation: The Remove Duplicates tool helps remove duplicate values in a dataset.
How do you insert a column chart in Excel?
Correct answer:
A) Use the Insert tab and select “Column Chart”
Explanation: The Insert tab provides options to create various charts, including a column chart.
What is the shortcut for selecting an entire row in Excel?
Correct answer:
B) Ctrl + Space
Explanation: Pressing Ctrl + Space selects the entire row of the active cell.
Which of the following is a use of the SUMIF function?
Correct answer:
A) To sum numbers based on a condition
Explanation: SUMIF adds the values in a range that meet a specified condition.
What is the default alignment for text in Excel?
Correct answer:
C) Left
Explanation: By default, Excel aligns text to the left side of the cell.
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.