IT support Level-1 (MS Excel)

Which one shortcut key is use to close spreadsheet?

• Ctrl + W

• Ctrl + Arrow key

• Ctrl + S

• Ctrl + C

Give me an example of a cell address-

• 11 25

• A21

• 911

• 41A

You accidently erase a record in the sheet.

What command can be to restore it Immediately?

• Insert

• Copy

• Undo

• Repair

What is the symbol for multiplying-

• >

• /

• !

• *

What is the keyboard shortcut used to go home tab?

• Ctrl + W

• Ctrl + Arrow key

• Alt + H

• Ctrl + C

Which of the following all formulas in excel starts-

• /

• =

• +

• $

A spreadsheet contains-

• Columns

• Rows

• Rows and Columns

• None of above

NOT, AND, OR and XOR are which type of operator-

• Logical Operator

• Arithmetic Operator

• Relational Operator

• None of the above

Which is an example of a function?

• =Add(A3:A4)

• =Deduct(A3:A4)

• =(A3:A4)

• =sum(A3:A4)

Which of the following will use to find the highest number in a series of number?

• =Maximum(B1:83)

• =Max(B1:B3)

• =High(B1:83)

• =Highest(B1:83)