SB Remediation: Excel Test Prep 2

What is the primary goal of the video tutorial?

• To discuss Excel's history

• To review Excel shortcuts

• To introduce basic Excel functions

• To prepare viewers for the Microsoft Excel certification exam

What is the first step in tracking inventory for Tim Beams?

• Creating a pie chart

• Filtering data based on product names

• Applying a title style to cell A1

• Calculating total sales

How do you make a cell reference absolute in a formula?

• By typing 'ABS()' before the cell reference

• By locking the cell with a password

• By using the '%' symbol

• By pressing the 'F4' key

What function is used to alert if inventory levels are below 10%?

• SUM function

• IF function

• AVERAGE function

• VLOOKUP function

What does the IF function do in Excel?

• Sorts data in ascending or descending order

• Finds and replaces text within a cell

• Calculates the sum of specified cells

• Returns one value if a condition is true and another value if it's false

How do you filter data to only show items that start with 'Tim Beibs'?

• Applying a custom sort

• Using the 'Contains' text filter

• Creating a pivot table

• Using the 'Begins With' text filter

What is the correct way to adjust the alignment by deleting specific cells?

• Using the 'Align Text Left' option

• Deleting cells B19 to D19

• Deleting the entire row

• Moving the cells manually

How do you add a filter to display only specific product IDs?

• Inserting a new column

• Clicking the filter button on the Data tab

• Applying a color scale

• Using conditional formatting

How do you adjust a column's width to a specific value?

• Through the Format option under the Home tab

• By dragging the column's border

• By double-clicking the column header

• Using the 'AutoFit Column Width' option

What is the purpose of wrapping text in cells?

• To fit longer text into the cell without increasing its width

• To change the font size automatically

• To merge cells together

• To increase cell height automatically