Excel Functions Quiz

What function is used to determine a decision based on certain conditions?

• Arithmetic Function

• VLOOKUP Function

• IF Logic Function

• SUM Function

• Mathematical Function

Which function is used to calculate the total value of a range?

• Count

• Sum

• Average

• Max

• Round

Which function is used to calculate the average value of a range?

• Count

• Sum

• Average

• Max

• Round

What formula is used to read a range of data table?

• =VLOOKUP(KEY CELL;TABLE RANGE;COLUMN INDEX;)

• =VLOOKUP(KEY CELL;TABLE RANGE;ROW INDEX;)

• =VLOOKUP(KEY CELL;COLUMN INDEX;TABLE RANGE)

• =VLOOKUP(KEY CELL;ROW INDEX;TABLE RANGE)

• =HLOOKUP(KEY CELL;TABLE RANGE;ROW INDEX; false)

What is the syntax for the function that retrieves text data from the right?

• =LEFT(Text,Number of Characters)

• =RIGHT(Text,Number of Characters)

• =MID(Text,First Character Position,Number of Characters)

• =RIGHT(Text,First Character Position,Number of Characters)

• =MID(Text,Number of Characters)

What function is used to get a value from a table vertically?

• VLOOKUP

• HLOOKUP

• MID

• RIGHT

• LEFT

What is the name of the cell address that changes when copied or moved?

• Relative

• Absolute

• Positive

• Negative

• Flat

The icons 'save', 'redo', and 'undo' are part of the menu from?

• Ribbon

• Office Button

• Status Bar

• Quick Access Toolbar

• Titlebar

What is the function of the ROUND formula in Excel?

• to find the total of specific items

• to round data

• to sum all data

• to find the smallest data

• to know data from the left side of text

What is the function of the LEFT formula in Excel?

• to find the total of specific items

• to round data

• to sum all data

• to find the smallest data

• to know data from the left side of text