# Ch. 12 (Part A) Rscit Mock Test Excel In English {Microsoft Excel}

Right now the RSCIT Online Test of Rscit Mock Test Excel In English will be conducted in which there will be total 35 questions. This RSCIT Online Test is very important for your upcoming exams.

Hello! 🙏

how are you?

I'm just fine.

Today I have brought for you Chapter 12 Microsoft Excel Rscit Mock Test Excel In English, Part A.

In which we will do online test of 35 important questions of Microsoft Excel and check ourselves whether we have been able to qualify in RSCIT exam or not.

Don't get carried away by just reading the Rscit Mock Test Excel In English.

We can confidently say that if you finish the entire series of this RSCIT Online Test well, then no one can stop you from scoring good marks in RSCIT Exam.

Nowadays questions are asked by altering the RSCIT exam, so you are requested to read and understand all the questions of this Rscit Mock Test Excel In English carefully and take the online test.

## Rscit Mock Test Excel In English

Q. 1. Pivot Table is used in Ms Excel?
A. To show the data in chart form
B. To design the data
C. To reduce the data to the smallest form
D. To format the data

Q. 2. What is the shortcut key to insert a new worksheet in Ms Excel?
A. Shift + F9
B. Shift + F4
C. Shift + F5
D. Shift + F11

Q. 3. What is the meaning of Ms Excel Sorting and Filter?
A. Condition the data
B. Arranging Data in Descending Order
C. Arranging Data in Ascending Order
D. All Of These

A. =
B. )
C. +
D. &

Q. 5. Which of the following formula is correct in Ms Excel?
A. =sum(A1:b1)
B. =sum(A1.b1)
C. =sum(A1-b1)
D. =sum(A1;b1)

Q. 6. What is the meaning of =sqrt(X) in Ms Excel?
A. Power of X
B. Square root of X
C. Class of X
D. Cube of X

Q. 7. What is the default alignment of a number written in a cell in Ms Excel?
A. Center
B. Left
C. Right
D. Top

Q. 8. What is Average in Ms Excel?
A. Command
B. Formula
C. Function
D. Option

Q. 9. What type of software is Ms Excel?
A. Utility S/w , System S/w
B. System S/w , Application S/w
C. Application S/w , Spreadsheet S/w
D. Application S/w, Utility S/w

Q. 10. What is the extension name of Ms Excel?
A. .docx
B. .pptx
C. .xlsx
D. .txt

Q. 11. What does A1 represent in Ms Excel?
A. Column 1 , Row A
B. Column A , Row 1
C. Row 1 , Column A
D. None Of These

Q. 12. On clicking on which tab in Ms Excel the backstage view is shown?
A. Data Tab
B. Home Tab
C. View Tab
D. File Tab

Q. 13. Number of Row and Column in Ms Excel are respectively?
A. 16,384, 256
B. 1,048,576 , 256
C. 1,048,576 , 16,384
D. 1,048,580, 16,384

Q. 14. How to represent 12th column and 15th row in Ms Excel?
A. K15
B. H15
C. J15
D. L15

Q. 15. In which menu or tab is the Sort option in Excel?
A. Tool
B. Data
C. Format
D. Edit

Q. 16. Which formula is suitable to move some letters on the right side of a year to a different cell?
A. Right
B. Rit
C. Left
D. Turn

Q. 17. Which formula is suitable to find the smallest number in a selected row or column in Excel?
A. Minimum
B. Min
C. Sort
D. All

Q. 18. Which one of the MS Excel tools is used to calculate an unknown value from a final result?
A. Custom filter function
B. Goal sec
C. Boolean operator
D. Pivot Table

Q. 19. Which formula is suitable for finding the average from C2 to C7 in a column?
A. =averge(C2|c7)
B. =averge(C2:c7)
C. =averge(C2\$,c7\$)
D. =averge(C2+c7)

Q. 20. What is called Comment Insert in Ms Excel?
A. Web Tip
B. Cell Tip
C. Smart Tip
D. Soft Tip

Q. 21. Which formula is suitable for finding the average from C2 to C7 in a column?
A. =averge(C2|c7)
B. =averge(C2:c7)
C. =averge(C2\$,c7\$)
D. =averge(C2+c7)

Q. 22. What is called Comment Insert in Ms Excel?
A. Web Tip
B. Cell Tip
C. Smart Tip
D. Soft Tip

Q. 23. Which shortcut key is used to change the value of a cell in Ms Excel?
A. F4
B. F5
C. F3
D. F2

Q. 24. What is the Default View of Sheet in Ms Excel?
A. Page Break
B. Page Layout
C. Normal
D. Print Layout

Q. 25. What is the default width of a column in Ms Excel?
A. 7.78 Point
B. 9.52 Point
C. 8.43 Point
D. 10.15 Point

Q. 26. What is the default name of any new file in Ms Excel?
A. Worksheet1
B. Workbook1
C. Sheet1
D. Book1

Q. 27. What is the extension of Excel 2003, Excel 2007, Excel 2010 file respectively?
A. Xls, Xls and Xlsx
B. Docx, Doc and Docx
C. Xls, Xlsx and Xlsx
D. Xlsx, Xls and Xlsx

Q. 28. What can you use to make a formula?
A. Cell values ​​are values ​​but not cell references
B. in cell value and cell context
C. is not of cell value or cell reference, although both are not at the same time
D. Not the cell reference but the cell value

Q. 29. When you copy a formula?
A. Excel edits the cell reference in the newly copied Formula
B. Deletes the original copy of the Excel Formula
C. Excel adjusts the absolute cell reference
D. Excel does not adjust relative cell references

Q. 30. If the result of a formula is too large to be displayed in a cell, what will appear in that cell instead of the result?
A. @@@@
B. %%%% %
C. #######
D. &&&&&

Q. 31. Which function removes the spaces at the beginning and end of the text?
A. Trim
B. Leftright
C. Alltrim
D. Len

Q. 32. Which function gives the length of a text string?
A. Length
B. Len
C. Long
D. Width

Q. 33. Which option is used to stabilize the row and column in the worksheet in Ms Excel?
A. Arrange All
B. Unfreeze Pane
C. Freez Panes
D. None Of These

Q. 34. What will be the output of the formula '= Round(345.489,2)' in Ms Excel?
A. 345.489
B. 345.49
C. 345.48
D. 345.50

Q. 35. Concatenate Formula is used in Ms Excel?
A. Change Text to Lower Case
B. To join two or more text
C. Change Text to Upper Case
D. To Erase Text

Oh wow!😊

You have already done online test of all the questions of Rscit Mock Test Excel In English.

Now do one more thing,

Quickly open the Conversation Box given below and write 'RSCIT Best Test' in it so that we also know how many of you students have done this RSCIT Online Test well.

and yes! Do SHARE this Rscit Mock Test Excel In English with your other RSCIT friends so that you get his blessings and we get lots of happiness.

Just take some rest.

And after that by clicking on the button given below, you will definitely join other tests of RSCIT Online Test.

If you find any error in any query then please do let us know and help us to improve this small effort of ours.

Have a nice day, see you again!

Jai Rajasthan...💪