Quiz | Croma Campus

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 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 average of a range excluding zeros?

MEDIAN
AVERAGEA
AVERAGEIF
COUNTIF

Mark for review

How do you create a pivot table?

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

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 function can be used to check if a cell contains an error?

ISBLANK
ISNUMBER
ISFORMULA
ISERROR

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

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 is used to find the smallest number in a range?

MAX
MIN
AVERAGE
SUM

Mark for review

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

FV
PV
NPV
RATE

Mark for review

How do you create a dynamic named range in Excel?

Use COUNTA function
Use OFFSET function
Use VLOOKUP function
Use IF function

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 does the PMT function calculate?

Interest rate
Total amount
Investment return
Loan payments

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

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

AVERAGE
MEDIAN
MODE
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 apply conditional formatting to a cell range?

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

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

How do you freeze panes in Excel?

Data > Freeze Panes
View > Freeze Panes
Review > Freeze Panes
Home > Freeze Panes

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 add a filter to a range of data?

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

Mark for review

What is the shortcut key for creating a new worksheet in Excel?

Ctrl + Shift + N
Ctrl + V
Ctrl + T
Ctrl + W

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

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

AVERAGE
MIN
MAX
SUM

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

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

What does VLOOKUP stand for?

Value Lookup
Vertical Lookup
Visual Lookup
Variable Lookup

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 can you use the IF function to test multiple conditions?

OR
AND
XOR
Nested IF

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

Online Exam Quiz

Online

Did you like this Question

Get a 1:1 Mentorship call with our Career Advisor