Mid Term Weeks 1 - 4 Part 1
Questions and Answers
- 1.
Microsoft Excel is an electronic _______________________________ program
- A.
Software
- B.
Box
- C.
Money
Correct Answer
A. SoftwareExplanation
Microsoft Excel is an electronic software program. It is a spreadsheet software developed by Microsoft that allows users to create, manipulate, and analyze data using formulas and functions. The program is widely used for various purposes such as data organization, financial analysis, and data visualization.Rate this question:
-
- 2.
In the upper left-hand corner of the Word 2007 window is the Microsoft Office ____________.
- A.
Flag
- B.
Window
- C.
Button
Correct Answer
C. ButtonExplanation
In the upper left-hand corner of the Word 2007 window is the Microsoft Office Button. This button is used to access various functions and features in Word, such as opening, saving, and printing documents, as well as accessing options for customizing the program. It is an important tool for navigating and managing documents in Word 2007.Rate this question:
-
- 3.
Which tabs on the Ribbon you find the Zoom? (make sure you consider the probability of the answer options below being available)
- A.
Home Tab
- B.
Format Tab
- C.
Font Tab
Correct Answer
A. Home TabExplanation
The Zoom option can be found on the Home tab of the Ribbon. This tab typically contains options related to basic formatting, editing, and viewing of documents. The Zoom option allows users to adjust the zoom level of the document, making it easier to view and work with.Rate this question:
-
- 4.
What is MS Word?
- A.
Its is a typing tool.
- B.
It is a calculating tool.
- C.
It is a computerized tool.
Correct Answer
C. It is a computerized tool. -
- 5.
Which tabs on the Ribbon do we use to cut and paste?
- A.
Home Tab
- B.
Tools Tab
- C.
Edit Tab
Correct Answer
A. Home TabExplanation
The Home Tab on the Ribbon is used to cut and paste. It contains the Cut and Paste buttons, which allow users to remove selected content and then insert it elsewhere in the document. The Home Tab is commonly used for basic formatting and editing tasks in various Microsoft Office applications.Rate this question:
-
- 6.
The simplest way to rearrange text in your document is to ____________.
- A.
Cutting, copying and pasting.
- B.
Drag and drop.
- C.
Type and Replace.
Correct Answer
A. Cutting, copying and pasting.Explanation
The simplest way to rearrange text in your document is by cutting, copying, and pasting. This allows you to move or duplicate text from one location to another. Drag and drop can also be used to rearrange text, but it may not be as efficient as cutting, copying, and pasting for larger sections of text. Typing and replacing refers to manually retyping and replacing the text, which is not the simplest way to rearrange text.Rate this question:
-
- 7.
Keyboard shortcut for CUT command is ___________.
- A.
Ctrl + Z
- B.
Ctrl + Y
- C.
Ctrl + X
Correct Answer
C. Ctrl + XExplanation
The correct answer is Ctrl + X. This keyboard shortcut is commonly used to cut selected text or objects and place them in the clipboard. It is a widely recognized and frequently used shortcut in various operating systems and applications.Rate this question:
-
- 8.
Which keyboard shortcut bolds selected text?
- A.
Alt + B
- B.
Ctrl +B
- C.
Bold
Correct Answer
B. Ctrl +BExplanation
The keyboard shortcut "Ctrl + B" is used to bold selected text.Rate this question:
-
- 9.
Which tab is the picture diagram shows
- A.
Home Tab
- B.
Insert Tab
- C.
Page Layout Tab
Correct Answer
A. Home TabExplanation
The picture diagram shows the Home Tab.Rate this question:
-
- 10.
In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Charts in Excel can remain linked or connected to their data sources even if they appear in different worksheets. This allows for dynamic updating of the chart whenever the data in the source worksheet is changed. By selecting the chart and going to the "Design" tab in the Chart Tools menu, users can check the "Chart Data Range" to see the source data or use the "Select Data" option to change the data source. Therefore, the correct answer is false.Rate this question:
-
- 11.
The ribbon has many labels, or tabs, across the top. If you click on a tab, additional menu choices will open
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The explanation for the correct answer is that the ribbon in a software program typically contains multiple labels or tabs at the top. When a user clicks on one of these tabs, it will expand and display additional menu choices or options. This allows the user to access different features or functions within the program. Therefore, the statement that "if you click on a tab, additional menu choices will open" is true.Rate this question:
-
- 12.
To insert clipart, you need to go to Insert Tab then click ClipArt.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The explanation for the given answer is that to insert clipart, you do need to go to the Insert Tab in the software or program you are using, and then click on the ClipArt option. This is a correct statement as it accurately describes the process of inserting clipart.Rate this question:
-
- 13.
Be careful when you delete text from a document, because after you deleted or choose Cut, the data is gone and you cannot get it back.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When deleting text from a document or choosing the "Cut" option, the data is not permanently gone. It is temporarily stored in the clipboard, allowing you to paste it elsewhere. Therefore, you can retrieve the deleted or cut text by pasting it back into the document or another location.Rate this question:
-
- 14.
The only way to change print margins for document is to enter the margins in the Page Set Up dialog box.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false. There are multiple ways to change print margins for a document. One way is to enter the margins in the Page Set Up dialog box, but it is not the only way. Other ways include adjusting the margins directly in the document by dragging the margin markers on the ruler, or by selecting a predefined margin setting from the Page Layout tab in the ribbon.Rate this question:
-
- 15.
What button is this picture show?
- A.
Font Size
- B.
Change Case
- C.
Spelling and Grammar
Correct Answer
A. Font SizeExplanation
The picture shows a button with the label "Font Size". The other options mentioned in the question (Change Case and Spelling and Grammar) are not relevant to the picture. Therefore, the correct answer is Font Size.Rate this question:
-
- 16.
What button is this?
- A.
Paste
- B.
Copy
- C.
Painter
Correct Answer
C. PainterExplanation
The correct answer is "Painter" because the question asks for the name of the button, and out of the given options, "Painter" is the only one that matches. "Paste" and "Copy" are common buttons found in various applications, but they are not the correct answer in this context.Rate this question:
-
- 17.
Accidently you happened to make a mistake while working with your document. What short-cut key you will use to revert the action?
- A.
Re-Do Typing
- B.
Can-Do Typing
- C.
Un-Do Typing
Correct Answer
C. Un-Do TypingExplanation
The shortcut key to revert the action of a mistake made while working with a document is "Un-Do Typing". This shortcut allows you to undo the last action or typing that was performed, effectively reversing the mistake that was made.Rate this question:
-
- 18.
Open Your Email and Open The Document Sent From Me Called Word Test Use The Spell Check To Correct Spelling - Right Down The Number of Misspelled Words Change The Font To Bookman Old Style Change The Paragraph Alignment To Justified Type Your Name At The Bottom Left of The Page Save The Document In Your My Documents Folder As Word Test Print
- 19.
The F5 function key is the "Go To" key. If you press the F5 key, you are prompted for the cell to which you wish to go. Enter the cell address, and the cursor jumps to that cell.
- Press F5. The Go To dialog box opens.
- Type J3 in the Reference field.
- Press Enter. Excel moves to cell J3.
- TYPE YOUR NAME IN THE CELL
- 20.
Go to -- Ctrl+G You can also use Ctrl+G to go to a specific cell.
- Hold down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog box opens.
- Type C4 in the Reference field.
- Press Enter. Excel moves to cell C4.
- TYPE 'SUNDAY' IN THE CELL
- 21.
Microsoft Excel is an ________________ spreadsheet
- A.
Big
- B.
Paper
- C.
Electronic
Correct Answer
C. ElectronicExplanation
Microsoft Excel is an electronic spreadsheet.Rate this question:
-
- 22.
What Is The Below Image A Picture of
- A.
Word Button
- B.
Powerpoint Button
- C.
Microsoft Office Button
Correct Answer
C. Microsoft Office Button -
- 23.
In Excel We Use a comma to ____________ arguments
- A.
Restore
- B.
Separate
- C.
Multiply
Correct Answer
B. SeparateExplanation
In Excel, we use a comma to separate arguments. This means that when we are entering multiple arguments in a formula or function, we need to separate them using commas. This helps Excel understand the different inputs and perform the desired calculation accurately. Without using commas to separate arguments, Excel may interpret the inputs incorrectly and give incorrect results.Rate this question:
-
- 24.
In Excel The ____________function adds argument values
- A.
Currency
- B.
Multiply
- C.
Sum
Correct Answer
C. SumExplanation
The "Sum" function in Excel is used to add up the values of a range of cells or a list of numbers. It takes the argument values and adds them together to give a total sum. This function is commonly used in calculations and data analysis in Excel.Rate this question:
-
- 25.
In Excel The equal sign________the function
- A.
Begins
- B.
Ends
- C.
Erases
Correct Answer
A. BeginsExplanation
In Excel, the equal sign is used to indicate the start of a function. This allows the user to perform calculations or manipulate data using built-in functions. By typing the equal sign before a function name, Excel recognizes that a function is being used and will execute the function accordingly. Therefore, the equal sign "begins" the function in Excel.Rate this question:
-
- 26.
The ' / ' In An Exel Formula Will
- A.
Cut
- B.
Divide
- C.
Separate
Correct Answer
B. DivideExplanation
The '/' symbol in an Excel formula is used to divide one number by another. It performs the mathematical operation of division, resulting in the quotient of the two numbers.Rate this question:
-
- 27.
When Typed Into A Formula In Excel Entries Such As +, -, *, or / Are Know As _____________
- A.
Connectors
- B.
Operators
- C.
Separators
Correct Answer
B. OperatorsExplanation
Operators in Excel are symbols or characters that perform mathematical or logical operations on values in a formula. They include symbols like + (addition), - (subtraction), * (multiplication), and / (division). These operators allow users to perform calculations and manipulate data in Excel formulas.Rate this question:
-
- 28.
In Excel You Can Wrap Text By Which Two Choices Below
- A.
Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME Tab
- B.
Type Until The Text Comes Back Around On Its Own
- C.
Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME Tab
Correct Answer(s)
A. Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME Tab
C. Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME TabExplanation
To wrap text in Excel, you need to select (highlight) the text that you want to wrap and then click the Wrap Text button on the Home tab. This will automatically adjust the height of the cell to fit the wrapped text.Rate this question:
-
- 29.
The Only Way To Calculate Numbers In Excel Is To Use The Autosum Button Below?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because there are multiple ways to calculate numbers in Excel, not just by using the Autosum button. Users can also use formulas, functions, and manual calculations to perform calculations in Excel.Rate this question:
-
- 30.
You Cannot Change The Font of ONLY One Cell In Excel
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In Excel, you can change the font of only one cell by selecting that specific cell and applying the desired font formatting. Therefore, the statement "You Cannot Change The Font of ONLY One Cell In Excel" is false.Rate this question:
-
- 31.
Open An Excel Spreadsheet and on SHEET 1 Enter The Below Table Information MAKE SURE YOU USE THE PROPER FUNCTION TO GET THE TOTAL OF CELLS AFTER GETTING THE TOTALS IN CELL A15 ENTER THE FORMULA FUNCTION OPERATORS TO DIVIDE THE TOTAL BY THE NUMBER OF PHASE ROW ENTRIES (COUNT THE ROWS TO GET THE NUMBER) TO CREATE AN AVERAGE DO NOT SIMPLY TYPE THE AMOUNT SAVE THE SPREADSHEET AS MID TERM
- 32.
EXTRA CREDIT: USE THE SAME TABLE OF DATA FROM QUESTION 31 TO CREATE A 3D CLUSTER COLUMN CHART ON THE SAME SHEET. SAVE THE SHEET
- 33.
In Excel which keyboard shortcut centers selected text?
- A.
Ctrl +C
- B.
Center
- C.
Alt +C
Correct Answer
A. Ctrl +CExplanation
The keyboard shortcut Ctrl + C is used to copy selected text in Excel, not to center it. Therefore, the correct answer is not Ctrl + C.Rate this question:
-
- 34.
In Excel which key moves your cursor from one cell to the next in a table?
- A.
Ctrl + Enter
- B.
Tab
- C.
Shift +Enter
Correct Answer
B. TabExplanation
The Tab key is used to move the cursor from one cell to the next in a table in Excel. Pressing the Tab key allows you to quickly navigate through the cells in a row, moving from left to right. This is a commonly used shortcut in Excel to efficiently enter data or move between cells during data entry or editing.Rate this question:
-
- 35.
How many different documents can you have open at one time?
- A.
No More Than Three
- B.
As Many As Your Computer Memory Will Hold
- C.
Only One
Correct Answer
B. As Many As Your Computer Memory Will HoldExplanation
The correct answer is "As Many As Your Computer Memory Will Hold." This means that the number of different documents that can be open at one time is limited by the amount of computer memory available. The more memory a computer has, the more documents it can handle simultaneously.Rate this question:
-
.gif "What Is The Below Image A Picture of")
.jpg "The Only Way To Calculate Numbers In Excel Is To Use The Autosum Button Below?")
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 -
Jul 05, 2011Quiz Created by
PCDAC
- Accreditation Quizzes
- Advanced Placement Quizzes
- AED Exam Quizzes
- Art Exam Quizzes
- Banking Exam Quizzes
- BISC Exam Quizzes
- CADET Exam Quizzes
- CAE Listening Quizzes
- CHS Exam Quizzes
- Computer Operator Exam Quizzes
- Cosmetology State Board Quizzes
- CSAT Quizzes
- CVS Exam Quizzes
- EHR Exam Quizzes
- Engineering Exam Quizzes
- English Exam Quizzes
- Entrance Exam Quizzes
- FSHN Exam Quizzes
- GATE Quizzes
- IGCSE Quizzes
- IT Certification Quizzes
- JEE Exam Quizzes
- Management Exam Quizzes
- Ministerial Exam Quizzes
- OCA Exam Quizzes
- Physical Exam Quizzes
- Police Exam Quizzes
- Practice Exam Quizzes
- Prelim Exam Quizzes
- Professional Certification Quizzes
- SNAP Quizzes
- SSC Quizzes
- SSC CGL Quizzes
- UGC NET Exam Quizzes
- UPSC Quizzes
Back to top