Excel Lessons 25-34(Quiz)

Quiz Question 8: Which of the following is an absolute cell reference?

#A2 CORRECT:$A$2

Quiz Question 10: What value would Excel return for this formula? =(82-32)/5+8*2

26

Quiz Question 9: Which of the formulas below are valid? Select all that apply.

= B6 + C6 CORRECT: = B6 + C6 , = R2*D2 , = F2 + F3 + F4 - 53

Goal Seek is used to find result based on the ________ of X value(Where X is the cell property value)

Averages

(All answers in Quizlet is what I submitted, if wrong, I will put the correct answer) Quiz Question 1: The intersection of a row and a column is called a ________.

Cell

Quiz Question 2: A group of cells is called a ________.

Cell Range

Cells can be suggested to be edited but not actually edit the cell content until future use by __________ on the cell

Commenting

Quiz Question 11: What feature did we use to quickly apply the formatting shown in this image?

Conditional Formatting

Before sharing a workbook, Excel protects the safety of the sharing process and the content of the workbook using the tools called...

Document Inspector & Protect Workbook

Slicers are basically an easier yet less efficient _____

Filter

Pivot Charts also ______ & ________ that aid in summarizing data within the workbook.

Filters & Slicers

Quiz Question 14: Which feature starts with a desired result, then calculates the input value that will give that result? (I got a 71)

Goal Seek

To learn how to properly use What-if analysis, Excel provides the tool ____ ____

Goal Seek

Quiz Question 3: Where is the fill handle located?

In the bottom-right Corner of the selected cell

Quiz Question 12: What is the main advantage of selecting the Mark as Final option?

It prevents others from editing the workbook CORRECT: It discourages others from editing the workbook

Quiz Question 4: In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

It's using the Currency number format

____________ are charts used to summarize workbooks and manage the content within and how the content would be presented

Pivot Charts

Quiz Question 13: The four areas in this image are used to create a ________.

Pivot Tables

______ _______ can edit the X value of a row after the subtotal is calculated

Pivot Tables

__________ ______ are templated styles that rows and column can have in a worksheet

Reference styles

The ________ command is considered a Pivot Chart tool because this numeric command helps find the total per x value(X is person, monthly, etc.)

Subtotal

Track Changes can not work if a workbook has ______ in the workbook

Tables

Quiz Question 6: Let's say you're trying to find your average grade. What's wrong with the formula shown in the image?

There is nothing wrong with the formula CORRECT: It should have an = sign at the beginning

______ _______ is the feature that edits multiple cells of highlighted cells within an area

Track Changes

Track Changes are constantly saved after cells are highlighted so the older values can be placed as newer values in different cells, this feature is called...

Track Changes History

Quiz Question 7: True or False: You can view a formula by double-clicking the cell that contains the formula.

True

Excel has the _____-__ _________ which aids in experimenting in worksheets

What-if analysis

Quiz Question 5: You can click the tabs at the bottom of a workbook to switch between ________.

Worksheets

Filters are used to _______ ____ a specific area of the workbooks

narrow down