Hamad International - Doha -Pre -MS Excel - Basic Intermediate

1.     Ctrl + D shortcut key in Excel will

• Open the font dialog box

• Apply double underline for the active cell

• Fill down in the selection  

• None

• Not Aware

One of these references will keep the column constant but changes the row while copying the formulas

• A1

• $A$1

• $A1

• All of these

You can display formulas on Entire Worksheet by pressing

• Ctrl + F2

• Ctrl + ` (Back Quote)

• F2

• We cannot display formulas of Entire Worksheet

Keyboard shortcut to insert Row or Column in Excel Sheet

• Ctrl + Shift + Plus(+)

• Ctrl + I

• Ctrl + N

• Ctrl + Minus (-)

COUNTIF function of excel can count the number of cells that meet 1 or multiple criteria’s

• True

• False

• Don't Know

In COUNTIFS function while writing the condition to count values which are more than 5000, following syntax has to be followed.

• >5000

• “>5000"

• “Greater than 5000”

• 5000

• Not Used COUNTIFS

The Function =ROUNDUP(5671.389,-1) returns

• 5671

• 5675

• 5680

• 5672

• Never Used This Function

Which of the following Comparison Operator represents “Not Equal To” in Excel

• #

• !=

• < >

• /=

• Not Aware

A Logical function in Excel which is used to customize all kind of error outputs from a formula or Function

• ERROR

• IFNA

• ISERROR

• IFERROR

• Not Aware

=IF(100>20,"BIG","SMALL") will return

• BIG

• 100

• SMALL

• 20