MS. Excel

When the formula “=NOW ()” is type into a particular cell in Ms. Excel, which of the following answers will appear in the cell by default?

• Current Time

• Current Date

• Current Month

• Current Date and Time

Which of the following is FALSE about Microsoft Excel?

• It is a spreadsheet software

• Helps to create charts, graphs and to perform calculations.

• Used by financial and statistical analysis

• It is identical to Google spreadsheet

Which of the following syntax is correct regarding the MAX function in Microsoft. Excel?

• =MAX(C9/C12)

• =MAX(C9;C12)

• =MAX(C9::C12)

• =MAX(C9:C12)

17/5/2023

The above result would appear when the user inserts the _________formula in Microsoft Excel.

• =NOW( )

• =TODAY( )

• =DATE( )

• =DAY ( )

In Microsoft Excel, users can insert a formula by using the following steps EXCEPT:

• Select a cell and enter the formula

• Type the formula in the formula bar

• Click the Insert Function button

• Type the formula in the name box

Which of the following statements is FALSE about the Data Validation function in Microsoft Excel?

• Data validation enables users to select one or more cells to validate in the worksheet.

• Data validation restricts data entry to a certain range of dates, limit choices by using a list, or allowing only positive whole numbers are entered by the user.

• Data validation changes the appearance of a cell range based on a criterion. If the criteria is true, the cell range is formatted based on that criteria; if the criteria is false, the cell range is not formatted based on the given criteria.

• Data validation provides immediate help to instruct users and clear messages when invalid data is entered in order to make the data entry experience go smoothly.

Which of the following syntax is TRUE for a Nested IF formula?

• =IF (E3>80,”PASS”,”FAIL”)

• =IF (E3< 80,FAIL, PASS)

• =IF (E3>80, “A”,IF (E3>70, “B”,IF (E3>50, “C”, “D”)))

• =IF (E3>80, A ,=IF (E3>70, B ,=IF (E3>50, C , 0)))

Choose the appropriate range for the figure:

• C1:G4

• C9:G9

• C1:G9

• C9:G1

Which function in Excel tells how many numeric entries in the cell?

• Count

• Sum

• Nested IF

• Average

Which of the following is an absolute cell reference?

• K91

• K$91

• $K$91

• $K91