Computer Literacy Final Exam Part II

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: 3,271
SettingsSettings
Please wait...
  • 1/25 Questions

    1.  CLICK THE LINK BELOW  2.  READ THROUGH THE LESSON 3.  FOLLOW THROUGH AND USE THE EXAMPLES TO CREATE A SLIDE IN POWERPOINT (USE YOUR OWN IMAGINATION FOR ONE SLIDE) AND BE SURE TO ADD A FOOTER 4.  PRINT THE SLIDE YOU CREATED  5.  SAVE THE SLIDE AS FINAL IN YOUR MY DOCUMENTS FOLDER 6.  COMPLETE THE SELF-TEST 7.  PRINT THE SELF-TEST http://office.microsoft.com/en-us/powerpoint-help/add-slide-numbers-and-other-footers-to-slides-RZ010258800.aspx

Please wait...
About This Quiz

This final exam for COMPUTER LITERACY PART II focuses on Excel skills such as managing cell formats, understanding worksheet components, and navigating through data. It tests practical knowledge essential for effective spreadsheet management and data organization.

Computer Literacy Final Exam Part II - Quiz

Quiz Preview

  • 2. 

    AN EXCEL WORKSHEET IS 

    • A PAGE WITH RECTANGLES

    • A TABLE OF DATA ORGANIZED IN ROWS AND COLUMNS

    • A GRAPH

    • NONE OF THE ABOVE

    Correct Answer
    A. A TABLE OF DATA ORGANIZED IN ROWS AND COLUMNS
    Explanation
    An Excel worksheet is a table of data organized in rows and columns. It is a digital representation of a spreadsheet where users can input and manipulate data. The rows are labeled with numbers, and the columns are labeled with letters. Each rectangular cell within the table can contain text, numbers, formulas, or functions. Excel worksheets are commonly used for calculations, data analysis, and creating charts or graphs based on the data entered.

    Rate this question:

  • 3. 

    A POWERPOINT PRESENTATION IS MADE UP OF A SERIES OF

    • COOPER'S EYE GLASS LENS

    • SLIDES

    • LAYOUTS

    • PICTURES

    Correct Answer
    A. SLIDES
    Explanation
    A PowerPoint presentation is made up of a series of slides. Each slide contains information, such as text, images, or graphs, that is presented to the audience. Slides are used to organize and present information in a logical and visually appealing manner. They can be customized with different layouts, themes, and designs to enhance the overall presentation. Therefore, the correct answer is "slides".

    Rate this question:

  • 4. 

    WHAT DO YOU TYPE IN EXCEL TO START A FORMULA

    • /

    • *

    • START FORMULA

    • =

    Correct Answer
    A. =
    Explanation
    To start a formula in Excel, you need to type the equals sign (=) followed by the formula or function you want to use. The equals sign tells Excel that you are entering a formula and not just a regular text or number entry. This is the standard way to begin any formula in Excel.

    Rate this question:

  • 5. 

    'CTRL B' IS A SHORTCUT FOR

    • ADDING A BORDER

    • GOING BACKWARDS

    • BOLDING TEXT

    • NONE OF THE ABOVE

    Correct Answer
    A. BOLDING TEXT
    Explanation
    'CTRL B' is a commonly used keyboard shortcut for applying the bold formatting to selected text in various text editing software or word processors. It is a quick and convenient way to emphasize or highlight important information in a document.

    Rate this question:

  • 6. 

    IN EXCEL A QUICK WAY TO ADD UP NUMBERS IN A COLUMN WOULD BE TO CLICK ON / IN THE CELL BELOW THE COLUMN OF NUMBERS AND THEN 

    • WAIT FOR THE TOTAL TO SHOW

    • ASK MOSES TO ADD IT UP FOR YOU

    • CLICK THE EQUAL SIGN

    • CLICK THE AUTOSUM BUTTON ON THE STANDARD TOOLBAR AND THEN CLICK ENTER

    Correct Answer
    A. CLICK THE AUTOSUM BUTTON ON THE STANDARD TOOLBAR AND THEN CLICK ENTER
    Explanation
    In Excel, the quickest way to add up numbers in a column is to use the Autosum button on the standard toolbar. By clicking on the Autosum button, Excel automatically selects the range of cells above the active cell and inserts the SUM function. Then, by clicking Enter, Excel calculates the total and displays it in the active cell.

    Rate this question:

  • 7. 

    WHEN YOU PRESS 'ENTER' IN EXCEL IT WILL MOVE ONE COLUMN TO THE LEFT

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When you press 'Enter' in Excel, it moves the cursor down to the next cell in the same column, not one column to the left.

    Rate this question:

  • 8. 

    TO ACCESS THE MAIL MERGE TASK PANE YOU MUST CLICK TOOLS, AND ON THE TOOLS MENU YOU MUST CLICK 'MAIL MERGE'

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The given statement is true because to access the mail merge task pane, you need to click on the "Tools" menu and then select "Mail Merge" from the options. This implies that the statement accurately describes the correct steps to access the mail merge task pane.

    Rate this question:

  • 9. 

    THE NAME BOX SHOWS YOU THE CONTENT OF THE CELL

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the name box in a spreadsheet program, such as Microsoft Excel, displays the content of the selected cell. It is located at the top left corner of the program and allows users to easily view and edit the data in a specific cell. This feature is helpful for navigating and managing large amounts of data in a spreadsheet.

    Rate this question:

  • 10. 

    WHEN A CELL SHOWS '#######' IN IT, IT USUALLY MEANS

    • JOHN AND CHRIS ARE PLAYING TICK-TAC-TOE

    • THERE IS NO DATA IN THE CELL

    • THE CELL WIDTH NEEDS TO BE ADJUSTED TO SHOW THE DATA

    • THE DATA IN THE CELL IS MISSPELLED

    Correct Answer
    A. THE CELL WIDTH NEEDS TO BE ADJUSTED TO SHOW THE DATA
    Explanation
    When a cell shows '#######' in it, it usually means that the cell width needs to be adjusted to show the data. The '#######' symbol is a result of the data being too wide for the cell, causing it to be displayed as a series of hashtags. By increasing the width of the cell, the data will be able to fit properly and be displayed correctly.

    Rate this question:

  • 11. 

    YOU CANNOT EDIT DATA ONCE YOU HAVE EXITED THE CELL YOU ENTERED IT IN

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The correct answer is False. This means that you can edit data even after exiting the cell you entered it in.

    Rate this question:

  • 12. 

    MAIL MERGE MERGES A DOCUMENT WITH A MAILING LIST

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Mail merge is a feature in word processing software that allows users to combine a document template with a data source, such as a mailing list, to create personalized letters or other documents. The data from the mailing list is merged into the document, resulting in a customized version for each recipient. Therefore, the statement "Mail merge merges a document with a mailing list" is true.

    Rate this question:

  • 13. 

    HOW DO YOU KNOW WHICH CELL IN EXCEL IS THE ACTIVE ONE (THE ONE YOU ARE WORKING IN)

    • A DOTTED BORDER

    • BOLD TEXT

    • A BLINKING BORDER

    • A SOLID DARK, WIDE BORDER

    Correct Answer
    A. A SOLID DARK, WIDE BORDER
    Explanation
    A solid dark, wide border is used in Excel to indicate the active cell, which is the cell that the user is currently working in. This border helps the user easily identify the cell they are working on and distinguish it from other cells in the spreadsheet.

    Rate this question:

  • 14. 

    YOU CAN INSERT A HEADER IN MSWORD BUY USING THE 'HEADER' BUTTON ON THE _______________ TAB (one word)

    Correct Answer
    INSERT
    insert
    Insert
    Explanation
    The correct answer is "INSERT". In MS Word, you can insert a header by using the "Header" button on the "INSERT" tab.

    Rate this question:

  • 15. 

    WHICH MICROSOFT OFFICE PROGRAMS/SOFTWARES HAVE THE RIBBON

    • WORD

    • EXCEL

    • ACCESS

    • POWERPOINT

    • ALL OF THE ABOVE

    Correct Answer
    A. ALL OF THE ABOVE
    Explanation
    All of the Microsoft Office programs/software mentioned in the list (Word, Excel, Access, and PowerPoint) have the Ribbon. The Ribbon is a user interface element that was introduced in Microsoft Office 2007, and it replaced the traditional menu and toolbar system. It is designed to make it easier for users to find and use the various features and commands in the Office programs. Therefore, all of the mentioned programs have the Ribbon.

    Rate this question:

  • 16. 

    MAIL MERGE ALLOWS YOU TO SEND THE SAME LETTER TO THE SAME PERSON

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Mail merge does not allow you to send the same letter to the same person. In fact, mail merge is a feature in word processing software that allows you to create personalized letters or documents by merging a template with a data source, such as a spreadsheet or a database. This allows you to send customized letters to different individuals, with each letter containing unique information specific to the recipient.

    Rate this question:

  • 17. 

    IF THERE ARE TOO MANY NUMBERS AFTER A DECIMAL IN A CELL WHAT CAN YOU DO TO VIEW THE MISSING NUMBERS

    • SCROLL IN THE CELL

    • DECREASE THE COLUMN WIDTH

    • REENTER THE NUMBERS

    • NONE OF THE ABOVE

    Correct Answer
    A. NONE OF THE ABOVE
    Explanation
    If there are too many numbers after a decimal in a cell, you cannot view the missing numbers by scrolling in the cell, decreasing the column width, or reentering the numbers. The correct answer "NONE OF THE ABOVE" suggests that there is no specific action that can be taken to view the missing numbers in this scenario.

    Rate this question:

  • 18. 

    UNLIKE EXCEL, OTHER SPREADSHEET SOFTWARE HAVE LIMITATIONS BECAUSE THEY

    • USE THIN DATA

    • ARE A FLAT FILE

    • JUST DON'T WORK

    • KEEP MISSPELLING DRINKWATER

    Correct Answer
    A. ARE A FLAT FILE
    Explanation
    Other spreadsheet software have limitations because they are a flat file. This means that they do not have the same level of functionality and capabilities as Excel. Excel, on the other hand, offers a wide range of features and tools that allow users to manipulate and analyze data in a more advanced and efficient manner.

    Rate this question:

  • 19. 

    EXCEL HAS A LIMITED AMOUNT OF DATA THAT CAN BE ORGANIZED IN A SPREADSHEET (think carefully)

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Excel does have a limited amount of data that can be organized in a spreadsheet. This is because Excel has a maximum row limit of 1,048,576 rows and a maximum column limit of 16,384 columns. Once these limits are reached, it is not possible to add any more data to the spreadsheet. Therefore, the statement "Excel has a limited amount of data that can be organized in a spreadsheet" is true.

    Rate this question:

  • 20. 

    A MAIL MERGE LIST CAN CONTAIN MULTIPLE ADDRESSES BUT NOT MULTIPLE RECORDS (PEOPLE)

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is incorrect. A mail merge list can contain multiple records (people) with their respective addresses. In a mail merge, multiple records from a data source, such as a spreadsheet or a database, can be merged with a template document to create personalized documents for each record. Therefore, the statement that a mail merge list cannot contain multiple records is false.

    Rate this question:

  • 21. 

    WHICH OF THE FOLLOWING ALLOWS YOU TO POSITION THE DATA CORRECTLY IN A MAIL MERGE?

    • INSERT

    • ENTER KEY

    • PLACEHOLDERS

    • NONE OF THE ABOVE

    Correct Answer
    A. PLACEHOLDERS
    Explanation
    Placeholders allow you to position the data correctly in a mail merge. Placeholders are used to indicate where the data from the data source should be inserted in the merged document. They act as a placeholder for the data and ensure that it is positioned correctly in the final merged document. This allows for customization and organization of the data in the merged document.

    Rate this question:

  • 22. 

    IN MSWORD WHICH TOOLBAR DO I USE TO INSERT A HEADER?

    • MAILINGS

    • VIEW

    • HOME

    • NONE OF THE ABOVE

    Correct Answer
    A. NONE OF THE ABOVE
    Explanation
    In MS Word, the toolbar used to insert a header is the "Insert" toolbar. This toolbar contains various options for inserting different elements into a document, including headers and footers. The "Mailings" toolbar is used for tasks related to mail merge, the "View" toolbar is used for changing the view of the document, and the "Home" toolbar is used for basic formatting options. Therefore, the correct answer is "None of the above" as the "Insert" toolbar is used to insert a header.

    Rate this question:

  • 23. 

    ONCE YOU HIDE A ROW IT REMAINS HIDDEN AS LONG AS THE WORKBOOK IS ACTIVE

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Once you hide a row in a workbook, it remains hidden even if the workbook is active.

    Rate this question:

  • 24. 

    IN EXCEL 'EURO' IS A

    • FORMULA

    • CELL NAME

    • DATA TYPE

    • NONE OF THE ABOVE

    Correct Answer
    A. DATA TYPE
    Explanation
    In Excel, 'EURO' is a data type. This means that it is a specific format for representing currency values in euros. Excel allows users to apply different data types to cells, such as dates, times, percentages, and currencies, to ensure that the data is displayed and calculated correctly. By selecting the 'EURO' data type for a cell, any value entered into that cell will be recognized as a euro currency value and can be used in calculations or formatting specific to euros.

    Rate this question:

  • 25. 

    WHAT ITEMS ARE MERGED DURING A MAIL MERGE?

    • A WEB PAGE AND A MAILING LIST

    • AN EMAIL AND A MAILING LIST

    • AN EMAIL AND A WORD DOCUMENT

    • NONE OF THE ABOVE

    Correct Answer
    A. NONE OF THE ABOVE
    Explanation
    During a mail merge, items that are typically merged include a main document (such as a letter or email template) and a data source (such as a mailing list or spreadsheet). In this case, the correct answer states "None of the above," indicating that none of the options provided accurately describe the items that are merged during a mail merge.

    Rate this question:

Quiz Review Timeline (Updated): May 3, 2024 +

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

  • Current Version
  • May 03, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 19, 2011
    Quiz Created by
    PCDAC
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.