Excel Quizz

What do you call the boxes on a spreadsheet?

• squares

• cells

• rows

• values

What would be a correct formula for sum in excel?

• =SUM(B3+B9

• =SUM("B3:B9")

• SUM("B3:B9")

• =SUM(B3:B9)

Rows are ...

• Horizontal

• Vertical

Microsoft Excel is what type of software?

• Calculator

• Presentation

• Spreadsheet

• Programming

How do you make a cell an active cell?

• Type =ACTIVATE in a cell

• Click on insert cell

• Click on the cell

• Cells are always active

What is the Formula sign for multiply?

• x

• *

• +

• $\Sigma$

Michaël wants to add three cells and devide the total by 4, which of the following formulas would work?

• SUM(A1:A3)/4

• (A1+A2+A3)/4

• SUM(A1,A2,A3)/4

• The correct answer is not provided

What formula can be used to find a value in a row of a table?

• HLOOKUP

• VLOOKUP

• YLOOKUP

• ZLOOKUP

Which of these number formats would you want to apply to a cell showing the total sales for the month?

• Percentage

• Currency

• Date

You want to enter a series of dates down a column. What would be the best tool for the job?

• Find and Replace

• Cut and Paste

• Autofill

• Spelling Checker