Basic Spreadsheets Quiz

How can you format a cell to display currency in a spreadsheet?

• Choose the 'Date' format from the formatting options.

• Select the 'Bold' format from the formatting options.

• Pick the 'Italic' format from the formatting options.

• Choose the 'Currency' format from the formatting options.

What is the shortcut key to save a spreadsheet?

• Ctrl + A

• Ctrl + S

• Shift + S

• Alt + S

How can you merge cells in a spreadsheet?

• Select the cells and use the 'Merge Cells' option in the formatting or layout menu.

• Right-click on the cells and select 'Merge'

• Press the 'M' key while the cells are selected

• Use the 'Merge' function in the formula bar

What is the function of the AVERAGE formula in a spreadsheet?

• Multiplies a range of numbers

• Calculates the average of a range of numbers

• Counts the number of cells in a range

• Finds the maximum value in a range of numbers

What is the function of the COUNT formula in a spreadsheet?

• Calculates the sum of a range of numbers

• Calculates the average of a range of numbers

• Counts the number of cells in a range

• Finds the minimum value in a range of numbers

What is the shortcut key to undo the last action in a spreadsheet?

• Ctrl + Z

• Ctrl + U

• Shift + Z

• Alt + Z

How can you format a cell to display percentage in a spreadsheet?

• Choose the 'Percentage' format from the formatting options.

• Select the 'Bold' format from the formatting options.

• Pick the 'Italic' format from the formatting options.

• Choose the 'Currency' format from the formatting options.

What is the shortcut key to copy the selected cells in a spreadsheet?

• Ctrl + C

• Ctrl + V

• Shift + C

• Alt + C

What is the function of the SUM formula in a spreadsheet?

• Calculates the sum of a range of numbers

• Calculates the average of a range of numbers

• Counts the number of cells in a range

• Finds the maximum value in a range of numbers