OFFICE AUTOMATION (TEST MULTIPLE CHOICE

Name

B- CODE

Q1. What is the function of the VLOOKUP function in Excel?

Q2. What is the function of the IF function in Excel?

• To perform a logical test and return a value based on the result
• To add up a range of cells
• To find the average of a range of cells
• To count the number of cells in a range

Q3. What is the intersection of a column and row called in Excel?

• A cell
• A range
• A column headerdent
• A row header

Q4.Which function calculates the largest value in a set of numbers in Excel?

• Average
• Count
• Minimum
• Maximum

Q5. In MS Excel, Conditional Formatting is in the ______ tab?

• Home
• View
• Page Layout
• Insert

Q6. The first cell in excel worksheet is labelled as _________?

• AA
• A1
• Aa
• None of these

Q7.Which of these keys are used in Ms excel to insert current time In workbook.

• Ctrl + Shift + ;
• Ctrl+!
• Ctrl+;
• None of these

Q8.Which function displays row data into column or column data into row?

• Index
• Hyperlink
• Transpose
• Rows