Computer MCQs Set-11

In this page provide you Computer MCQs Set-11 that is very useful for competitive exams.

 

Q.1 MS Excel is used for creating ?

A) Sending mails
B) Document
C) Spreadsheets
D) Presentation 

ANSWER= (C) Spreadsheets

Check Answer

 

Q.2 MS Excel is used for creating ?

A) Pie chart
B) Bar chart
C) Chart wizard
D) None 

ANSWER= (C) Spreadsheets

Check Answer

 

Q.3 All macro keyword shortcuts include the ——key ?

A) Alt
B) Ctrl
C) File
D) Shift 

ANSWER= (B) Ctrl

Check Answer

 

Q.4 MS Excel is a?

A) Language
B) System software
C) Package
D) None of these 

ANSWER= (C) Package

Check Answer

 

Q.5 A worksheet can have a maximum of number of rows in ms excel 2000 ?

A) 256
B) 1024
C) 32000
D) 65535 

ANSWER= (D) 65535

Check Answer

 

Q.6 Short cut key to save a spread sheet ?

A) ctrl+s
B) ctrl+t
C) shift+s
D) alt+s

ANSWER= (A) ctrl+s

Check Answer

 

Q.7 Which of these toolbars allows changing of fonts and their sizes ?

A) Standard
B) Formatting 
C) Print preview
D) None

ANSWER= (B) Formatting 

Check Answer

 

Q.8 From which menu you can insert header and footer ?

A) Insert menu
B) View menu
C) View menu
D) None

ANSWER= (A) Insert menu

Check Answer

 

Q.9 What is the shortcut key you can press to create a copyright symbol ?

A) alt+c
B) alt+ctrl+c
C) ctrl+shift+c
D) None

ANSWER= (B) alt+ctrl+c

Check Answer

 

Q.10 What is the smallest and largest font size available in formatting toolbar ?

A) 8 and 62
B) 12 and 72
C) 8 and 72
D) None

ANSWER= (C) 8 and 72

Check Answer

 

Q.11 which of following is not a valid data type in excel ?

A) Character
B) Label
C) Date & time
D) None

ANSWER= (A) Character

Check Answer

 

Q.12 Which menu option can be used to split window into two ?

A) view-split
B) window-split
C) view-window-split
D) None

ANSWER= (C) view-window-split

Check Answer

 

Q.13 Which of the following formulas will excel not be able to calculate ?

A) =sum(a1:a5)*5
B) =sum(sales)-a3
C) =sum(a1:a5)-10
D) None

ANSWER= (B) =sum(sales)-a3

Check Answer

 

Q.14 To drag a selected range of data to another worksheet in the work book ,use the–?

A) tab key
B) ctrl key
C) shift key
D) None

ANSWER= (B) ctrl key

Check Answer

 

Q.15 In a worksheet you can select—-?

A) Rows
B) Columns
C) The entire worksheet
D) All of these 

ANSWER= (D) All of these

Check Answer

 

Q.16 An excel workbook is a collection of ?

A) Workbooks
B) Worksheet
C) Chart
D) None 

ANSWER= (B) Worksheet

Check Answer

 

Q.17 Excel files have a default extension on ?

A) .xls
B) .xlw
C) XLS
D) None 

ANSWER= (A) .xls

Check Answer

 

Q.18 Which of the following is not one of power points view ?

A) slide show view
B) slide view
C) presentation view
D) outline view 

ANSWER= (C) presentation view

Check Answer

 

Q.19 Which shortcut key inserts a new slide in current presentation ?

A) ctrl+m
B) ctrl+n
C) ctrl+s
D) None 

ANSWER= (B) ctrl+n

Check Answer

 

Q.20 From which menu you can access picture text box chart ete ?

A) insert
B) edit
C) view
D) None 

ANSWER= (A) insert

Check Answer

Related MCQs

1 To 20	✪ Computer MCQs Set-1	CLICK
21 To 40	✪ Computer MCQs Set-2	CLICK
41 To 60	✪ Computer MCQs Set-3	CLICK
61 To 80	✪ Computer MCQs Set-4	CLICK
81 To 100	✪ Computer MCQs Set-5	CLICK
101 To 120	✪ Computer MCQs Set-6	CLICK
121 To 140	✪ Computer MCQs Set-7	CLICK
141 To 160	✪ Computer MCQs Set-8	CLICK
161 To 180	✪ Computer MCQs Set-9	CLICK
181 To 200	✪ Computer MCQs Set-10	CLICK

1. Official Telegram	Click Here
2. Telegram For CSE MCQs	Click Here
3. You Tube	Click Here