Dear Aspirants,
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.
- Which of the following term describes explanatory text attached to a cell?
A. Context
B. Callout
C. Comment
D. Dialog
E. None of theseC. Comment - Which of the following function displays row data in a column or column data in a row?
A. Hyperlink
B. Index
C. Transpose
D. Sum
E. None of theseC. Transpose - Macros can be executed from the ____ menu.
A. Insert
B. Tools
C. Edit
D. Data
E. None of theseB. Tools - A function inside another function is called a _____ function.
A. Nested
B. Round
C. Sum
D. Text
E. None of theseA. Nested - Which of the following function is used to enter current time in a worksheet cell?
A. =today()
B. =now()
C. =time()
D. =currentTime()
E. None of theseB. =now() - Which of the following is the keyboard shortcut for creating a chart from the selected cells?
A. F3
B. F5
C. F7
D. F12
E. F11E. F11 - Which of the following keyboard shortcut is used to edit existing Excel data?
A. F2
B. F3
C. F1
D. F4
E. F5A. F2 - A value used in a formula that does not change is called a _______
A. Static
B. Cell
C. Variable
D. Constant
E. DynamicD. Constant - Which of the following is used to convert existing Excel worksheet data and charts to HTML document?
A. External Wizard
B. Intranet Wizard
C. Import Wizard
D. Export Wizard
E. Internet Assistant WizardE. Internet Assistant Wizard - Which of the following term refers to a set of values that Excel saves and can substitute automatically on your worksheet?
A. Range
B. Scenario
C. Nested
D. What-if analysis
E. None of theseB. Scenario
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
