Microsoft Excel Basic and Advance 2

Question 1

Which function returns the number of cells in a range that meet a given condition?

Accepted Answer

COUNTIF

Answer

COUNT

Answer

SUMIF

Answer

COUNTA

Question 2

What does the $ symbol do when placed before a column letter or row number in a formula?

Accepted Answer

Anchors the reference so it does not change when copied

Answer

Formats the cell as currency

Answer

Adds a dollar sign to the displayed value

Answer

Marks the cell as protected

Question 3

Which Excel feature automatically suggests a formula pattern based on adjacent data you have already entered?

Accepted Answer

AutoFill

Answer

AutoCorrect

Answer

Flash Fill

Answer

Quick Analysis

Question 4

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

3

Answer

3.4

Answer

12

Question 5

Which keyboard shortcut applies bold formatting to the selected cells?

Accepted Answer

Ctrl+B

Answer

Ctrl+I

Answer

Ctrl+U

Answer

Ctrl+F

Question 6

When you sort a table by a column in ascending order, how does Excel sort text values?

Accepted Answer

A to Z

Answer

Z to A

Answer

By cell color

Answer

By font size

Question 7

Which function would you use to round 4.567 to two decimal places?

Accepted Answer

=ROUND(4.567,2)

Answer

=TRUNC(4.567,2)

Answer

=INT(4.567,2)

Answer

=CEILING(4.567,2)