Revision- BUS02004: Create and use basic spreadsheets

In excel we called the selected area:

• Raw

• Column

• Record

• Ribbon

In Excel, the function used to sum a range of cells is:

• SUMIF

• AVERAGE

• SUM

• COUNT

In Excel, which of the following is used to create a chart?

• Insert

• Data

• View

• Format

Column in Microsoft Excel displayed in:

• Numeric order

• Alphabetic

Which of the following is a valid formula in Excel?

• =SUM(A1:A10)

• SUM(A1:A10)

• SUM A1:A10

• SUM(A1:A10)

In Excel, which function is used to find the average of a set of numbers?

• AVERAGEIF

• SUM

• AVERAGE

• COUNTIF

Is a set of mathematical instructions that can be used in Excel to perform calculations:

• Formula

• Cell

• Data

• Review

One of the Excel formulas and it’s include the numbers or text values that do not change

• Functions

• Constants

• Operators

• Refrences

In Excel, which function is used to find the number of cells that contain a numerical value within a range of the argument

• Sum

• Max

• COUNTIF

• COUNT

In Excel, which of the following is used to freeze panes?

• View

• Insert

• Data

• Format