MS Office - Excel

What is the shortcut key to insert a new worksheet in MS Excel?

• Shift + N

• Alt + F11

• Ctrl + N

• Shift + F11

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

• MAX

• MIN

• AVERAGE

• SUM

What is the default file extension for an MS Excel workbook?

• .xls

• .docx

• .pptx

• .xlsx

Which feature in MS Excel allows you to view and edit multiple locations within a worksheet at the same time?

• Split Window

• Hide Rows/Columns

• Merge Cells

• Freeze Panes

Which formula can be used to count the number of cells in a range that contain numbers in MS Excel?

• SUM

• COUNT

• AVERAGE

• MAX

What is the shortcut key to autosum a column or row in MS Excel?

• Alt + =

• Alt + +

• Shift + =

• Ctrl + =

Which function is used to calculate the average of a range of cells in MS Excel?

• AVERAGE

• SUM

• MAX

• MIN

What is the purpose of the VLOOKUP function in MS Excel?

• The purpose of the VLOOKUP function in MS Excel is to search for a value in a table and return a corresponding value from a specified column.

• The purpose of the VLOOKUP function in MS Excel is to create a chart or graph based on data in a worksheet.

• The purpose of the VLOOKUP function in MS Excel is to format the appearance of a cell or range of cells.

• The purpose of the VLOOKUP function in MS Excel is to calculate the sum of a range of cells.

Which feature in MS Excel allows you to apply a predefined format to a cell or range of cells?

• Merge Cells

• Data Validation

• Conditional Formatting

• Cell Styles

What is the shortcut key to save an MS Excel workbook?

• Ctrl + A

• Ctrl + P

• Ctrl + C

• Ctrl + S