Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in Microsoft Excel. It will be useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.
- A value used in a formula that does not change is called a _____
D. None of the aboveA. Constant
- You can merge the main document with data source in Excel. In mail merge operation, Word is usually _______
D. None of the aboveC. client
- Which of the following is used to enter the Current time in a worksheet?
A. Ctrl + Shift + @
B. Ctrl + Shift + ;
C. Ctrl + Shift + :
D. None of the aboveB. Ctrl + Shift + ;
- “Ctrl + ;” is used to enter _____
A. Current Time
B. Current Date
C. Current Day
D. None of the aboveB. Current Date
- Which of the following is used to insert the value of the above cell into cell currently selected?
A. Ctrl + ;
B. Ctrl + :
C. Ctrl + –
D. Ctrl + ‘D. Ctrl + ‘
- A numeric value can be treated as text if______ precedes it.
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. None of the aboveA. Apostrophe (‘)
- Which of the following returns the factorial of a number?
A. FACT DOUBLE
D. FLOORB. FACT
- How do you display current date and time in MS Excel?
D. TIME()C. NOW()
- Which of the following returns the current date formatted as a date?
D. TIME()B. TODAY()
- Which of the following counts the number of cells in a range that contain numbers?
D. DCOUNTA. COUNT
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification