30 Questions
What is the purpose of using Absolute Reference in Excel?
To reference a cell that should not change when copied to other cells
In Excel Custom Auto Filter, what does an Asterisk (*) symbol represent?
Filters groups of records
What does the formula =PRODUCT(A15 * $B$13) calculate?
Total product value with discount rate
What does 'P????D' signify in Excel Custom Auto Filter?
Six-letter countries starting with P
How can Excel filter all the Managers from a database using custom filters?
Manager
When using '?' in Excel Custom Auto Filter, what is being filtered?
Single characters
What is the main purpose of the Subtotal function in Excel?
Summarize data from a single worksheet
How does the Conditional Formatting feature work in Excel?
Specifies different criteria during formatting
What does the LOGICAL AND function do in Excel?
Checks whether all arguments are TRUE and returns TRUE if so
How does the Concatenate Function differ from the Custom Auto-Filter Command in Excel?
Concatenate text strings from different cells
What is the purpose of the Advanced Filter command in Excel?
Filter multiple records from multiple columns
Why are all Worksheet Formulas said to return a Formula Result?
To return a result based on the formula entered
What does the LOGICAL OR Function in Excel do?
Returns TRUE if any argument is True
What does an Absolute Reference Value in Excel refer to?
A value with constant column and row coordinates when copied
How is a cell uniquely identified within an Excel worksheet?
By both column letters and row numbers
What is the purpose of the Auto Sum - Feature Wizard in Excel?
Provides a quick way to view the Sum Total of an arithmetic operation on a range of cells
What is a Worksheet range in Excel?
A group of cells
Which of the following is NOT a Data Validation criteria in Excel?
Time Validation
What is the purpose of the Custom Auto Filter in Excel?
To filter products that were shipped between specific dates
Where can the Auto Filter command be accessed in Excel?
Data – Auto - Filter
What does the COUNTIF function in Excel help determine?
The number of students that passed the entire exams
What is NOT a function of the Logical IF function in Excel as mentioned in the text?
Filtering data based on specific criteria
What feature does the Auto Filter in Excel exhibit when filtering data according to the text?
Filtering products shipped via Federal Shipping
What is the purpose of the Excel Formula used to determine the percentage of students passing both Maths and English?
To calculate the percentage of students excelling in multiple subjects
What is the correct Excel function used to compute Total Expenditure for the two regions for January and February?
SUMIFS
In the given Excel formula, what type of reference is $J$3?
Absolute Reference
What is the formula used to calculate the % of Students that Passed Either Maths or English?
(Students passed in Maths + Students passed in English) / Total Students
What type of input is needed to define a Range Name in Excel according to the information provided?
Formula
Which menu option in Excel is used to display the Excel Table Simulation Diagram from the INSERT Menu?
Insert
What is the name of the dialog box where the Blue Arrow is pointing to indicate use in formula as a Range Name?
Define Name Dialog Box
Explore essential Excel functions and commands such as Custom Auto-Filter, fx option for formulas, Conditional Formatting, Concatenate Function, and Subtotal function in Excel. Enhance your skills in data filtering, formula creation, text string manipulation, and data summarization.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free