Basic Excel

Generate an educational illustration related to Excel, featuring a computer screen with spreadsheet data, graphs, and charts, alongside tools like a calculator and a pencil, presented in a bright and engaging style.

Master Your Excel Skills

Join our exciting quiz designed for Excel enthusiasts looking to assess their knowledge on basic functions and features. Whether you're a beginner or have some experience, this quiz serves as an engaging way to enhance your Excel mastery.

Key Features:

22 thought-provoking questions
Instant feedback on your performance
Improve your skills with challenging scenarios

22 Questions6 MinutesCreated by LearningExcel247

What is the formula for finding the average of numbers?

AVERAGE (NUMBER1 + NUMBER 2 + NUMBER 3….)

AVERAGE (SUM OF NUMBERS)

Both of the above

None of the above

_____________ function can be used when you want to get the day value (ranging between 1 to 31) from a specified date

__________________ Function is best suited for situations where you want to evaluate a condition, and the return a value if it is TRUE and another value if it is FALSE.

How do you wrap the text in a cell?

Adjust cell height and width

Format cells alignment

Merge cells

All of the above

What does COUNTA () function do?

Counts cells having number

Counts non-empty cells

Counts empty cells

Counts cells having texts

You can check the conditions against __________ when applying conditional formatting

Cell Value

Formula

Both

None of the above

X Co. Is looking into three of the potential projects and will accept the project only if the IRR from the project is expected to be 12% or above. What formula shows whether to accept or reject the projects under consideration?

IF(B$13>12,”accept”,”reject”)

IF(B13>12,”accept”,”reject”)

IF(B$13>12,accept,reject)

IF(B13>12,accept,reject)

_____________ function can be used when you want to return a number rounded to a specified number of digits.

______________ function can be used when you want to get the smallest value from a set of values.

Excel Min

Minimum

Excel smallest

None

_________________ function can be used when you want to join 2 or more characters or strings. It can be used to join text, numbers, cell references, or a combination of these.

Merge

Join

Concatenate

Combine

The Greater than sign (>) is an example of ____________ operator?

Mathematical

Logical

Conditional

Statistical

The _____________________ feature of MS Excel quickly completes a series of data.

Auto Complete

Auto Fill

Fill Handle

Sorting

Which of the following formulas will Excel Not be able to calculate?

=SUM(A1:A5)-10

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)*.5

=SUM(Sales)-A3

Which of the following statements about Conditional Formatting is not true?

You can set condition to look for Bold and apply Italics on them

You can add more than one condition to check

You can apply Font, border and pattern formats that meets the specified conditions

You can delete any condition from Conditional Formatting dialog box if it is not required

Suppose you have a list of students along with their GPA scores. You want to find the name of the student with the Highest GPA score. Which of the following options can be used?

Sort

Find

Filter

Ascend

Basic Excel

Master Your Excel Skills

More Quizzes