In this page provide you Computer MCQs Set-11 that is very useful for competitive exams.
Q.1 MS Excel is used for creating?
Sending mails
Document
Spreadsheets
Presentation
Explanation
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?
Pie chart
Bar chart
Chart wizard
None
Explanation
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?
Alt
Ctrl
File
Shift
Explanation
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?
Language
System software
Package
None of these
Explanation
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?
256
1024
32000
65535
Explanation
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?
ctrl+s
ctrl+t
shift+s
alt+s
Explanation
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?
Standard
Formatting
Print preview
None
Explanation
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?
Insert menu
View menu
View menu
None
Explanation
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?
alt+c
alt+ctrl+c
ctrl+shift+c
None
Explanation
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?
8 and 62
12 and 72
8 and 72
None
Explanation
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?
Character
Label
Date & time
None
Explanation
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?
view-split
window-split
view-window-split
None
Explanation
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?
=sum(a1:a5)*5
=sum(sales)-a3
=sum(a1:a5)-10
None
Explanation
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?
tab
ctrl
shift
None
Explanation
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?
Rows
Columns
The entire worksheet
All of these
Explanation
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?
Workbooks
Worksheet
Chart
None
Explanation
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?
.xls
.xlw
XLS
None
Explanation
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?
slide show view
slide view
presentation view
outline view
Explanation
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?
ctrl+m
ctrl+n
ctrl+s
None
Explanation
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?
insert
edit
view
None
Explanation
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 |