Formulas & Function in Excel 2021

Any text entered in excel is called a ________.

• Number
• Formula
• Cell
• Label

By default numeric values are always ____________.

• Strings
• Integers
• Right-aligned
• Left-aligned

A formula in excel begins with ____________.

• = (Equal Sign)
• x (Multiplication Sign)
• + (Plus Sign)
• - (Minus Sign)

A group of selected cells is called a __________.

• Range
• Group
• Cluster
• Selection

A ________ is a cell address that can be used in a formula to denote a specific cell.

• Cell Reference
• Cell Number
• Cell Location
• Cell Pointer

A _________ sign used as a prefix before the column and row for locking a cell.

• Dollar
• Percentage
• Ampersand
• Hash

A _______ is a predefined formula in excel.

• Function
• Cell
• Spreadsheet
• Workbook

Which of the following functions finds the specified number of values from a given set of values?

• COUNT() function
• FIND() function
• TOP() function
• SUM() function

Which of the following is an arithmetic operator

• ^

• &

• <>

• ==

TODAY() function returns the current date.

• True
• False
• It returns the current time
• It returns the current month