logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

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

  • Data Validation
  • Conditional Formatting
  • Table Tools
  • Format Cells
Mark for review

What does the PMT function calculate?

  • Interest rate
  • Total amount
  • Investment return
  • Loan payments
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 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 protect a worksheet from being edited?

  • Home > Protect Sheet
  • Review > Protect Sheet
  • View > Protect Sheet
  • Data > Protect Sheet
Mark for review

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

  • TIME
  • TODAY
  • DATE
  • NOW
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

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

How do you create a pivot table?

  • Data > PivotTable
  • Home > PivotTable
  • Insert > PivotTable
  • Review > PivotTable
Mark for review

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

  • NPV
  • PV
  • IRR
  • FV
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

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

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

  • FV
  • PV
  • NPV
  • RATE
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 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 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 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

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

  • MAX
  • MIN
  • AVERAGE
  • 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 create a dynamic named range in Excel?

  • Use COUNTA function
  • Use OFFSET function
  • Use VLOOKUP function
  • Use IF function
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 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 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 number of characters in a text string?

  • FIND
  • LEN
  • CHAR
  • TEXT
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 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

Which function calculates the standard deviation of a dataset?

  • STDEV.P
  • AVERAGE
  • COUNT
  • SUM
Mark for review

Which formula will round a number to the nearest integer?

  • ROUNDUP
  • ROUND
  • INT
  • ROUNDDOWN
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session