Form 2 Excel Test

Is this your test? Login to manage it. If not, you can create an exam just like it.

This is a non-interactive preview of the quiz content.

1 point

The formula bar shows

formulas only

name of the worksheet

the content of the current cell

numbers only

1 point

All files in Microsoft Excel 2007 and 2010 end in which extension

.xlc and .Ex

.xlsx and .xls

.xls and .excel

.xlsx and .xlsl

1 point

A Cell Reference is

A row and a column

A Row

A column

A formula

1 point

#VALUE means

The value of the formula cannot be shown

The formula accesses a value that is currency

The values in the formula is wrong

The formula accesses a value that is non-numeric

1 point

The name box holds

THe name of the worksheet

the address of the current cell

The name of the person

the cell range

1 point

#NAME? means

The formula has an incorrect value

The formula is incorrect

The title of the sheet is missing

The name box is empty

1 point

Which is not an example of a valid excel formula

=SUM(A3..A9)

=R4 - (R9+H11)

=MAX(A3:A23)

=B3 + B4

1 point

Which of the following represent a range of cells

A9:A4

A4:F4

C4 to C10

A3..A9

1 point

What is the best use for Excel

Drawing a plan

Writing a letter

Web Design

Accounting

10.

1 point

What is the correct formula to write in cell C5 if C2 contains a number and the individual want to calculate VAT on it

(15% * C2)

=(15% of C2)

=(0.15*C2)

=(0.15*C5)

11.

1 point

The default number of worksheets in a workbook is

12.

1 point

The title bar shows the

Name of the excel worksheet

Name of the Excel workbook

Address of a cell

The file path

Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up