Quiz on Excel IX B

Which of the following is a spreadsheet software developed by Microsoft?

• MS Word
• MS PowerPoint
• MS Excel
• MS Outlook

What is a cell in MS Excel?

• A row in a spreadsheet
• A column in a spreadsheet
• A single data entry point within a spreadsheet
• A formula used for calculations

Which function in MS Excel is used to add up a range of cells?

• COUNT
• AVERAGE
• SUM
• MAX

Which keyboard shortcut can be used to copy selected cells in MS Excel?

• Ctrl+C
• Ctrl+V
• Ctrl+X
• Ctrl+Z

Which function in MS Excel can be used to find the highest value in a range of cells?

• COUNT
• AVERAGE
• SUM
• MAX

Which function in MS Excel is used to round a number to the nearest whole number?

• ROUNDUP
• ROUNDDOWN
• ROUND
• INT

Which of the following button should you click to adjust the height and width of the cells of a worksheet?

• Insert
• Format
• Delete
• Cell Styles

Which sign is used to keep the cell referencing in MS Excel absolute?

• *
• &
• $
• %

Which symbol is used to indicate a formula in Excel?

• +
• -
• =
• ~

Which of the following MS Excel Function can you use to multiply the numeric values of two cells?

• SUM()
• RANK()
• PRODUCT()
• MULTIPLY()