Class VI Excel Quiz

Which of the following represents a correct cell reference in Excel?

• A1

• 1A

• A1B1

Ishaan is working on a spreadsheet and needs to make changes to a specific cell. What is the keyboard shortcut he can use to edit the active cell?

• F1

• F2

• F4

Which command is used to split a single cell into multiple cells?

• Split

• Divide

• Separate

Aanya is working on a spreadsheet and needs to remove some unnecessary data. She wonders how a cell can be deleted through …………………………… group of the Home tab.

• Cells

• Row

• Font

Aarush is working on a document and accidentally deletes a paragraph he spent a lot of time on. Which command allows him to reverse the last action?

• Redo

• AutoFill

• Undo

Sneha is working on a spreadsheet and wants to adjust the height of certain rows to better fit the content. Which of the following list contains the option to change the row height?

• Format

• Cell Size

• Row Size

In Excel all formulas must start with …………………….

• + sign

• =sign

• $sign

……….. function finds the largest value or number in the given range of cells.

• Min

• Averge

• Count

Functions are predefined ………………

• Commands

• Operations

• Formulas

………………….. means to arrange data in ascending or descending order.

• Formula

• Sorting

• Programs