Excel Study Guide – Part 1
30 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of using Absolute Reference in Excel?

  • To filter a single character
  • To reference a cell that should not change when copied to other cells (correct)
  • To calculate the total product value
  • To determine the commission rate

In Excel Custom Auto Filter, what does an Asterisk (*) symbol represent?

  • Filters groups of records (correct)
  • Filters single characters
  • Filters managers
  • Filters six-letter countries

What does the formula =PRODUCT(A15 * $B$13) calculate?

  • Total commission value
  • Total number of products sold
  • Total discount amount
  • Total product value with discount rate (correct)

What does 'P????D' signify in Excel Custom Auto Filter?

<p>Six-letter countries starting with P (B)</p> Signup and view all the answers

How can Excel filter all the Managers from a database using custom filters?

<p><em>Manager</em> (D)</p> Signup and view all the answers

When using '?' in Excel Custom Auto Filter, what is being filtered?

<p>Single characters (A)</p> Signup and view all the answers

What is the main purpose of the Subtotal function in Excel?

<p>Summarize data from a single worksheet (D)</p> Signup and view all the answers

How does the Conditional Formatting feature work in Excel?

<p>Specifies different criteria during formatting (D)</p> Signup and view all the answers

What does the LOGICAL AND function do in Excel?

<p>Checks whether all arguments are TRUE and returns TRUE if so (D)</p> Signup and view all the answers

How does the Concatenate Function differ from the Custom Auto-Filter Command in Excel?

<p>Concatenate text strings from different cells (C)</p> Signup and view all the answers

What is the purpose of the Advanced Filter command in Excel?

<p>Filter multiple records from multiple columns (D)</p> Signup and view all the answers

Why are all Worksheet Formulas said to return a Formula Result?

<p>To return a result based on the formula entered (B)</p> Signup and view all the answers

What does the LOGICAL OR Function in Excel do?

<p>Returns TRUE if any argument is True (D)</p> Signup and view all the answers

What does an Absolute Reference Value in Excel refer to?

<p>A value with constant column and row coordinates when copied (A)</p> Signup and view all the answers

How is a cell uniquely identified within an Excel worksheet?

<p>By both column letters and row numbers (B)</p> Signup and view all the answers

What is the purpose of the Auto Sum - Feature Wizard in Excel?

<p>Provides a quick way to view the Sum Total of an arithmetic operation on a range of cells (C)</p> Signup and view all the answers

What is a Worksheet range in Excel?

<p>A group of cells (A)</p> Signup and view all the answers

Which of the following is NOT a Data Validation criteria in Excel?

<p>Time Validation (A)</p> Signup and view all the answers

What is the purpose of the Custom Auto Filter in Excel?

<p>To filter products that were shipped between specific dates (C)</p> Signup and view all the answers

Where can the Auto Filter command be accessed in Excel?

<p>Data – Auto - Filter (B)</p> Signup and view all the answers

What does the COUNTIF function in Excel help determine?

<p>The number of students that passed the entire exams (A)</p> Signup and view all the answers

What is NOT a function of the Logical IF function in Excel as mentioned in the text?

<p>Filtering data based on specific criteria (A)</p> Signup and view all the answers

What feature does the Auto Filter in Excel exhibit when filtering data according to the text?

<p>Filtering products shipped via Federal Shipping (C)</p> Signup and view all the answers

What is the purpose of the Excel Formula used to determine the percentage of students passing both Maths and English?

<p>To calculate the percentage of students excelling in multiple subjects (B)</p> Signup and view all the answers

What is the correct Excel function used to compute Total Expenditure for the two regions for January and February?

<p>SUMIFS (A)</p> Signup and view all the answers

In the given Excel formula, what type of reference is $J$3?

<p>Absolute Reference (C)</p> Signup and view all the answers

What is the formula used to calculate the % of Students that Passed Either Maths or English?

<p>(Students passed in Maths + Students passed in English) / Total Students (D)</p> Signup and view all the answers

What type of input is needed to define a Range Name in Excel according to the information provided?

<p>Formula (B)</p> Signup and view all the answers

Which menu option in Excel is used to display the Excel Table Simulation Diagram from the INSERT Menu?

<p>Insert (A)</p> Signup and view all the answers

What is the name of the dialog box where the Blue Arrow is pointing to indicate use in formula as a Range Name?

<p>Define Name Dialog Box (B)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser