Free Excel Questions and Answers

Question 1

A ________ is the point where two rows and columns meet.

Accepted Answer

cell

Answer

sum

Answer

chart

Answer

worksheet

Question 2

The ________refers to a group of cells.

Accepted Answer

cell range

Answer

cell cluster

Answer

chart

Answer

multicell

Question 3

What is the location of the filling handle?

Accepted Answer

In the bottom-right corner of the selected cell

Answer

At the beginning of any formula or function

Answer

On the right side of the Home tab on the Ribbon

Answer

In Backstage view

Question 4

True or False:  An Excel file is called a workbook?

Accepted Answer

True

Answer

False

Question 5

What is the best way to remove of cell boarders?

Accepted Answer

Both of Both A and B

Answer

Open the list on Border tool in Format Cell toolbar then choose first tool (none)

Answer

Choose None on Border tab of Format cells

Answer

None of these

Question 6

In Excel, where can you change the shading color for a group of cells?

Accepted Answer

All of the above

Answer

Choose required color on Fill tool in Drawing toolbar

Answer

Choose required color form Patterns tab of Format Cells dialog box

Answer

Choose required color on Fill Color tool in Formatting toolbar

Question 7

When all of the numbers in a range between 0 and 100 should be displayed in red, what command would you use?

Accepted Answer

Apply Conditional Formatting command on Format menu

Answer

Select the cells that contain number between 0 and 100 then click Red color on Text Color Tool

Answer

Use =if() function to format the required numbers red

Question 8

In Excel, you may set the page border.

Accepted Answer

You can not set page border in Excel

Answer

From Border tool in Formatting toolbar

Answer

From Border tab in Format Cells dialog box

Answer

From Line Style tool in Drawing toolbar

Question 9

Which of the following statements about Conditional Formatting is not true?

Accepted Answer

You can set condition to look for Bold and apply Italics on them

Answer

You can add more than one condition to check

Answer

You can delete any condition from Conditional Formatting dialog box if it is not required

Answer

You can apply Font, border and pattern formats that meets the specified conditions

Question 10

Which of the statements below is false?

Accepted Answer

The width of a row and be specified manually or fir automatically.

Answer

Some pictures can be applied as a background of a sheet

Answer

Sheet tabs can be colored

Answer

You can set the column width automatically fit the amount of text