Excel Test
Which of the following logical operator means "not equal to"?
<>
Which of the following command allows you to highlight data records with important features? (For instance, we can use red color to highlight stock price data that are greater than $500)
Conditional Formatting
Which of the following command allows you to highlight data records with important features? (For instance, we can use red color to highlight stock price data that are greater than $500):
Conditional Formatting
Is the following statement TRUE or FALSE? In the value field settings, we cannot use Average function to summarize value field.
False
Is the following statement TRUE or FALSE? Subtotal command means that you can only use "SUM" function.
False
Is the following statement TRUE or FALSE? When you want to hide all the records in your list except those that meet certain criteria, you can use the Conditional Formatting command.
False
Is the following statement TRUE or FALSE? You are trying to find total sales for each department in your company. You do not have to sort by department names first, you can just use subtotal command directly.
False
What does Goal Seek do?
Goal Seek allows a value in a formula to be adjusted to reach a desired result or answer.
Which of the following function allows you to make logical comparisons between a value and what you expect? For example, you want to assign "YES" to the students with grades higher than 80 and "NO" to the students with grades lower than 80
IF
Which of the following function allows you to make logical comparisons between a value and what you expect? For example, you want to assign "YES" to the students with grades higher than 80 and "NO" to the students with grades lower than 80:
IF
Which of the following is TRUE about Pivot Table?
The output in the cells of the table are read-only data
Which statement is NOT correct about Trend function and Growth function?
The regression line produced by Trend function will not change if we change the existing data records
Suppose you are a business analyst in Schweizer Distribution company. The company's founder, Bob Schweizer, is eager to hear your thoughts and idea on how to improve the business. You decide to build a Pivot Table to answer one of Bob's questions: "Who is the best sales representative's best-selling product (by total profit) from year 2008 to year 2018?" When you are building this Pivot Table, which of the following will go to Data Field (or sometimes we call it Value Field)?
Total Profit
In the video you watched, the professor is trying to solve which of the following problem
Maximizing the profit for a smoothie store
Which of the following command allows you to know the date?
Now
What does Trend function do?
Produces a regression line which then predicts values from existing data
Is the following statement TRUE or FALSE? Although the data that appear in pivot tables look like any other worksheet data, the data in the data area of the PivotTable feature cannot be directly entered or changed.
True
Is the following statement TRUE or FALSE? If you have records in your list that have identical entries in the column you are sorting, you can specify additional sorting criteria to further organize your list by creating your own custom sort order.
True
Is the following statement TRUE or FALSE? If you want to change all the rows in your worksheet to the same height, click the Select All button (the gray box above Row 1 and to the left of column A).
True
Is the following statement TRUE or FALSE? We can build a pivot chart that is based on the data in a pivot table.
True
Is the following statement TRUE or FALSE? We don't need to enter a formula for variable cells (the by changing cell value in the solver dialog box)
True
Is the following statement True or False? AND function checks if an Excel record meets multiple conditions? For example, if both condition "car type is Sedan" and "cost is below $50,000" hold, AND function will return "TRUE".
True
Is the following statement True or False? Goal Seek can eliminate unnecessary calculations that can be used to determine a single variable value in a formula.
True
Which of the following helps you optimize the result of a model?
Slover
Which of the following command allows you to arrange the records in a different order?
Sort
Which of the following is TRUE about absolute reference (e.g. $A$2)
The column and the row do not change when formula is copied
Which of the following is TRUE about absolute reference (e.g. $A$2):
The column and the row do not change when formula is copied
Is the following statement True or False? OR function checks if an Excel record meets at least one condition? For example, if either condition "car type is Sedan" or "cost is below $50,000" holds, OR function will return "TRUE".
True
Is the following statement True or False? The limitation of Goal Seek is that you can only use it for one cell at each time.
True
Which of the following function helps you find things in a table or a range by rows. For example, find the price of coffee mug from another worksheet
VLOOKUP
Which of the following function helps you find things in a table or a range by rows. For example, find the price of coffee mug from another worksheet:
VLOOKUP
In the videos you watched, two Goal Seek examples are provided. What are the goals of these two examples? (Please select two answers)
A. In order to get a 70 for the final grade, we use Goal Seek to find the grade for test 3. B. In order to meet the budget of $500, we use Goal Seek to find the number of guests
Which of the following is TRUE about Pivot Table
A. The PivotTable feature analyzes, summarizes, and manipulates data in large lists, databases, worksheets, or other collections. B. The PivotTable feature is linked to the source data C. The formatting (number, alignment, font, etc.) of the Pivot Table can be changed D. All of the above
Which of the following command allows you to change the appearance of the data (font, colors, sizes...) in your worksheet but not to change their values?
Formatting
Which of the following command allows you to add some extra space or more information into your worksheet?
Insert
9. Which of the following is TRUE about subtotal?
It helps you organize and analyze a list by displaying records in groups and inserting summary information
Which of the following is TRUE about subtotal?
It helps you organize and analyze a list by displaying records in groups and inserting summary information
Which of the following is NOT CORRECT about solver?
Once we find the optimal solution, we cannot edit solver for a new goal
What is the maximum number of cells you can select for Set Objective value in the solver dialog box?
Only 1
