Grade 12 Addition

What is the sum of 234 and 567?

• 732

• 678

• 801

• 456

What is the default file extension for Excel workbooks?

• .xls
• .xlsx
• .xlsm
• .xlt
• .csv

Answer explanation

The default file extension for Excel workbooks is .xlsx.

Which function calculates the average of a range of values?

• SUM
• AVERAGE
• COUNT
• MAX
• MIN

Answer explanation

The AVERAGE function calculates the mean of the numbers provided.

What is the shortcut key to save an Excel workbook?

• Ctrl + A
• Ctrl + S
• Ctrl + Z
• Ctrl + P
• Ctrl + C

Answer explanation

Ctrl + S is the shortcut for saving a workbook.

What is an absolute cell reference in Excel?

• A cell address that adjusts when copied
• A fixed cell address
• A cell with a function
• A cell with conditional formatting
• A cell in a pivot table

Answer explanation

An absolute cell reference remains constant, even when copied elsewhere.

What is the maximum number of rows in an Excel 2016 worksheet?

• 65536.0
• 1048576.0
• 104857.0
• 1000000.0
• 500000.0

Answer explanation

Excel 2016 supports up to 1,048,576 rows.

Which function returns the largest value in a range?

• MAX
• MIN
• LARGE
• HIGH
• PEAK

Answer explanation

The MAX function returns the largest value in a given range.

What does the VLOOKUP function do?

• Adds values vertically
• Looks up values vertically in a table
• Sorts data
• Filters data
• Deletes duplicates

Answer explanation

VLOOKUP searches for a value in the first column and returns a value in the same row from a specified column.

How do you start a formula in Excel?

• Type +
• Type =
• Type @
• Type #
• Type &

Answer explanation

All formulas in Excel start with the equals sign (=).

How do you apply the currency format in Excel?

• Ctrl + Shift + %
• Ctrl + Shift + $
• Ctrl + Shift + #
• Ctrl + Shift + @
• Ctrl + Shift + &

Answer explanation

Ctrl + Shift + $ applies the currency format.