MS Excel 2019 Functions

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

• Cell

• Column

• Row

• Data

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

• Column

• Label

• Row

• Cell Address

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

• &

• #

• =

• *

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

• AVERAGE

• SUM

• MIN

• MAX

What function was used to find the highest data ?

• AVERAGE

• MIN

• SUM

• MAX

In Excel, the name of the bar where information appears as you input data in called ?

• File Bar

• Help Bar

• Formula Bar

• Window Bar

Microsoft Excel is categorize as ?

• Word Processing Software

• Database Software

• Spreadsheet Software

• Presentation Software

What function was used to find the lowest data ?

• AVERAGE

• MIN

• MAX

• SUM

The function COUNT is specific for _________________

• Counting cells

• Counting text

• Counting number

• Counting tables

What is the Sum formula?

• Sum( )

• Sum( )=

• =( )Sum

• =Sum( )