Excel Basics

What is the file extension for an Excel workbook?

• .xls

• .xlsx

• .docx

• .pdf

How many worksheets are there by default in a new Excel workbook?

• 10

• 1

• 5

• 3

What is the function of the SUM formula in Excel?

• It calculates the total sum of the numbers in the specified range.

• It finds the average of the numbers in the range

• It divides the numbers in the range

• It multiplies the numbers in the range

Explain the difference between a row and a column in Excel.

• A row runs horizontally, identified by numbers, and contains data organized horizontally. A column runs vertically, identified by letters, and contains data organized vertically.

• A column is horizontal and contains data organized horizontally.

• A row is vertical and contains data organized vertically.

• A row is identified by letters and contains data organized horizontally.

What is the shortcut key to save an Excel workbook?

• Alt + S

• Ctrl + A

• Ctrl + S

• Shift + S

How can you freeze panes in Excel?

• Select row below and column to the right of desired freeze point, go to 'View' tab, click 'Freeze Panes' in 'Window' group, select 'Freeze Panes'.

• Right-click on desired freeze point and select 'Freeze Panes' from context menu

• Select entire sheet and press 'Ctrl + F' to search for 'Freeze Panes'

• Go to 'Insert' tab and click 'Freeze Panes' in 'Tables' group

What is the purpose of conditional formatting in Excel?

• The purpose of conditional formatting in Excel is to apply formatting rules to cells based on specified conditions.

• The purpose of conditional formatting in Excel is to insert new rows into a spreadsheet.

• Conditional formatting in Excel is used to create pivot tables.

• Conditional formatting in Excel is designed to calculate formulas in cells.

Explain the concept of cell referencing in Excel.

• Cell referencing in Excel is the ability to refer to a cell or a range of cells in a formula by using the cell's address.

• Cell referencing in Excel is the process of creating new cells.

• Cell referencing in Excel refers to the process of merging cells together.

• Cell referencing in Excel involves changing the font style of cells.

What is the function of the VLOOKUP formula in Excel?

• It creates a new worksheet in the Excel file

• It formats the text in a cell based on a condition

• It calculates the sum of a range of cells

• It searches for a value in the first column of a range and returns a value in the same row from another column.

How can you insert a new worksheet in an Excel workbook?

• Double-click on a cell and choose 'Insert Worksheet'

• Press Alt + F1

• Go to File menu and select 'New Worksheet'

• Right-click on a worksheet tab, select 'Insert', then choose 'Worksheet'.