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
Email:
Name:
What is the shortcut key for the Autosum?
ALT and =
=Sum
ALT and S
CTRL and =
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 display current date only in MS Excel?
Today ()
Now ()
Day ()
Date ()
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
In the formula, which symbol specifies the fixed columns or rows?
#
$
*
%
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
What is the intersection of a column and a row on a worksheet called?
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
__ is used to display values in ascending or descending order.
Validation
Sorting
Order by command
Filter
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
{"name":"Basic Excel", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsInstant feedback on your performanceImprove your skills with challenging scenarios","img":"https:/images/course2.png"}
Powered by: Quiz Maker