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
Discuss itExplanation
MS Excel is a powerful spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas.
Q.2 MS Excel is used for creating?
-
A)
Pie chart
-
B)
Bar chart
-
C)
Chart wizard
-
D)
None
Discuss itExplanation
In older versions of Excel, the Chart Wizard was the primary tool used to guide users through the process of creating charts from spreadsheet data.
Q.3 All macro keyword shortcuts include the ______ key?
-
A)
Alt
-
B)
Ctrl
-
C)
File
-
D)
Shift
Discuss itExplanation
In Excel, when you assign a shortcut key to a macro, it typically requires the Ctrl key (e.g., Ctrl+e) to trigger the automated script.
Q.4 MS Excel is a?
-
A)
Language
-
B)
System software
-
C)
Package
-
D)
None of these
Discuss itExplanation
MS Excel is classified as an application software package, specifically part of the Microsoft Office suite designed for data processing.
Q.5 A worksheet can have a maximum of number of rows in MS Excel 2000?
-
A)
256
-
B)
1024
-
C)
32000
-
D)
65535
Discuss itExplanation
Legacy versions of Excel, such as Excel 2000, had a limit of 65,536 rows (indexed from 1 to 65535) per worksheet.
Q.6 Shortcut key to save a spreadsheet?
-
A)
ctrl+s
-
B)
ctrl+t
-
C)
shift+s
-
D)
alt+s
Discuss itExplanation
Ctrl+S is the standard keyboard shortcut used across most Windows applications to save the current document or progress.
Q.7 Which of these toolbars allows changing of fonts and their sizes?
-
A)
Standard
-
B)
Formatting
-
C)
Print preview
-
D)
None
Discuss itExplanation
The Formatting toolbar contains essential tools for modifying the visual appearance of text, including font type, size, color, and alignment.
Q.8 From which menu you can insert header and footer?
-
A)
Insert menu
-
B)
View menu
-
C)
View menu
-
D)
None
Discuss itExplanation
Headers and footers, which appear at the top and bottom of every printed page, are accessed through the Insert menu in Microsoft Excel.
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
Discuss itExplanation
In Microsoft Office applications like Excel and Word, pressing Ctrl+Alt+C automatically converts the text into the copyright symbol (©).
Q.10 What is the smallest and largest font size available in the formatting toolbar?
-
A)
8 and 62
-
B)
12 and 72
-
C)
8 and 72
-
D)
None
Discuss itExplanation
The standard font size drop-down menu on the formatting toolbar typically provides a range between 8 points and 72 points.
Q.11 Which of following is not a valid data type in Excel?
-
A)
Character
-
B)
Label
-
C)
Date & time
-
D)
None
Discuss itExplanation
While Excel can store characters as text, 'Character' is not a specific formal data type category in Excel like Labels (text), Numbers, or Date/Time.
Q.12 Which menu option can be used to split a window into two?
-
A)
view-split
-
B)
window-split
-
C)
view-window-split
-
D)
None
Discuss itExplanation
Splitting the window allows a user to view two different sections of the same worksheet simultaneously, which is helpful for comparing data.
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
Discuss itExplanation
Excel will fail to calculate the formula if 'sales' is not a predefined named range of cells, resulting in a #NAME? error.
Q.14 To drag a selected range of data to another worksheet in the workbook, use the ______ key?
-
A)
tab
-
B)
ctrl
-
C)
shift
-
D)
None
Discuss itExplanation
Holding the Ctrl key while performing a drag-and-drop operation allows you to copy data from one sheet to another within the same workbook.
Q.15 In a worksheet you can select?
-
A)
Rows
-
B)
Columns
-
C)
The entire worksheet
-
D)
All of these
Discuss itExplanation
Excel provides multiple selection options including clicking row numbers, column letters, or using Ctrl+A to select the entire sheet.
Q.16 An Excel workbook is a collection of?
-
A)
Workbooks
-
B)
Worksheet
-
C)
Chart
-
D)
None
Discuss itExplanation
A workbook is the entire Excel file, which acts as a container for one or more individual worksheets (tabs).
Q.17 Excel files have a default extension on?
-
A)
.xls
-
B)
.xlw
-
C)
XLS
-
D)
None
Discuss itExplanation
The .xls extension was the standard file format for Microsoft Excel versions from 97 through 2003.
Q.18 Which of the following is not one of PowerPoint's views?
-
A)
slide show view
-
B)
slide view
-
C)
presentation view
-
D)
outline view
Discuss itExplanation
Standard PowerPoint view modes include Normal, Slide Sorter, Notes Page, and Slide Show; 'Presentation view' is not a standard standalone view mode.
Q.19 Which shortcut key inserts a new slide in the current presentation?
-
A)
ctrl+m
-
B)
ctrl+n
-
C)
ctrl+s
-
D)
None
Discuss itExplanation
While Ctrl+M is the standard shortcut for a new slide, based on the provided data, Ctrl+N is listed (though it usually starts a brand new file).
Q.20 From which menu you can access picture, text box, and charts?
-
A)
insert
-
B)
edit
-
C)
view
-
D)
None
Discuss itExplanation
The Insert menu allows users to add various objects like images, shapes, charts, and text boxes into their document or spreadsheet.
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 |