Excel Day 1

What symbol is used to start a formula in Excel?

• =

• +

• -

• @

What type of referencing will reference cells by their position in relation to the cell listed.

• Absolute

• Relative

• Mixed

• Reference across sheets

What formula would be in cell B2

• A2*$D1

• A2*$D$1

• =A2*$D$1

• =A2*D1

Which function in Excel is used to calculate the sum of numbers?

• SUM()

• AVERAGE()

• COUNT()

• MAX()

When referencing across sheets, what goes around the sheet name?

• "Galley Grub"

• ,Galley Grub,

• 'Galley Grub'

• (Galley Grub)

Do operators belong to Formula's or Function?

• Formula

• Function

What is wrong with this equation?

SUM'Sheet1'A2:A6

• I'm not sure

• It's correct

• No equal sign

Which Excel function can be used to count the number of cells that contain numbers?

• COUNT()

• SUM()

• AVERAGE()

• COUNTNUM()

How can you quickly copy a formula to adjacent cells in Excel?

• Use the fill handle

• Copy and paste

• Drag the cell corner

• All of the above

When is your excel simulation 2 due? (lowercase)