Office Productivity Tools

Which function in Excel is used to add a range of cells?

(a)  

What is the keyboard shortcut to paste values only in Excel?

(a)  

1. Which function is used to find the highest value in a range in Excel?

(a)  

What does the function =IF($B$2$<75, "Fail", "Pass") do in Excel?

• Adds the values in column B and checks if it's lesser than 75.

• Checks if the value in column B is lesser than 75, if true, it returns "Fail", otherwise "Pass".

• Multiplies the values in column B by 75%.

• Converts the value in column B to a text string

1. Which feature in Excel is used to identify and correct errors in formulas?

(a)  

1. In Excel, what symbol is used for exponents?

(a)  

Which of the following is refered as the intersection of a row and a column?

(a)  

Which of the following allows users to organize and manipulate data arranged in rows and columns?

(a)  

What is the cell address of the selected cell?

(a)  

What happens when the encircled button is clicked?

• It selects all the cells.

• It selects all the row numbers.

• It highlights all the cell.

• It selects all the column headers.