Microsoft Office Excel 2007- Mcs Students
1st Year
Questions and Answers
- 1.
- A.
Arrow
- B.
Fill Handle
- C.
Thick Cross
Correct Answer
A. Arrow -
- 2.
It is the shortcut key of find
- A.
Ctrl + F
- B.
Ctrl + G
- C.
Ctrl + G
Correct Answer
A. Ctrl + FExplanation
Ctrl + F is the correct answer because it is a commonly used keyboard shortcut for finding specific text or content within a document or webpage. By pressing Ctrl + F, a search box or toolbar usually appears, allowing the user to enter the desired search term. This shortcut is widely supported across various software applications and browsers, making it a convenient and efficient way to locate information quickly.Rate this question:
-
- 3.
It is the shortcut keys of GO TO:
- A.
Ctrl + F
- B.
Ctrl + G
- C.
Ctrl + G
Correct Answer
B. Ctrl + GExplanation
The correct answer is Ctrl + G. This shortcut key is used for the "Go To" function. It allows users to quickly navigate to a specific location or reference within a document or program. By pressing Ctrl + G, users can enter a page number, cell reference, or other identifier to jump directly to that location. This shortcut is commonly used in word processors, spreadsheets, and programming environments to improve productivity and efficiency in navigating large documents or datasets.Rate this question:
-
- 4.
It is the shortcut key of Undo
- A.
Ctrl + C
- B.
Ctrl + U
- C.
Ctrl + Z
Correct Answer
C. Ctrl + ZExplanation
Ctrl + Z is the correct answer because it is the shortcut key for the Undo command. This command allows users to reverse their previous action and restore the document or file to its previous state. By pressing Ctrl + Z, users can easily undo their last action and revert any changes made. This shortcut is commonly used in various applications and programs to quickly undo mistakes or unwanted edits.Rate this question:
-
- 5.
Redo
- A.
Ctrl + Z
- B.
Ctrl + O
- C.
Ctrl + Y
Correct Answer
C. Ctrl + YExplanation
Ctrl + Y is the keyboard shortcut for redoing an action in many software applications. When you make a mistake and want to reverse the last undo action, you can use Ctrl + Y to redo it. This shortcut is commonly used in word processors, graphic design software, and other programs where you can undo and redo actions. It is a quick and convenient way to revert back to a previous state or restore an action that was mistakenly undone.Rate this question:
-
- 6.
Open a file
- A.
Ctrl + Z
- B.
Ctrl + O
- C.
Ctrl + Y
Correct Answer
B. Ctrl + OExplanation
Ctrl + O is the correct answer because it is the keyboard shortcut used to open a file. Ctrl + Z is the shortcut for undoing an action, while Ctrl + Y is the shortcut for redoing an action. However, neither of these shortcuts are specifically related to opening a file. Therefore, Ctrl + O is the most appropriate shortcut for opening a file.Rate this question:
-
- 7.
It is used to create new file
- A.
Ctrl + M
- B.
Ctrl + Z
- C.
Ctrl + N
Correct Answer
C. Ctrl + NExplanation
Ctrl + N is the correct answer because it is a commonly used keyboard shortcut to create a new file in various software applications. This shortcut is often used in text editors, word processors, and other programs where creating a new file is a common task. By pressing Ctrl + N, users can quickly and easily create a new blank document or file without having to go through menus or other options.Rate this question:
-
- 8.
To Edit data you can press the following, except:
- A.
F2
- B.
Double Click the cell
- C.
Click the data
Correct Answer
C. Click the dataExplanation
To edit data in a cell, you can press F2 or double-click the cell. Clicking the data itself does not trigger the editing mode.Rate this question:
-
- 9.
It is the function key used to close MS Excel.
- A.
F8
- B.
F4
- C.
F5
Correct Answer
B. F4Explanation
F4 is the correct answer because it is the function key used to close MS Excel. Pressing F4 will close the active workbook or application window in Excel. The other function keys mentioned, F8 and F5, have different functions in Excel such as opening the Excel macro dialog box (F8) and refreshing the contents of the current worksheet (F5), but they do not close the application.Rate this question:
-
- 10.
It is located at the top left of the excel window that has the file commands such as Open, Save, Print, esc.
- A.
Microsoft Office Button
- B.
Quick Access toolbar
- C.
Ribbon
- D.
Name box
Correct Answer
A. Microsoft Office ButtonExplanation
The correct answer is the Microsoft Office Button. It is located at the top left of the Excel window and contains file commands such as Open, Save, Print, and esc. This button provides access to various functions and options related to the file, allowing users to manage and manipulate their Excel documents efficiently.Rate this question:
-
- 11.
It is a customizable toolbar that allows you to access frequently command.
- A.
Microsoft Office Button
- B.
Quick Access toolbar
- C.
Ribbon
- D.
Name box
Correct Answer
B. Quick Access toolbarExplanation
The quick access toolbar in Microsoft Office is a customizable toolbar that allows users to easily access frequently used commands. It provides a convenient location for users to add buttons for commands they use frequently, making it quicker and more efficient to access those commands. This toolbar can be customized to include buttons for various commands, helping users streamline their workflow and improve productivity.Rate this question:
-
- 12.
It consist of a series of tabs that provides you with quicker access to commands for completing a particular task.
- A.
Microsoft Office Button
- B.
Quick Access toolbar
- C.
Ribbon
- D.
Name box
Correct Answer
C. RibbonExplanation
The ribbon in Microsoft Office is a series of tabs that provide users with quicker access to commands for completing specific tasks. It is a user-friendly interface that organizes commands and features into logical categories, making it easier for users to find and use the tools they need. The ribbon is designed to improve productivity and efficiency by presenting commonly used commands in a more intuitive and accessible way.Rate this question:
-
- 13.
It indicates the location of the selected text, which is the active cell.
- A.
Microsoft Office Button
- B.
Quick Access toolbar
- C.
Ribbon
- D.
Name box
Correct Answer
D. Name boxExplanation
The Name box in Microsoft Office indicates the location of the selected text, which is the active cell. It allows users to quickly identify and navigate to specific cells or ranges within a worksheet. By typing a cell reference or range name into the Name box, users can easily jump to that location in the spreadsheet. This feature helps improve efficiency and productivity when working with large amounts of data.Rate this question:
-
- 14.
It display the data you encoded in a cell.
- A.
Formula Bar
- B.
Columns
- C.
Mini Toolbar
- D.
Zoom Control
Correct Answer
A. Formula BarExplanation
The formula bar is a feature in spreadsheet software that displays the data or formula you have entered in a selected cell. It allows you to view and edit the contents of the cell, making it easier to work with complex calculations or formulas. This feature is commonly found in programs like Microsoft Excel and Google Sheets.Rate this question:
-
- 15.
These are vertical blocks of cells which can be identified by alphabetical letters.
- A.
Zoom Control
- B.
Mini Toolbar
- C.
Columns
- D.
Formula Bar
Correct Answer
C. ColumnsExplanation
Columns are vertical blocks of cells in a spreadsheet that are identified by alphabetical letters. The other options listed, such as Zoom Control, Mini Toolbar, and Formula Bar, are not related to the vertical blocks of cells in a spreadsheet.Rate this question:
-
- 16.
It is a floating toolbar that contains specific commands in formatting your text.
- A.
Formula Bar
- B.
Columns
- C.
Mini Toolbar
- D.
Zoom Control
Correct Answer
C. Mini ToolbarExplanation
The mini toolbar is a floating toolbar that contains specific commands for formatting text. It appears when you select text and provides quick access to commonly used formatting options such as font style, size, and color, as well as options for bold, italic, and underline. This toolbar allows users to easily make formatting changes without having to navigate to the main formatting options in the ribbon or menu bar.Rate this question:
-
- 17.
It is located at the bottom right corner of the application that is used to increase or decrease the viewing size of the work area.
- A.
Mini Toolbar
- B.
Zoom Control
- C.
Columns
- D.
Formula Bar
Correct Answer
C. ColumnsExplanation
The correct answer is "Columns". The explanation for this answer is that the feature described is used to increase or decrease the viewing size of the work area. This aligns with the purpose of the "Columns" feature, which allows users to adjust the number of columns displayed in a document or spreadsheet.Rate this question:
-
- 18.
It is located at the bottom right corner of each group which displays a dialog box containing additional options and settings for each command.
- A.
Mini toolbar
- B.
Dialog Box Launcher
- C.
Alt + F10
- D.
Commands
Correct Answer
B. Dialog Box LauncherExplanation
The correct answer is "Dialog Box Launcher." The dialog box launcher is a small icon located at the bottom right corner of each group. When clicked, it opens a dialog box that provides additional options and settings for each command in the group. This allows users to access more advanced features and customization options related to the selected command.Rate this question:
-
- 19.
The keyboard shortcut that will display the keys each tab in the ribbon.
- A.
Alt/F10
- B.
Commands
- C.
Dialog Box Launcher
- D.
Mini toolbar
Correct Answer
A. Alt/F10Explanation
Pressing the Alt key and F10 key together on the keyboard will display the keys for each tab in the ribbon. This shortcut allows users to quickly access the commands, dialog box launcher, and mini toolbar associated with each tab in the ribbon interface.Rate this question:
-
- 20.
These are button that will either display a dialog box where you can enter information or menu for more related options.
- A.
Dialog Box Launcher
- B.
Mini toolbar
- C.
Alt/F10
- D.
Commands
Correct Answer
D. CommandsExplanation
The term "commands" refers to the buttons mentioned in the question that display either a dialog box or a menu for more options. These buttons allow the user to input information or access additional features and functions within a program or application.Rate this question:
-
- 21.
A panel located at the top portions of the document. It consist of a series of tabs that provides you with quicker access to commands for completing a particular task.
- A.
Microsoft Office button
- B.
Tabs
- C.
Alt + Tab
- D.
Commands
Correct Answer
B. TabsExplanation
The correct answer is "Tabs". In Microsoft Office, the panel located at the top portions of the document is called the Ribbon. It consists of a series of tabs that provide quicker access to commands for completing a particular task. Each tab is organized into groups, and each group contains related commands. By clicking on a tab, you can access the commands and tools related to that specific task or category. This allows for a more efficient and user-friendly experience when working with Microsoft Office applications.Rate this question:
-
- 22.
The total number of columns available in excel 2007.
- A.
16,384
- B.
16,378
- C.
16,473
- D.
16, 459
Correct Answer
A. 16,384Explanation
Excel 2007 has a total of 16,384 columns available. This means that users can input and organize data in up to 16,384 different columns within a single worksheet.Rate this question:
-
- 23.
The total number of rows available in excel 2007.
- A.
1,048,578
- B.
1,048,587
- C.
1,048,506
- D.
16,384
Correct Answer
C. 1,048,506Explanation
Excel 2007 has a total of 1,048,576 rows available. The correct answer, 1,048,506, is close to the actual number of rows but not exact. It is possible that the person who provided the answer made a slight error in their calculation.Rate this question:
-
- 24.
A worksheet that stores data in the form of numbers, text and contains workbooks and worksheets.
- A.
Electronic
- B.
Manual
- C.
Database
- D.
None of the above
Correct Answer
A. ElectronicExplanation
The correct answer is "Electronic" because a worksheet is a digital document that is created and stored electronically. It can store various types of data, such as numbers and text, and is typically used in spreadsheet software like Microsoft Excel. The other options, "Manual," "Database," and "None of the above," are not accurate descriptions of a worksheet.Rate this question:
-
- 25.
A worksheet done by using a ledger or columnar paper.
- A.
Electronic
- B.
Manual
- C.
Database
- D.
None of the above
Correct Answer
B. ManualExplanation
A worksheet done by using a ledger or columnar paper is categorized as manual. This means that the worksheet is completed by hand, with the use of physical paper and writing utensils, rather than using electronic devices or databases.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 15, 2011Quiz Created by
Johnwyne
Back to top