FORMULAS AND FUNCTIONS IN EXCEL

An Excel spreadsheet is primarily used for calculating which of the following options

• A. Data

• B. Finances

• C. Numbers

• D. All of the above

Which of the following option is a formula?

• A. =SUM(A1:A5)

• B. Add A1 - A5

• C. Subtract the numbers

• D. A1 = A5

All formulas in Excel begin with the following symbol

• A. +

• B. =

• C. %

• D. #

1. Which of the following is an absolute cell reference?

• a. !A!1

• b. $A$1

• c. #a#1

• d. A1

A worksheet range is a

• a. A command used for data modeling

• b. A range of values such as from 23 to 234

• c. A group of cells

• d. A group of worksheets

Concatenation of text can be done using

• a. Apostrophe

• b. Exclamation (!)

• c. Hash (#)

• d. Ampersand (&)

A circular reference is

• a. Geometric modeling tool

• b. A cell that points to a drawing object

• c. A formula that either directly or indirectly depends on itself

• d. Always erroneous

Text formulas:

• a. Replace cell references

• b. Return ASCII values of characters

• c. Concatenate and manipulate text

• d. Show formula error value

Which button do you click to add up a series of numbers?

• a. The autosum button

• b. The Formula button

• c. The quicktotal button

• d. The total button

In the order of operations, which of the following comes first?

• a.Multiplication

• b.Operations involving large numbers

• c.Exponential calculations

• d.Operations enclosed in parentheses