4year midterm

Is this your test? Login to manage it. If not, you can generate a quiz just like it.

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

2 points

What is the cellID of a cell which is located under column B and in the sixth line?

None of the above

2 points

Cells controlled by formulas are called...

Dynamic

Extetic

Synchronous

Static

2 points

Find a 47 % of 367

2 points

what is correct formula to find out the 40% of the SUM of cells B1 to B4?

(B1+B2+B3+B4)/4

(B1+B2+B3+B4)/40

(B1+B2+B3+B4)/0.4

(B1+B2+B3+B4)/(B1+B2+B3+B4)

2 points

What is the result of this formula?
=SUM(45, 5, 87, 13, 86)

2 points

=IF( NO, YES, CONDITION)
Is it a correct formula for conditional statements

True

False

2 points

What is the symbol(s) an Exel Formula Starts from?

()

2 points

What kind of statements allow us automatically change a value of a cell?

Conditional Statements

Controlling statements

Executing statements

All of the above

2 points

Borders of cells are initially hidden when you create an Excel document and you have to make them visible manually

True

False

10.

2 points

table in Excel consist form cells

True

False

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