Quiz | Croma Campus

Which function is used to return the number of characters in a text string?

FIND
LEN
CHAR
TEXT

Mark for review

How can you remove duplicate values from a dataset?

Home > Remove Duplicates
Data > Remove Duplicates
View > Remove Duplicates
Insert > Remove Duplicates

Mark for review

How do you use the SUBTOTAL function?

To perform calculations on filtered data
To find average of a range
To count numbers in a range
To calculate total of a range

Mark for review

Which Excel function can be used to count the number of cells that contain numbers?

COUNT
COUNTIF
COUNTA
COUNTBLANK

Mark for review

Which function is used to look up a value in a table and return a corresponding value from another column?

MATCH
VLOOKUP
HLOOKUP
INDEX

Mark for review

Which function is used to return the current date and time?

TIME
TODAY
DATE
NOW

Mark for review

Which function is used to find the median value of a set of numbers?

AVERAGE
MEDIAN
MODE
SUM

Mark for review

Which function is used to find the smallest number in a range?

MAX
MIN
AVERAGE
SUM

Mark for review

What does the COUNTIF function do?

Counts all cells
Counts cells with numbers
Counts cells with text
Counts the number of cells that meet a condition

Mark for review

How do you create a pivot table?

Data > PivotTable
Home > PivotTable
Insert > PivotTable
Review > PivotTable

Mark for review

Which function calculates the standard deviation of a dataset?

STDEV.P
AVERAGE
COUNT
SUM

Mark for review

How do you add a comment to a cell in Excel?

Data > Add Comment
Right-click > Insert Comment
Home > Add Comment
Review > New Comment

Mark for review

How can you use the IF function to test multiple conditions?

OR
AND
XOR
Nested IF

Mark for review

Which function is used to calculate the future value of an investment?

FV
PV
NPV
RATE

Mark for review

What is the purpose of the INDEX function?

To return a value from a specific cell in a range
To calculate the median
To return a value from a specific cell
To find the maximum value

Mark for review

How do you use the REPLACE function?

To convert text to numbers
To replace part of a text string
To extract a text string
To find a text string

Mark for review

Which function can be used to check if a cell contains an error?

ISBLANK
ISNUMBER
ISFORMULA
ISERROR

Mark for review

Which function calculates the average of a range excluding zeros?

MEDIAN
AVERAGEA
AVERAGEIF
COUNTIF

Mark for review

What function is used to calculate the internal rate of return for a series of cash flows?

NPV
IRR
PV
RATE

Mark for review

What is the purpose of the MATCH function?

To return a value from a specific cell
To find the position of a value in a range
To calculate the median
To find the maximum value

Mark for review

Which function is used to return the largest value in a range?

AVERAGE
MIN
MAX
SUM

Mark for review

What is the function of the HLOOKUP function in Excel?

Horizontal Lookup
High Lookup
Hyperlink Lookup
Hierarchical Lookup

Mark for review

How do you protect a worksheet from being edited?

Home > Protect Sheet
Review > Protect Sheet
View > Protect Sheet
Data > Protect Sheet

Mark for review

How do you apply conditional formatting to a cell range?

Insert > Conditional Formatting
Home > Conditional Formatting
Data > Conditional Formatting
Review > Conditional Formatting

Mark for review

What is the shortcut for pasting values only in Excel?

Ctrl + Shift + Alt + V
Ctrl + Shift + V
Ctrl + Alt + V
Ctrl + V

Mark for review

Which Excel function returns the next highest integer?

ROUND
INT
CEILING
FLOOR

Mark for review

What is the use of the PMT function in Excel?

To calculate present value
To calculate future value
To calculate interest rates
To calculate loan payments

Mark for review

What is the purpose of the TRANSPOSE function?

To format rows and columns
To switch rows and columns
To delete rows and columns
To add rows and columns

Mark for review

Which function can be used to calculate the present value of an investment?

Mark for review

What is the purpose of the OFFSET function?

To return the maximum value
To return the minimum value
To return a reference to a range of cells
To calculate average

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor