.
SOFT INFOSYS COMPUTER ERUDITE
Excel Sample Questions
Which function Excel checks whether a condition is true or not ?
A) Sum
B) Count
C) If
D) Average
In Excel, Columns are named as ___
A) A,B,C, etc.
B) 1,2,3,etc.
C) A1,B1,C1, etc
D) None of the Above
The Greater Than sign (>) is an example of _____ operator.
A) Arithmatic
B) Logical
C) Conditional
D) Greater
The ____ feature of MS Excel quickly completes a series of data
A) Fill
B) Complete
C) Arrange
D) None of the Above
Insert a new worksheet
A) Ctrl+F11
B) Alt+F12
C) Shift+F11
D) Ctrl+F12
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A) Conditional formating
B) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
C) IF function
D) None of the Above
Which of the following is invalid statement?
A) Sheet tabs can be colored
B) Some picture can be applied as a background of a sheet
C) You can set the column width automatically fit the amount of text
D) The width of a row and be specified manually or fit automatically
Name Box of MS Excel is used to show
A) The sheet name
B) The cell name
C) The row name
D) The column name
Remove Duplicate is option of Home Tab
A) True
B) False
C) NA
D) NA
Goal Seek is used to adjust the value of a calculated cell
A) True
B) False
C) NA
D) NA
How many rows in MS Excel?
A) 1048576
B) 1048572
C) 1048472
D) 1048476
How many columns in MS Excel?
A) 15800
B) 1250
C) 16384
D) None of the Above
MS Excel is an
A) application software
B) system software
C) Both Option-1 & Option-2
D) None of the Above
Which functionin Excel tells how many numeric entries are there ?
A) countsum
B) sum
C) sumif
D) count
Which one is not a Function in MS Excel ?
A) Sum
B) Avg
C) Max
D) Min
Functions in MS Excel must begin with ________
A) =
B) +
C) –
D) $
We can set Background picture in MS Excel
A) True
B) False
C) NA
D) NA
Move to the beginning of the row
A) Ctrl+Home
B) Home
C) Start
D) None of the Above
Move one cell right
A) Tab
B) Right Aerrow
C) Both Option-1 & Option-2
D) None of the Above
Copy the data to the down cell
A) Down Aerrow
B) Move Down
C) Alt+D
D) Ctrl+D
You can set Page Border in Excel from
A) From Border tab in Format Cells dialog box
B) From Border tool in Formatting toolbar
C) From Line Style tool in Drawing toolbar
D) You can not set page border in Excel
The cell reference uses _____ symbal
A) =
B) $
C) Both Option-1 & Option-2
D) None of the Above
Data Validation is used to enter a valid data in a cell
A) True
B) False
C) NA
D) NA
We can protect a sheet using password
A) True
B) False
C) NA
D) NA
Header and Footer can not be used in Excel.
A) True
B) False
C) NA
D) NA
=product(4,5,6)
A) 120
B) 456
C) 654
D) None of the Above
=Ceiling(20,5)
A) 5
B) 10
C) 15
D) None of the Above
=upper(“RmaA”)
A) RAMA
B) rama
C) rAMA
D) None of the Above
=ROUND(20.459,1)
A) 20.6
B) 20.45
C) 20.46
D) None of the Above
Remove duplicate can be apply for all the sheet at a time.
A) True
B) False
C) NA
D) NA
