What is filtering in Excel?

• viewing data based on certain criteria

• removing blank cells from a worksheet

• arranging data into categories

• sorting data alphabetically

Which chart type would be best for comparing values across categories?

• scatter chart

• column chart

• line chart

• area chart

what is a PivotTable?

• a type of chart

• a tool used to summarize data

• a way to create macros

• a type of a formula

What is the goal of "What-If" analysis?

• to compare different versions of a workbook

• to create charts and graphs

• to calculate maximum and minimum values in a range

• to explore how changing input values affects calculated values

Where is the fill handle located?

• in the bottom-right corner of the selected cell

• at the beginning of any formula or function

• in Backstage view

• on the right side of the Home tab on the Ribbon

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

• It is using a formula.

• It is using conditional formatting.

• It is using the Currency number format.

• It is using absolute cell reference

You can click the tabs at the bottom of a workbook to switch between____________

• permissions

• number formats

• formulas

• worksheets

Which of the following is an absolute cell reference?

• A2

• A:2

• $A$2

• #A2

Which of the formulas below are valid? Select all that apply.

• =R2*D2

• =5B+6B

• =F2+F3+F4-53

• A2+100

The four areas in this image are used to create a ____________

• PivotTable

• complex formula

• subtotal

• custom filter