1) _____ is not a valid data type in MS-Excel.
(A) Text
(B) Value
(C) Currency
(D) Label
Answer: (D) Label
2) What is MS Excel?
(A) Word Processing Software
(B) Presentation Software
(C) Spreadsheet
(D) Database Software
Answer: (C) Spreadsheet
3) What is the row limit of MS Excel 2019?
(A) 65,536
(B) 1,048,576
(C) 2,097,152
(D) 4,194,304
Answer: (B) 1,048,576
4) The Greater Than sign (>) exemplifies a/an _____ operator.
(A) Mathematical
(B) Statistical
(C) Algebraic
(D) Comparison
Answer: (D) Comparison
5) ____ is the correct syntax of IF() Function.
(A) =IF (logical_test, THEN([value_if_true]), ELSE([value_if_false]))
(B) =IF (logical_test, [value_if_true], [value_if_false])
(C) =IF (logical_test, {[value_if_true]}, {[value_if_false]})
(D) =IF (logical_test: [value_if_true], [value_if_false])
Answer: (B) =IF (logical_test, [value_if_true], [value_if_false])
6) ____ type of chart is good for a single series of data.
(A) Bar chart
(B) Pie chart
(C) Line chart
(D) Scatter chart
Answer: (C) Line chart
7) What do Excel formulas start with?
(A) /
(B) $
(C) =
(D) -
Answer: (C) =
8) ____ is not a function in Excel.
(A) AVERAGE
(B) MIN
(C) SUBTRACT
(D) PRODUCT
Answer: (C) SUBTRACT
9) Which keyboard shortcut is used to easily switch open workbooks?
(A) Alt+F4
(B) CTRL+Shift
(C) CTRL+Page Up
(D) CTRL+Tab
Answer: (D) CTRL+Tab
10) Maximum zoom percentage in Excel is?
A. 200%
B. 300%
C. 600%
D. 1000%
Answer: (B) 400% (Note: The correct answer is not among the options, the correct answer is indeed 400%)
11) Default file name in MS Excel is?
(A) Document 1
(B) Workbook 2
(C) File1
(D) Book1
Answer: (D) Book1
12) In Excel, columns are labeled as
A. 1, 2, 3, etc.
B. A1, B1, C1, etc.
C. $A$1, $B$1, etc.
D. A, B, C, etc.
Answer: (D) A, B, C, etc.
13) Which of the following is not a valid Zoom percentage in Excel?
A. 50
B. 100
C. 150
D. 1000
Answer: (D) 1000
14) In a computer spreadsheet, block of cells is called
A. Workbook
B. Worksheet
C. Function
D. Range
Answer: (D) Range
Click her for more
15) Microsoft Excel 2019 files have a default extension of
A. .Xls
B. .Xla
C. .Xlsx
D. .Xlt
Answer: (C) .Xlsx
16) In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of
A. Calculations
B. Formulas
C. Functions
D. Macros
Answer: (C) Functions
17) Which function displays row data into column or column data into row?
A. Filter
B. Sort
C. Transpose
D. Pivot
Answer: C. Transpose
18) Move to Next Sheet in MS Excel:
A. Ctrl + Page Up
B. Shift + Page Down
C. Ctrl + Shift
D. Ctrl + Page Down
Answer: D. Ctrl + Page Down
19) Move to next cell in row in MS Excel:
A. Enter
B. Shift
C. Space
D. Tab
Answer: D. Tab
20) In a computer spreadsheet rows are labeled
A. by colors
B. by symbols
C. by numbers
D. by formulas
Answer: C. by numbers
21) Which of the following is the last column in MS Excel-2016?
A. XFX
B. ZYX
C. XFC
D. XFD
Answer: D. XFD
22) In Excel, Conditional formatting is in: ______________?
A. Format Tab
B. Page layout
C. View Tab
D. Home Tab
Answer: D. Home Tab
23) Which of following is not an element of computer spreadsheet interface?
A. Formula bar
B. Active cell
C. Menu bar
D. Pencil work
Answer: D. Pencil work
24) Which function calculates the largest value in a set of numbers in Excel?
A. Average
B. Count
C. Minimum
D. Maximum
Answer: D. Maximum
25) MS Excel stands for ___________
A. Micro Excel
B. Management Excel
C. Microsoft Excel
D. Microsystem Excel
Answer: C. Microsoft Excel
26) Which of the following is the latest version of MS Excel?
A. Excel 2019
B. Excel 2020
C. Excel 2021
D. Office 365
Answer: C. Excel 2021
27) In MS Excel spreadsheet, Data can be sorted using ________.
A. Filter function
B. Formula funct
ion
C. Lookup function
D. Sort function
Answer: A. Filter function
28) The __ feature of ms excel quickly completes a series of data.
A. Auto Filter
B. Auto Complete
C. Auto Fill
D. Auto Sum
Answer: C. Auto Fill
For more info
0 Comments