Quiz | Croma Campus

How do you create a drop-down list in Excel?

Data Validation
Conditional Formatting
Table Tools
Format Cells

Mark for review

What function would you use to return a value from a specific row and column in a table?

MATCH
INDEX
VLOOKUP
HLOOKUP

Mark for review

Which function calculates the standard deviation of a dataset?

STDEV.P
AVERAGE
COUNT
SUM

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 formula will round a number to the nearest integer?

ROUNDUP
ROUND
INT
ROUNDDOWN

Mark for review

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

AVERAGE
MEDIAN
MODE
SUM

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 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

Which function is used to find the mode of a dataset?

MEDIAN
AVERAGE
SUM
MODE

Mark for review

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

Mark for review

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

TIME
TODAY
DATE
NOW

Mark for review

What does VLOOKUP stand for?

Value Lookup
Vertical Lookup
Visual Lookup
Variable Lookup

Mark for review

Which function calculates the average of a range excluding zeros?

MEDIAN
AVERAGEA
AVERAGEIF
COUNTIF

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 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 create a macro in Excel?

View > Record Macro
Data > Record Macro
Developer > Record Macro
Home > Record Macro

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 calculate the future value of an investment?

FV
PV
NPV
RATE

Mark for review

What is the purpose of the SUMIF function?

To count values based on a condition
To sum values based on multiple conditions
To sum all values
To sum values based on a single condition

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

How do you create a pivot table?

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

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 can be used to calculate the present value of an investment?

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

What is the purpose of the CONCATENATE function?

To join multiple text strings into one
To format cells
To split text strings
To count text occurrences

Mark for review

How do you hide columns in Excel?

View > Hide Columns
Data > Hide Columns
Home > Hide Columns
Right-click > Hide

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

What is the function of the ROUNDUP function?

To round a number to the nearest specified value
To round a number up, away from zero
To round a number down, toward zero
To round a number to the nearest integer

Mark for review

How do you add a filter to a range of data?

View > Filter
Data > Filter
Insert > Filter
Home > Filter

Mark for review

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor