MS Excel

The function that lets you add up a range of cells or values

• AVERAGE

• SUM

• MIN

• MAX

The function COUNTA is used for counting cells that contain

• numbers and logical values only

• text, numbers and logical values only

• text, numbers, logical values and error values only

• text, numbers, logical values, error values, and empty text (" ")

What function is used to find the lowest data ?

• MIN

• MAX

• SUM

• AVERAGE

What function Is used to find the highest data ?

• SUM

• MIN

• MAX

• AVERAGE

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

• @

• =

• '

• #

The function COUNT is specific for counting _________________

• text

• numbers

• cells

• tables

In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on

• row

• column

• label

• cell address

Microsoft Excel is categorized as a ________________ software.

• Database

• Spreadsheet

• Presentation

• Word Processing

The bar where information appears as you input data is called ______________.

• file bar

• help bar

• window bar

• formula bar

In a worksheet, the vertical spaces with the headings A, B, C and so on

• row

• column

• label

• cell address