Microsoft Excel Advanced Features

What row should we select to freeze the 3th row?

• 3rd row

• 4th row

• 1st row

• All row

Which column to select to freeze 2nd column?

• 1st column

• 2nd column

• 3rd column

• 4th column

What is the main function of conditional formating

• To change the cell styles

• To change font, font size, and color

• Allow user to user to type automatically

• Allow user to automatically apply formatting

What is the best way to save our time in setting similar format of a cell from another cell?

• Use format painter

• Use conditional formatting

• Insert a picture

• Zoom in the page

Users can define their own cell style or use existing style in Excel

• True

• False

”A predefined formula that performs calculations using specific values in a particular order”

• Operators

• Mathematics

• Function

• Library

To start using formula in Excel, users need to type _____ sign in the beginning of the formula

• more than, >

• equal sign, =

• less than, <

• exclamation mark, !

What is the symbol used for multiplication?

• +

• /

• *

• -

Which are the three essential elements to enter a function?

• Equal sign, cell reference and formula

• Equal sign, function name and cell reference

• Function name, data and cell reference

Function that used to check and assign 'pass' and 'fail' to group of scores

• SUM

• VLOOKUP and HLOOKUP

• COUNT and COUNTA

• IF and IFS