BCA Final Exam study guide

Which of the following formulas counts the values in cells A1 through A17 which contain Mabry and Branding in cells B1 through B17?

• =COUNTIFS(A1:A17, “Mabry”, B1:B17, “Branding”)

• =COUNTIFS(A1, A17, “Mabry”, B1, B17, “Branding”)

• =COUNTIFS(B1:B17, “Mabry”, A1:A17, “Branding”)

• =COUNTIFS(“Mabry”, A1:A17, “Branding”, B1:B17)

Which of the following formulas adds together values greater than 5000 in cells C2 through C17?

• =SUMIF(C2:C17, “<5000”)

• =SUMIF(C2:C17, “=5000”)

• =SUMIF(C2:C17, “>5000”)

• =SUMIF(C2:C17, “<=5000”)

Which group contains the options to import data?

• Connections

• Get External Data

• Sort and Filter

• Data Tools

Which tab on the Ribbon contains the commands for importing information into Excel?

• View

• Home

• Review

• Data

Which tab holds the command to create a PivotTable?

• Developer

• Insert

• Home

• Page Layout

Which of the following is a small chart in the background of a worksheet cell which provides a visual representation of data?

• Mini-chart

• Sparkline

• Trend line

• Slicer

Which of the following can be added to a chart to show data trends?

• Text box

• Screenshot

• Trendline

• Formulas

Which of the following is a workbook designed with a standard structure and format which makes it easier to capture, organize and edit information?

• Layout

• Data sheet

• Style set

• Form

Which of the following tabs contains the commands to add a text box or shape?

• Insert

• Formulas

• Page Layout

• Home

Which of the following tabs contains the command to add a sparkline to a worksheet?

• Home

• File

• Insert

• Data