Wednesday , October 5 2022

# MS Excel Multiple Choice Questions Set 11

MS Excel Multiple Choice Questions for preparation of Entry Test. Here we provide MS Excel Multiple Choice Questions about Microsoft Office. All these MS Excel Multiple Choice Questions provided in MCQs format.

We also recommend you MS Word Multiple Choice Questions for test preparation.

## MS Excel Multiple Choice Questions

MS Excel Multiple Choice Questions for preparation of Entry Test. You simply prepare the given below test. To check your knowledge about Microsoft Excel. For Answers simply click on the answer button. To prepare the complete test simply navigate to desire page number at the bottom of the page.

Read Also [MS Excel MCQs Test Quiz Set 12 ]

## 11-1. Which of the following function will use to find the highest number in a series of number?

A. MAX(B1:B3)
B. HIGH(B1:B3)
C. MAXIMUM(B1:B3)
D. HIGHEST(B1:B3)

A. Yes or No
B. Value of A1
C. True or False
D. Value of B1

A. //
B. Zero
C. FR
D. Zero Space

A. CTRL + D
B. CTRL + T
C. CTRL + ;
D. CTRL + /

## 11-5. Which of the following function will return a value of 8?

A. ROUNDUP(8.4999, 0)
B. ROUNDDOWN(8.4999, 0)
C. ROUND(8.4999, 0)
D. Only B and C

A. XFD
B. XFL
C. XFX
D. XFT

## 11-7. In Excel, by default Numeric Values appears in

A. Left aligned
B. Right aligned
C. Center aligned
D. Justify aligned

## 11-8. Which of the following is correct?

A. =AVERAGE(4, 5, 6, 7)
B. =AVERAGE(A1:A9, B1:B9)
C. =AVERAGE(A1, B1, C1)
D. =All of the these

## 11-9. To show/hide the grid lines in Microsoft Excel 2007

A. Page Layout -> Grid lines -> View
B. View -> Grid lines -> View
C. Insert -> Grid lines -> View
D. Edit -> Grid lines -> View