COMPUTER GK

COMPUTER GK (MS EXCEL) QUESTIONS

Leave a Comment / Computer GK / By

COMPUTER GK (MS EXCEL) QUESTIONS

Computer GK-– These MS EXCEL questions are very important for JOA, Clerk , Bank Clerk, Insurance, SO and other exam where one’s computer knowledge is tested. In this article important questions are given those can be asked in different competitive examinations.

COMPUTER GK
COMPUTER GK

Q: Which of the following SUM function in Excel ?
(a) =SUM (A1, B2)
(b) =SUM (A3, B5)
(c) SUM (A2:A9, B1:B9)
(d) SUM (A1:A9, B1:B9)


Ans: SUM (A1:A9, B1:B9)

Q: which of the following shortcut key to hide entire column ?
(a) CTRL + H
(b) CTRL + N
(c) CTRL + –
(d) CTRL + 0


Ans: CTRL + 0

Q: How to Find any data in in MS Excel Sheets?
(a) Alt+Ctrl
(b) Ctrl+u
(c) Ctrl+t
(d) Ctrl+F


Ans: Ctrl+F

Q: What is shortcut key for replace data?
(a) Alt+O
(b) Ctrl+H
(c) Ctrl+N
(d) Ctrl+Y


Ans: Ctrl+H

Q: Which functionin Excel tells how many numeric entries are there ?
(a) COUNT
(b) NUM
(c) CHKNUM
(d) None of These


Ans: COUNT

Q: what is fourmulla for saving excel file
(a) Ctr+Alt+t
(b) S
(c) Alt+s
(d) Ctrl+s


Ans: Ctrl+s

Q: Which one is not a Function in MS Excel ?
(a) AVG
(b) SUM
(c) MAX
(d) None of These


Ans: AVG

Q: Which key is used to edit a cell in Microsoft Excel?
(a)Alt
(b)Ctr 4
(c)F4
(d)None of these
Ans: F2

Q: Which command is used to open the MS Word with the help of RUN window ?
(a)Ms-word
(b)Msoffi-ceword
(c)Ms-winword
(d) None of these


Ans:: Win-word

Q: in MS_Microsoft Excel default header for a worksheet is
(a)your name
(b)sheet tab name
(c)date
(d)None of these
Ans: None of these

Q: in Microsoft Excel folloing term discribes explanatory text atteched to a cell ?
(a)call out
(b)dilog
(c)none
(d)None of these


Ans:  none

Q: What is the short cut key to highlight the entire column ?(a) ALT+Ctrl+Enter Key?
(b) Alt + Down Arrow
(c) Ctrl + Right Arrow
(d) Ctrl + Space Bar


Ans: Ctrl + Space Bar

Q: What is the keyboard shortcut for creating a chart from the selected cell range ?
(a) F2
(b) F5
(c) F10
(d) F11


Ans: F11

Q: What is the shortcut key to insert current date in a cell ?
(a) CTRL + Enter
(b) Alt+N
(c) CTRL + ;
(d) Alt+R


Ans: CTRL + ;

Q: what is group of cells that form a rectablge on the screen ?
(a)range
(b)fourmula
(c)calculation
(d)comment


Ans:  comment

Q: MS Excel is a
(a) Spreadsheet Program
(b) Presentation Program
(c) Word Processing Program
(d) None of These


Ans: Spreadsheet Program

COMPUTER GK

Q: What is the intersection of a column and a row on a worksheet called ?
(a) Value
(b) Address
(c) Cell
(d) None of These


Ans: Cell

Q: Formulas in Excel start with(a) &
(b) #
(c) +
(d) =


Ans: =

Q: What type of chart is useful for comparing vaues over categories ?
(a) Column Chart
(b) Line Chart
(c) Dot Graph
(d) None of These


Ans: Column Chart

Q: How to Create New workbook in MS Excel?
(a) N
(b) F2
(c) Ctrl+s
(d) Ctrl+N


Ans: Ctrl+N

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!