Himachal Pradesh HPTET 939 - Free Online Practice Test

91. Value of cell containing formula =5×900%?

Computer

A. 40 B. 45 C. 50 D. 44

92. Address of cell range from A3 to G5 in MS Excel?

Computer

A. A3:G5 B. A3$G5 C. A3-G5 D. A3 to G5

93. Value returned by the function =COUNTA(A1:D5)?

Computer

A. 12 B. 16 C. 14 D. 15

94. Excel function to count non-empty cells in a range?

Computer

A. COUNTNB B. COUNTA C. COUNTNE D. COUNT

95. Number of worksheets in an Excel workbook by default?

Computer

A. 3 B. 4 C. 2 D. 5

96. Default cell alignment for text and numbers in Excel?

Computer

A. both left B. both right C. text right, num left D. text left, num right

97. Value for =WORKDAY("01−01−2022",22) (Sunday start)?

Computer

A. 30-Jan-2022 B. 03-Feb-2022 C. 28-Jan-2022 D. 01-Feb-2022

98. Rotating data from rows to columns or vice-versa?

Computer

A. Pivot table B. Scaling C. Transposing D. Range

99. Which is NOT a chart type supported by MS Excel?

Computer

A. Area Chart B. Scatter Plot C. Volume Chart D. Line Chart

100. Feature to record and play keystrokes?

Computer

A. Macro B. Format Painter C. Wrap Text D. Pivot Table