Which Excel function returns the number of characters in a text string?
Correct answer: A
LEN returns the total number of characters in a given text string.
Computer
✓ 0
✗ 0
Your Result
0 correct out of 0 attempted (0%)
Which Excel function converts all letters in a text string to uppercase?
Correct answer: C
UPPER converts all lowercase letters in a text string to uppercase.
Which Excel function converts all letters in a text string to lowercase?
Correct answer: C
LOWER converts all uppercase letters in a text string to lowercase.
Which Excel function capitalizes the first letter of each word in a text string?
Correct answer: D
PROPER capitalizes the first letter of every word in a text string.
Which Excel function removes extra spaces from a text string, leaving single spaces between words?
Correct answer: D
TRIM removes leading, trailing, and extra internal spaces from text.
Which Excel function evaluates a condition and returns one value if true and another if false?
Correct answer: D
The IF function returns one result if a condition is true and another if it's false.
Which Excel function returns a specified value if a formula results in an error, and the normal result otherwise?
Correct answer: A
IFERROR returns a specified fallback value when a formula would otherwise produce an error.
Which Excel function returns TRUE only if all supplied conditions are true?
Correct answer: C
The AND function returns TRUE only when every specified condition is true.
Which Excel function returns TRUE if at least one of the supplied conditions is true?
Correct answer: D
The OR function returns TRUE if any one of the specified conditions is true.
Which Excel function reverses a logical value, turning TRUE into FALSE and vice versa?
Correct answer: A
The NOT function reverses the logical value of its argument.
Which Excel function returns today's date, updating automatically each day?
Correct answer: D
TODAY returns the current date and updates automatically whenever the sheet recalculates.
Which Excel function returns the current date and time?
Correct answer: B
NOW returns the current date and time, updating on recalculation.
Which Excel function calculates a loan or investment payment based on constant payments and interest rate?
Correct answer: D
PMT calculates the periodic payment for a loan based on constant payments and interest rate.
Which Excel function calculates the future value of an investment based on periodic, constant payments?
Correct answer: B
FV calculates the future value of an investment given regular payments and a fixed rate.
Which Excel function calculates the present value of an investment or loan?
Correct answer: B
PV calculates the present value of a series of future cash flows.
Which Excel feature lets you quickly copy a formula or value to adjacent cells by dragging a small square at the cell's corner?
Correct answer: A
The fill handle is a small square at the bottom-right of a selected cell used to drag and copy content.
Which Excel toolbar button automatically inserts a SUM formula for a selected range?
Correct answer: A
The AutoSum button quickly inserts a SUM formula for adjacent numeric cells.
Which Excel feature keeps specified rows or columns visible while scrolling through the rest of the worksheet?
Correct answer: A
Freeze Panes keeps selected rows/columns visible on screen while scrolling.
Which Excel feature arranges data in ascending or descending order based on one or more columns?
Correct answer: B
Sort arranges data in a specified order, ascending or descending, based on column values.
Which Excel feature temporarily hides rows that don't match specified criteria, without deleting data?
Correct answer: D
Filter hides rows that don't meet the chosen criteria, without deleting any data.
Which Excel feature automatically changes a cell's appearance (like color) based on its value meeting certain rules?
Correct answer: B
Conditional Formatting changes a cell's visual appearance based on rules applied to its value.
Which Excel feature restricts what type of data can be entered into a cell, such as only whole numbers?
Correct answer: C
Data Validation restricts allowable input, ensuring only certain types or ranges of data can be entered.
Which Excel feature summarizes large amounts of data by allowing dynamic grouping, filtering, and aggregation?
Correct answer: A
A PivotTable summarizes and analyzes large datasets through dynamic grouping and aggregation.
Which Excel feature creates a visual graphic representation of data, such as a bar or line graph?
Correct answer: C
Charts create visual representations of worksheet data, such as bar or line graphs.
Which Excel chart type is best suited to show proportions of a whole, like percentage market share?
Correct answer: B
A pie chart visually represents parts of a whole as slices of a circle.