What is a single Excel file, which can contain multiple worksheets, called?
Correct answer: D
A workbook is the entire Excel file, which can contain one or more worksheets.
Computer
✓ 0
✗ 0
Your Result
0 correct out of 0 attempted (0%)
What is an individual page within an Excel workbook called?
Correct answer: C
A worksheet, or sheet, is a single page of cells within a workbook.
Which symbol must every Excel formula begin with?
Correct answer: C
Every Excel formula begins with an equals sign to signal a calculation.
Which Excel function adds up a range of numbers?
Correct answer: A
The SUM function adds together all numbers in the specified range.
Which Excel function calculates the average (mean) of a range of numbers?
Correct answer: A
The AVERAGE function calculates the mean value of a range of numbers.
Which Excel function counts how many cells in a range contain numbers?
Correct answer: A
COUNT counts the number of cells containing numeric values in a range.
Which Excel function counts how many cells in a range are not empty, regardless of content type?
Correct answer: B
COUNTA counts all non-empty cells, whether they contain numbers, text, or other data.
Which Excel function counts how many cells in a range are empty?
Correct answer: A
COUNTBLANK counts the number of empty cells within a specified range.
Which Excel function counts cells that meet a single specified condition?
Correct answer: C
COUNTIF counts the number of cells that meet one specified criterion.
Which Excel function adds up values in a range that meet a single specified condition?
Correct answer: C
SUMIF adds the values in cells that meet one specified criterion.
Which Excel function calculates the average of cells that meet a single specified condition?
Correct answer: B
AVERAGEIF calculates the average of cells that meet one specified criterion.
Which Excel function finds the largest value in a range?
Correct answer: D
The MAX function returns the largest value in the specified range.
Which Excel function finds the smallest value in a range?
Correct answer: C
The MIN function returns the smallest value in the specified range.
Which Excel function finds the middle value (median) of a set of numbers?
Correct answer: C
The MEDIAN function returns the middle value when the numbers are sorted.
Which Excel function finds the most frequently occurring value in a set of numbers?
Correct answer: B
The MODE function returns the value that appears most frequently in a data set.
Which Excel function looks up a value in the leftmost column of a table and returns a value in the same row from a specified column?
Correct answer: B
VLOOKUP searches vertically (down a column) for a value and retrieves related data.
Which Excel function looks up a value in the top row of a table and returns a value from a specified row?
Correct answer: B
HLOOKUP searches horizontally (across a row) for a value and retrieves related data.
Which Excel function returns the value at a given row and column intersection within a range?
Correct answer: D
INDEX returns a value from a specific position within a given range.
Which Excel function returns the relative position of a value within a range?
Correct answer: C
MATCH returns the position of a specified value within a range.
Which Excel function combines text from multiple cells into one cell?
Correct answer: A
CONCATENATE (or CONCAT) joins text from multiple cells into a single string.
Which Excel function converts a number into text formatted according to a specified format?
Correct answer: D
The TEXT function converts a number to text in a specified display format.
Which Excel function converts text that represents a number into an actual numeric value?
Correct answer: D
The VALUE function converts a text string representing a number into a numeric value.
Which Excel function extracts a specified number of characters from the left side of a text string?
Correct answer: B
LEFT extracts a set number of characters starting from the left of a text string.
Which Excel function extracts a specified number of characters from the right side of a text string?
Correct answer: D
RIGHT extracts a set number of characters starting from the right of a text string.
Which Excel function extracts characters from the middle of a text string, given a start position and length?
Correct answer: A
MID extracts a substring from a specified starting position for a given length.