-
web.groovymark@gmail.com
- December 8, 2024
Question 21
How can you format cells to display values as percentages?
A. Right-click and choose “Number Format”
B. Use the Formula Bar
C. Select “Data Validation”
D. Use the “Review” tab
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
What does the COUNT function do in Excel?
A. Counts the number of cells in a range
B. Counts only the empty cells in a range
C. Counts the number of numeric values in a range
D. Counts the number of characters in a cell
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
Which of the following tools automatically totals the selected cells in Excel?
A. Data Validation
B. AutoSum
C. Trace Precedents
D. Conditional Formatting
Answer: B. AutoSum
Explanation: AutoSum quickly adds up the values of selected cells and displays the total.
Question 24
Which tool allows you to organize and view large datasets by category?
A. PivotTable
B. Solver
C. Data Validation
D. Conditional Formatting
Answer: A. PivotTable
Explanation: PivotTables help you organize large datasets by summarizing data into categories.
Question 25
What type of chart is used to show trends over time?
A. Pie Chart
B. Line Chart
C. Bar Chart
D. Scatterplot
Answer: B. Line Chart
Explanation: A Line Chart is commonly used to display trends or changes over time.
Question 26
What function would you use to return the current date in a cell?
A. =NOW()
B. =DATE()
C. =TODAY()
D. =TIME()
Answer: C. =TODAY()
Explanation: The TODAY function returns the current date without the time.
Question 27
Which of the following is NOT a valid argument in the IF function?
A. Logical Test
B. Value_if_True
C. Condition
D. Value_if_False
Answer: C. Condition
Explanation: The correct arguments for an IF function are Logical Test, Value_if_True, and Value_if_False.
Question 28
How can you quickly remove the formatting from a range of cells?
A. Clear All
B. Clear Formats
C. Data Validation
D. Remove Conditional Formatting
Answer: B. Clear Formats
Explanation: The Clear Formats option removes only the formatting, leaving the cell content intact.
Question 29
Which of the following can be used to compare the parts of a whole?
A. Line Chart
B. Pie Chart
C. Scatterplot
D. Column Chart
Answer: B. Pie Chart
Explanation: Pie Charts are used to compare individual sections to the whole.
Question 30
What does the CONCATENATE function do in Excel?
A. Combines the values of multiple cells into one
B. Sums up the values in a range
C. Converts text to numeric values
D. Changes the format of numbers
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
Which of the following represents an absolute cell reference?
A. A1
B. $A$1
C. A$1
D. $A1
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
What is the shortcut to display formulas instead of their results in Excel?
A. Ctrl + F3
B. Ctrl + F2
C. Ctrl + `
D. Ctrl + 1
Answer: C. Ctrl + `
Explanation: Ctrl + ` toggles between displaying formulas and results in cells.
Question 33
What type of chart is best used to display the relationship between two variables?
A. Pie Chart
B. Bar Chart
C. Line Chart
D. Scatterplot
Answer: D. Scatterplot
Explanation: A Scatterplot is used to show the relationship or correlation between two variables.
Question 34
How do you repeat the last action in Excel?
A. Ctrl + Z
B. Ctrl + Y
C. Ctrl + R
D. Ctrl + Shift + Y
Answer: B. Ctrl + Y
Explanation: Ctrl + Y repeats the last action performed in Excel.
Question 35
What feature allows you to visualize the magnitude of values in Excel cells with colors?
A. Data Validation
B. Trace Precedents
C. Conditional Formatting
D. Data Bars
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
Which function calculates the number of non-empty cells in a range?
A. COUNT
B. COUNTA
C. COUNTBLANK
D. AVERAGE
Answer: B. COUNTA
Explanation: COUNTA counts the number of non-empty cells, regardless of whether they contain text, numbers, or formulas.
Question 37
What would you use to remove duplicate values from a dataset in Excel?
A. Filter
B. Sort
C. Conditional Formatting
D. Remove Duplicates
Answer: D. Remove Duplicates
Explanation: The Remove Duplicates tool eliminates repeated values from a dataset.
Question 38
How do you apply a filter to a dataset in Excel?
A. Use the Filter button under the HOME tab
B. Use the Filter option under the DATA tab
C. Right-click and select Filter
D. Use the Sort function
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
What is the default alignment for text in Excel cells?
A. Left
B. Right
C. Center
D. Justify
Answer: A. Left
Explanation: By default, text in Excel is aligned to the left of the cell.
Question 40
Which Excel function rounds a number to a specified number of decimal places?
A. ROUND
B. CEILING
C. FLOOR
D. TRUNC
Answer: A. ROUND
Explanation: The ROUND function rounds a number to the specified number of decimal places.
