MS Excel Basic & Intermediate – Post Assessment Questions

Based on the data below, what is the formula to know the number (count) of Gross Salary that is more than 900?

Note: 1 condition only given

Refer to the highlighted section below. Assume that you want to put the currency style on the selected values. Which option could you use.

What is the function that counts the number of cells within a range that contains numbers only?

What is the function that counts non-empty cells (counts both numbers & texts)?

What is the function that adds (total) the cells specified by a given condition (1 condition only)?

What is the correct way of entering formula into a cell?

What is the name of this?

What’s the SUM formula that adds up the following cells C2, C3 and C4?

What’s the formula, or function that finds the highest # among the cells G6, G7, G8?

What functions will convert the word “de’ heritage”, to uppercase, in cell A9.

What is the MS Excel functions that allows us to know the number of characters in a certain cell.

What is MS Excel function that used to extract the leftmost letters of a text.

__________ is a tool that you can use to communicate your data graphically?

__________ an Excel file containing worksheets.

Rows are the horizontal lines in the worksheet numbered from 1,2,3… until row _______ (the last row).

Use commas to separate the values without spaces.

If you want to make absolute reference to cell E2, what would it look like?

__________ an Excel features that automatically inserts previously-entered data.

An MS Excel function that calculates the average range of cells.

The keyboard shortcut for absolute references is __________?

Which of these symbols means that the row does not change when copied to another cell.