BNB Excel Basic

A selection of two or more cells is called a ________. Example A1:A4

• cells

• Table

• range

• collected cells

Which is an example of a cell address?

• 126
• A9
• =SUM
• 75/65

What combines one or more cells?

• merge
• wrap text
• cell address

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

What text formula joins the text from two or more cells?

• concatenate

• proper

• left

• e=mc2

Which formula would you use to calculate how many sales are over $20 from a series.

• sum

• sumif

• count

• countif

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

• format cell

• conditional formatting

• fill color

• magic cell

Which tab contains the tool "Freeze Panes"?

• Home

• Page Layout

• View

• Review

What allow quickly apply the content for one cell to another cell?

• Active cell
• Autocell
• Auto sum
• Auto Fill