Mid Term Weeks 1 - 4 Part 1

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 7,496
| Attempts: 152
SettingsSettings
Please wait...
  • 1/35 Questions

    Microsoft Excel is an electronic _______________________________ program

    • Software
    • Box
    • Money
Please wait...
Mid Term Weeks 1 - 4 Part 1 - Quiz
About This Quiz

This quiz assesses foundational skills in Microsoft Office applications, focusing on tasks in Word and Excel. Questions cover software basics, interface elements like the Office Button and Ribbon, and document editing techniques. Ideal for learners aiming to improve their office software proficiency.

Quiz Preview

  • 2. 

    Microsoft Excel is an ________________  spreadsheet

    • Big

    • Paper

    • Electronic

    Correct Answer
    A. Electronic
    Explanation
    Microsoft Excel is an electronic spreadsheet.

    Rate this question:

  • 3. 
    What Is The Below Image A Picture of   - ProProfs

    What Is The Below Image A Picture of  

    • Word Button

    • Powerpoint Button

    • Microsoft Office Button

    Correct Answer
    A. Microsoft Office Button
  • 4. 

    The ' / ' In An Exel Formula Will

    • Cut

    • Divide

    • Separate

    Correct Answer
    A. Divide
    Explanation
    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:

  • 5. 

    In the upper left-hand corner of the Word 2007 window is the Microsoft Office  ____________. 

    • Flag

    • Window

    • Button

    Correct Answer
    A. Button
    Explanation
    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:

  • 6. 

    To insert clipart, you need to go to Insert Tab then click ClipArt.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 7. 

    In Excel We Use a comma to ____________  arguments

    • Restore

    • Separate

    • Multiply

    Correct Answer
    A. Separate
    Explanation
    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:

  • 8. 

    How many different documents can you have open at one time?

    • No More Than Three

    • As Many As Your Computer Memory Will Hold

    • Only One

    Correct Answer
    A. As Many As Your Computer Memory Will Hold
    Explanation
    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:

  • 9. 

    Which tabs on the Ribbon do we use to cut and paste?    

    • Home Tab

    • Tools Tab

    • Edit Tab

    Correct Answer
    A. Home Tab
    Explanation
    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:

  • 10. 

    Which keyboard shortcut bolds selected text?

    • Alt + B

    • Ctrl +B

    • Bold

    Correct Answer
    A. Ctrl +B
    Explanation
    The keyboard shortcut "Ctrl + B" is used to bold selected text.

    Rate this question:

  • 11. 

    Accidently you happened to make a mistake while working with your document. What short-cut key you will use to revert the action?

    • Re-Do Typing

    • Can-Do Typing

    • Un-Do Typing

    Correct Answer
    A. Un-Do Typing
    Explanation
    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:

  • 12. 
    Which tab is the picture diagram shows - ProProfs

    Which tab is the picture diagram shows

    • Home Tab

    • Insert Tab

    • Page Layout Tab

    Correct Answer
    A. Home Tab
    Explanation
    The picture diagram shows the Home Tab.

    Rate this question:

  • 13. 

    You Cannot Change The Font of ONLY One Cell In Excel

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 14. 

    In Excel which key moves your cursor from one cell to the next in a table?

    • Ctrl + Enter

    • Tab

    • Shift +Enter

    Correct Answer
    A. Tab
    Explanation
    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:

  • 15. 

    In Excel The equal sign________the function

    • Begins

    • Ends

    • Erases

    Correct Answer
    A. Begins
    Explanation
    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:

  • 16. 

    The simplest way to rearrange text in your document is to ____________.    

    • Cutting, copying and pasting.

    • Drag and drop.

    • 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:

  • 17. 

    Keyboard shortcut for CUT command is ___________.    

    • Ctrl + Z

    • Ctrl + Y

    • Ctrl + X

    Correct Answer
    A. Ctrl + X
    Explanation
    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:

  • 18. 
    The Only Way To Calculate Numbers In Excel Is To Use The Autosum Button Below? - ProProfs

    The Only Way To Calculate Numbers In Excel Is To Use The Autosum Button Below?

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 19. 

    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.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 20. 
    What button is this?   - ProProfs

    What button is this?  

    • Paste

    • Copy

    • Painter

    Correct Answer
    A. Painter
    Explanation
    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:

  • 21. 

    When Typed Into A Formula In Excel Entries Such As +, -, *, or / Are Know As _____________

    • Connectors

    • Operators

    • Separators

    Correct Answer
    A. Operators
    Explanation
    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:

  • 22. 

    In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 23. 
    What button is this picture show? - ProProfs

    What button is this picture show?

    • Font Size

    • Change Case

    • Spelling and Grammar

    Correct Answer
    A. Font Size
    Explanation
    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:

  • 24. 

    In Excel You Can Wrap Text By Which Two Choices Below

    • Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME Tab

    • Type Until The Text Comes Back Around On Its Own

    • 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
    A. Selecting (Highlighting) The Text To Be Wrapped & Clicking The Wrap Text Button On The HOME Tab
    Explanation
    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:

  • 25. 

    In Excel The ____________function adds argument values

    • Currency

    • Multiply

    • Sum

    Correct Answer
    A. Sum
    Explanation
    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:

  • 26. 

    Which tabs on the Ribbon you find the Zoom?     (make sure you consider the probability of the answer options below being available)

    • Home Tab

    • Format Tab

    • Font Tab

    Correct Answer
    A. Home Tab
    Explanation
    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:

  • 27. 

    The ribbon has many labels, or tabs, across the top.  If you click on a tab, additional menu choices will open

    • True

    • False

    Correct Answer
    A. True
    Explanation
    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:

  • 28. 

    The only way to change print margins for document is to enter the margins in the Page Set Up dialog box.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    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:

  • 29. 

     In Excel which keyboard shortcut centers selected text?

    • Ctrl +C

    • Center

    • Alt +C

    Correct Answer
    A. Ctrl +C
    Explanation
    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:

  • 30. 

    What is MS Word?    

    • Its is a typing tool.

    • It is a calculating tool.

    • It is a computerized tool.

    Correct Answer
    A. It is a computerized tool.
  • 31. 

    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

  • 32. 

    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.
    1. Press F5. The Go To dialog box opens.
    2. Type J3 in the Reference field.
    3. Press Enter. Excel moves to cell J3.
    4. TYPE YOUR NAME IN THE CELL

  • 33. 

    Go to -- Ctrl+G You can also use Ctrl+G to go to a specific cell.
    1. Hold down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog box opens.
    2. Type C4 in the Reference field.
    3. Press Enter. Excel moves to cell C4.
    4. TYPE 'SUNDAY' IN THE CELL
    5. PRINT

  • 34. 
    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 - ProProfs

    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

  • 35. 

    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

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 05, 2011
    Quiz Created by
    PCDAC

Popular Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.