Q2201
Medium
To unhide column shortcut key is______
note!Answer: B) Ctrl + Shift + )
Ctrl + Shift + ) unhides selected columns; Ctrl + 0 hides them.
Computer & IT
कम्प्युटर
Subjects
Computer Fundamental
कम्प्युटरको आधारभूत ज्ञान Hardware, memory, generations, number systems 723 questionsComputer Networking
कम्प्युटर नेटवर्किङ Networks, internet, protocols 216 questionsOperating System
अपरेटिङ सिस्टम Windows, Linux, files and processes 248 questionsWord Processing
वर्ड प्रोसेसिङ MS Word and documents 588 questionsElectronic Spreadsheet
इलेक्ट्रोनिक स्प्रेडसिट MS Excel, formulas, charts 416 questionsPresentation System
प्रस्तुतीकरण प्रणाली MS PowerPoint and slides 116 questionsDatabase System
डाटाबेस प्रणाली DBMS, SQL, MS Access 347 questionsWebpage Designing
वेबपेज डिजाइन HTML, CSS and the web 142 questionsAll questions
Showing 2201–2220 of 2,796 · Mix the order
Q2202
Medium
To unhide rows shortcut key is______
note!Answer: A) Ctrl + Shift + (
Ctrl + Shift + ( unhides selected rows; Ctrl + 9 hides them.
Q2203
Easy
In a cell, default width of the column is:
note!Answer: B) 8.43
The default column width in Excel is 8.43 characters.
Q2204
Easy
How can we hide column?
note!Answer: A) Format→Column→hide
In Excel, Format → Hide & Unhide → Hide Columns (or Format → Column → Hide) hides a column.
Q2205
Easy
Which is the default font when we open the new work book on Ms-Excel 2007?
note!Answer: B) Calibri
Excel 2007 uses Calibri 11 as the default font in new workbooks.
Q2206
Easy
The shortcut key to insert new worksheet is
note!Answer: A) Shift + F11
Shift + F11 inserts a new worksheet in Excel.
Q2207
Easy
What are the different types of file attributes?
note!Answer: D) All of the above
Common file attributes include Read-only, Hidden, Archive, and System.
Q2208
Medium
The shortcut key to group the column is______
note!Answer: B) Alt + Shift + →
Alt + Shift + Right Arrow groups selected rows or columns in Excel.
Q2209
Medium
The shortcut key to ungroup the column is______
note!Answer: A) Alt + Shift + ←
Alt + Shift + Left Arrow ungroups the selected rows or columns in Excel.
Q2210
Easy
What is the native file format for MS Excel?
note!Answer: C) .xls
Excel's traditional native workbook format is .xls (Excel 97-2003). Later versions use .xlsx.
Q2211
Easy
What is the shortcut key when you want to go to the next spread sheet?
note!Answer: C) Ctrl+page down
Ctrl+Page Down moves to the next worksheet in the workbook. Ctrl+Page Up moves to the previous one.
Q2212
Easy
MS excel is available only to Windows.
note!Answer: B) False
Microsoft Excel is also available for macOS, along with mobile and web versions.
Q2213
Easy
Which MS Excel version never existed?
note!Answer: B) MS Excel 2006
Excel versions went 2000, XP (2002), 2003, 2007, and so on. There was no Excel 2006.
Q2214
Easy
What is the shortcut key to save the current spreadsheet you are working on?
note!Answer: C) Ctrl+s
Ctrl+S saves the current file. Ctrl+W closes the window.
Q2215
Medium
Which of the following key is used for ungroup rows or column?
note!Answer: A) Alt+Shift+ ←
Alt+Shift+Left Arrow ungroups selected rows or columns. Alt+Shift+Right Arrow groups them.
Q2216
Easy
MS Excel is distributed by which company?
note!Answer: B) Microsoft
Microsoft develops and distributes Excel as part of the Microsoft Office suite.
Q2217
Easy
What is the short cut key for selecting the whole spreadsheet?
note!Answer: B) Ctrl+a
Ctrl+A selects the entire worksheet. Pressing it again within a data region may select the whole sheet.
Q2218
Easy
What does the F1 key activate?
note!Answer: A) Help
F1 opens the Help window in Microsoft Office programs.
Q2219
Easy
What is the shortcut key for editing the current cell you have selected?
note!Answer: B) F2
F2 puts the selected cell into edit mode. F5 opens Go To.
Q2220
Easy
what shortcut key of to open an old file
note!Answer: B) ctrl+o
Ctrl+O opens the Open dialog to choose an existing file. Ctrl+N creates a new file.