Question 1

What are the steps to sort data out on the MS Excel spreadsheet?

Accepted Answer

Select a cell in the column you want to sort. then Click the Sort & Filter command on the Home tab.  and then Select Sort A to Z, or select Sort Z to A.

Answer

Select a Number in the Row you want to Edit. then Click the Sort & Filter Menu on the Edit tab.  and then Select Sort A to Z, or select Sort Z to A.

Answer

Select  the column you want to filter. then Click the clear Filter command on the Design tab.  and then Select Sort A to W, or select Sort Z to Y.

Answer

Select a cell in the Table you want to remove. then Click the Sort & Filter button on the View tab.  and then Select Sort A to A, or select Sort Z to Z.

Question 2

What are the 3 Text formatting options we can use in MS Excel program?

Accepted Answer

Font Style, Font Color, and Font Size.

Answer

Font tag, Font button, and Font Menu.

Answer

Font Menu, Font Edit, and Font name.

Answer

Font Text, Font Number, and Font Box.

Question 3

What is a Function used in the MS Excel 2007 program?

Accepted Answer

A function is a preset formula in Excel Spreadsheet.

Answer

A function is a preset editing in Excel Spreadsheet.

Answer

A function is a preset animation in Excel Spreadsheet.

Answer

A function is a preset naming in Excel Spreadsheet.

Question 4

Identify each Part of the following Excel formula  " =SUM(B1:B9)"

Accepted Answer

=  Equals sign,                                  SUM  is a Function,                                 ( ) Parantheses                                   B1:B9 Arrguments.

Answer

=  email sign,                                  SUM  is a formula,                                 ( ) brackets                                   B1:B9 Arrangement.

Answer

=  email sign,                                    SUM  is a name,                                     ( ) equal sign,                                B1:B9 letters and numbers.

Answer

=  equals sign,                                 SUM  is active cell,                                   ( ) brackets,                                   B1:B9 letters and signs.

Question 5

Which of the following is an example of an Excel statiscal function?

Accepted Answer

AVERAGE.

Answer

CURRENCY

Answer

PERCENTAGE

Answer

TOTAL

Question 6

What is a Table on the Excel program?

Accepted Answer

It  is a series of worksheet consisted of rows and columns that typically contains related data.

Answer

It  is a series of active cells consisted of columns and columns that typically contains related data.

Answer

It  is a series of name box consisted of rows and worksheet that typically contains related data.

Answer

It  is a series of workbook consisted of active cells  and columns that typically contains related data.

Question 7

How do you modify a Table using  "Table Tools Design Tab" in the Excel 2007 program?

Accepted Answer

We can Insert a Total Row in the Table Styles Options group.

Answer

We can Graph a Total Row in the Table Format Options group.

Answer

We can Write  a Total Row in the Table Design and Options group.

Answer

We can Graph a Total Row in the Table Font style Options group.

Question 8

How do you turn off the filtering arrows that appear on an Excel table ?

Accepted Answer

You select the Home tab, click the Sort & Filter command, and select Filter from the list.

Answer

You select the Edit tab, click the Sort & Filter command, and select Filter from the numbers.

Answer

You select the Design tab, click the Sort & Filter command, and select Filter from the numbers.

Answer

You select the View tab, click the Sort & Filter command, and select Filter from the numbers.

Question 9

What are the 2 types of sorting we use to organize data on MS Excel program?

Accepted Answer

Ascending order ( A --> Z )   and   Descending order ( Z --> A )

Answer

Forms (A --> F) and Reports (F-->A)

Answer

You can organize data in a column A to Column Z.

Answer

You can organize data in a Report only

Question 10

What does the image specify?

Accepted Answer

Remove Filter.

Answer

Add Filter.

Answer

Sort & Filter command.

Answer

Select all Filterings.

Related quizzes

Related quizzes