MS Excel MCQs

__ area in an excel window allows entering values and formulas

1. Menu Bar
2. Title Bar
3. Formula Bar
4. None

Which key is used for Excel to select the whole column highlight?

1. Shift + space
2. CTRL + space
3. Alt + space
4. None of these

Which function calculates the largest value in a set of numbers in Excel?

1. Average
2. Count
3. Minimum
4. Maximum

Microsoft Excel 2019 files have a default extension of ___?

1. .Xlsx
2. .Xls
3. .excel
4. .123

In MS Excel ______ shortcut key is used for hiding rows.

1. Ctrl+H
2. Ctrl+7
3. Ctrl+9
4. None of the above

Which Shortcut keys are used to strikethrough highlighted selections in MS Excel?

1. Ctrl+4
2. Ctrl+5
3. Ctrl+6
4. None of these

The main window in a computer spreadsheet is called?

1. workbook
2. work
3. account book
4. worksheet

In a computer spreadsheet, a function that is used to count a number of entries in a given range is called?

1. length
2. counter
3. counting
4. count

The basic unit of a computer worksheet in which you enter text and numbers is known as _____?

1. workbook
2. cell
3. row
4. column

Computer spreadsheet cell that is highlighted with a heavy border is a ______?

1. Active cell
2. Cell containing a formula
3. Locked cell
4. Cell