FOD Topic 1

Which of the following is/are correct?

• Range is a selection of cells

• When data is organised in rows and columns, it visually resembles a table.

• Excel Table allows users to manage and analyse data more effectively.

• Cell consists of Row and Column

Which of the following is/are correct about Excel Table?

• It can be easily formatted with table styles

• It does not automatically expand or contract as you add or remove rows and columns

• It is integrated with sort and filter feature

• Column headings remain visible while scrolling

Which of the following is/are correct about an Excel Table?

• When naming a table, the default table name is Table1, Table2, ...

• "Stock Price"

  can be a valid table name

• It is a good practice to give the table a name.

• "PhoneInventory" can be a valid table name

Which of the following is/are correct about B$5?

• It is a relative reference

• It is an absolute reference

• Row 5 is fixed

• Column B is fixed

• It is a mixed reference

What will you get if you apply this function?
=COUNTA (A1:A13)

• 12

• 13

• 11

• 14

What will you get if you apply this function?
=SUM (A11:A12)

• 12

• 15

• 232.6

• 14

What will you get if you apply this function?
=COUNTIF (B1:B13,"=2017")

• 1

• 2

• 11

• 14

What is the Cell Address of "China"?

• 1A

• A1

• A7

• B7

Quick Access Toolbar allows you to save time by letting you place your frequently used commands for quick access

• TRUE

• FALSE

Page Break view allows you to visually manage how your worksheet will be divided into pages when printed.

• TRUE

• FALSE