ICT Ms Excel Comprehension Test

What's the main data that being processed by Ms. Excel?

• Words

• Numbers

• Lines

• Image

Microsoft Excel is categorize as ?

• Word Processing Software

• Database Software

• Spreadsheet Software

• Presentation Software

What is the correct definition of cell in Ms Excel?

• The intersection of a row and column

• A prison for numbers and text

• The basic structural, functional, and biological unit of organisms

• The box to calculate data

The first cell in a worksheet is what?

• A1

• 1A

• FX

• Cell Name

Which one is the icon function in Ms. Excel?

• 
• 
• 
• 

What function is used to calculate data in a column?

• IF( )

• COUNTA

• SUMIF

• SUM

Which function that doesn't exist in Ms. Excel?

• =IF

• =AVERAGE

• =HTML

• =MAX

What does every formula in MS EXCEL start with?

• +

• -

• =

• *

What this function do?

=MAX(A12:A16)

• To determine the average result

• To show which cell has the most character

• To determine the highest number of the list of number in a column

• To change font size to all caps

Which result that will be shown by using that function?

• 33

• 24

• 116

• 29