Computer Applications Final Exam Practice Quiz

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 Scaluya
S
Scaluya
Community Contributor
Quizzes Created: 1 | Total Attempts: 522
| Attempts: 525
SettingsSettings
Please wait...
  • 1/100 Questions

    If you try to close a file before it has been saved, Excel will prompt you to save it.    

    • True
    • False
Please wait...
Computer Applications Final Exam Practice Quiz - Quiz
About This Quiz

Computer Applications  Semester 2  Final Exam - June 2013
Open book (Microsoft PowerPoint & Excel 2007)
This is a multiple-choice and true/false test. Please use your mouse to click the small option button preceding the best answer to each question. Then, use the scroll bar on the right side of your screen to scroll down to the next question. Repeat as needed until you have answered all questions.
Please review your selections before submitting. You may only submit your final exam answers once.

Quiz Preview

  • 2. 

    Font color can be applied to all the text in a selected cell or range or to selected words or characters in a cell.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Font color can be applied to all the text in a selected cell or range or to selected words or characters in a cell. This means that you can change the color of the entire text in a cell or only specific words or characters within that cell.

    Rate this question:

  • 3. 

    A template is a file that contains settings that are used as the basis for a new file you are creating.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A template is a file that contains pre-defined settings, formatting, and content that serve as a starting point for creating a new file. When you create a new file using a template, it automatically inherits the settings and content from the template, saving you time and effort in setting up the file from scratch. Therefore, the statement "A template is a file that contains settings that are used as the basis for a new file you are creating" is true.

    Rate this question:

  • 4. 

    The AutoCorrect feature automatically inserts proper capitalization at the beginning of sentences and in the names of days of the week.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The AutoCorrect feature automatically inserts proper capitalization at the beginning of sentences and in the names of days of the week. This means that if a user forgets to capitalize the first letter of a sentence or the days of the week, AutoCorrect will automatically correct it. Therefore, the statement "The AutoCorrect feature automatically inserts proper capitalization at the beginning of sentences and in the names of days of the week" is true.

    Rate this question:

  • 5. 

    Excel calculates the formula from left to right and performs the calculation in the following order: percent, exponentiation, multiplication and division, and addition and subtraction.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Excel follows the order of operations, also known as PEMDAS (parentheses, exponents, multiplication and division, addition and subtraction), when calculating formulas. This means that it will first perform any calculations involving percentages, then exponentiation, followed by multiplication and division, and finally addition and subtraction. Therefore, the given statement is true.

    Rate this question:

  • 6. 

    You can add cell references to a formula either by typing them directly or by selecting the cell with the mouse.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    You can add cell references to a formula either by typing them directly or by selecting the cell with the mouse. This means that when creating a formula, you have the option to manually type in the cell references or you can simply click on the desired cell to automatically insert its reference into the formula. This flexibility allows for easier and more accurate formula creation.

    Rate this question:

  • 7. 

    You can quickly align a range of cells by selecting the range and then using the command or button.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because you can indeed align a range of cells quickly by selecting the range and then using the command or button. By selecting the range of cells, you can easily apply alignment options such as left, right, center, top, bottom, and more. The command or button can be found in the formatting options or toolbar of the spreadsheet program you are using.

    Rate this question:

  • 8. 

    When you start to enter data in a cell, the mode shown in the status bar changes from Ready to Enter.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When you start entering data in a cell, the mode in the status bar changes from "Ready" to "Enter". This means that the software is now expecting input from the user and is ready to accept the data. The change in mode indicates that the cell is active and can receive the data being entered. Therefore, the statement "True" is the correct answer.

    Rate this question:

  • 9. 

    When you move a selection, it is removed or cut from the original location in the source and inserted at the intended destination

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When you move a selection, it means that you are physically relocating or cutting the selected item from its original position in the source. After removing it from the source, you then insert or place it at the desired destination. This action permanently removes the selection from its original location and transfers it to the new location. Therefore, the statement is true.

    Rate this question:

  • 10. 

    Excel files are called workbooks.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Excel files are called workbooks because in Excel, a workbook is a file that contains one or more worksheets. Each worksheet is a grid of cells where data can be entered and manipulated. Workbooks in Excel can contain multiple worksheets, allowing users to organize and analyze data in different ways within the same file. Therefore, it is correct to say that Excel files are called workbooks.

    Rate this question:

  • 11. 

    When closing a workbook, Excel saves the file with the cell selector in the same cell location it is in at the time it is saved.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When closing a workbook, Excel saves the file with the cell selector in the same cell location it is in at the time it is saved. This means that if the cell selector is in cell A1 when the workbook is closed, it will be saved in cell A1 when the file is reopened. This behavior ensures that the user can continue working from where they left off when they reopen the workbook.

    Rate this question:

  • 12. 

    Sans serif fonts do not have a flair at the base of each letter.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Sans serif fonts are characterized by their clean and simple design, without any decorative elements like flairs at the base of each letter. This is in contrast to serif fonts, which do have these flairs. Therefore, the statement that sans serif fonts do not have a flair at the base of each letter is true.

    Rate this question:

  • 13. 

    Pressing [Ctrl] + ‘ will display the formulas in cells instead of the formula’s result.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Pressing [Ctrl] + ' (apostrophe) in Excel will display the formulas in cells instead of the formula's result. This can be useful when you want to check or edit the formulas in a worksheet. It allows you to see the actual formulas used in each cell rather than the calculated results.

    Rate this question:

  • 14. 

    You can launch the Spell Checker by pressing the F7 key.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Pressing the F7 key launches the Spell Checker.

    Rate this question:

  • 15. 

    A selection consisting of two or more cells on a worksheet is a range

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A selection of two or more cells on a worksheet is considered a range because a range refers to a group of cells that are selected together. By selecting multiple cells, you can perform various operations on them simultaneously, such as formatting, entering data, or applying formulas. Ranges are commonly used in Excel to manipulate and analyze data efficiently. Therefore, the statement "A selection consisting of two or more cells on a worksheet is a range" is true.

    Rate this question:

  • 16. 

    The system Clipboard can hold up to 24 items.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The system Clipboard is a temporary storage area in a computer's memory where copied or cut items are stored. It allows users to copy multiple items and paste them later. The statement "The system Clipboard can hold up to 24 items" implies that the system Clipboard has a limit of 24 items that it can store at a time. Therefore, the correct answer is True.

    Rate this question:

  • 17. 

    The Spell Checker does not check spelling in text that result from formulas.    

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the Spell Checker feature in a program or software typically only checks the spelling of words in regular text and does not analyze or check the spelling of words that are generated from formulas or calculations. This is because formulas often involve numerical values, symbols, and functions that are not meant to be checked for spelling errors. Therefore, it is true that the Spell Checker does not check spelling in text that results from formulas.

    Rate this question:

  • 18. 

    An argument is the data that a function uses to perform a calculation.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because an argument is indeed the data that a function uses to perform a calculation. In programming, when we define a function, we can specify one or more parameters, which act as placeholders for the data that will be passed into the function when it is called. These values that are passed into the function are called arguments. The function can then use these arguments to perform the necessary calculations or operations. So, in summary, an argument is the data that a function uses to perform a calculation.

    Rate this question:

  • 19. 

    What are words that have opposite meanings called?  

    • Palindromes

    • Antonyms

    • Synonyms

    • Homophones

    Correct Answer
    A. Antonyms
    Explanation
    Antonyms are words that have opposite meanings. They are used to express contrast or opposition between two concepts. For example, "hot" and "cold" are antonyms because they have opposite meanings. Antonyms help to add depth and nuance to language and can be used to create emphasis or provide clarity in communication.

    Rate this question:

  • 20. 

    The keyboard shortcut for the Undo action is Alt+Z.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the keyboard shortcut for the Undo action is indeed Alt+Z. This means that if you want to undo your last action in a program or application, you can simply press the Alt key on your keyboard and then press the letter Z. This shortcut is commonly used in many software programs and is a quick and convenient way to undo a mistake or revert back to a previous state.

    Rate this question:

  • 21. 

    Press the Home key to quickly move to the beginning of a row.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Pressing the Home key on a keyboard is a shortcut that allows the user to quickly move the cursor to the beginning of a row in a document or spreadsheet. This can be useful when editing or formatting a large amount of text or data, as it saves time compared to manually scrolling or using other navigation methods. Therefore, the statement "Press the Home key to quickly move to the beginning of a row" is true.

    Rate this question:

  • 22. 

    The intersection of a row and a column is referred to as a(n):  

    • Cell

    • Pane

    • Chart

    • Area

    Correct Answer
    A. Cell
    Explanation
    The intersection of a row and a column is referred to as a cell. In a table or spreadsheet, each cell contains data or information. Cells are used to organize and display data in a structured manner.

    Rate this question:

  • 23. 

    Text boxes can be added using what tab?  

    • Home

    • Insert

    • Design

    • View

    Correct Answer
    A. Insert
    Explanation
    The correct answer is "Insert" because the "Insert" tab in most software applications is where users can find options to add various elements, such as text boxes, images, tables, shapes, and other objects, to their documents or presentations. This tab typically contains a range of tools and options related to inserting and formatting different types of content. Therefore, to add a text box, users would need to navigate to the "Insert" tab in the software application they are using.

    Rate this question:

  • 24. 

    What is the keyboard shortcut to open the Print dialog box?  

    • Alt + P

    • Ctrl + P

    • Shift + P

    • Shift + Ctrl + P

    Correct Answer
    A. Ctrl + P
    Explanation
    The correct answer is Ctrl + P. This keyboard shortcut is commonly used to open the Print dialog box in many applications. By pressing Ctrl + P, users can quickly access the print settings and options before printing a document. This shortcut helps to streamline the printing process and save time by avoiding the need to navigate through menus to find the print option.

    Rate this question:

  • 25. 

    To save an existing file with a new name, what command should you use?  

    • File Name

    • Save As

    • Versions

    • Save

    Correct Answer
    A. Save As
    Explanation
    To save an existing file with a new name, the command that should be used is "Save As". This command allows the user to create a copy of the file with a different name and location while still keeping the original file intact. It is useful when the user wants to create a new version of the file without overwriting the existing one.

    Rate this question:

  • 26. 

    You can automatically resize the column to fit the width of the column’s contents by ____ on the column boundary line.  

    • Clicking

    • Double-clicking

    • Right-clicking

    • Double right-clicking

    Correct Answer
    A. Double-clicking
    Explanation
    Double-clicking on the column boundary line allows you to automatically resize the column to fit the width of the column's contents. This action triggers the automatic resizing feature in the spreadsheet software, which adjusts the column width based on the length of the content in that column.

    Rate this question:

  • 27. 

    Which of the following functions is written in the correct syntax?  

    • NOW(today)

    • =SUM(A1:D1)

    • SUM(D2-A2)

    • =SUM(A1=B1)

    Correct Answer
    A. =SUM(A1:D1)
    Explanation
    The correct answer is =SUM(A1:D1). This function is written in the correct syntax because it starts with an equal sign followed by the function name (SUM), and then the range of cells (A1:D1) is enclosed in parentheses.

    Rate this question:

  • 28. 

    Which of the following is the keyboard shortcut for the Open command?  

    • Ctrl+P

    • Ctrl+Q

    • Ctrl+O

    • Ctrl+F

    Correct Answer
    A. Ctrl+O
    Explanation
    The keyboard shortcut for the Open command is Ctrl+O. This shortcut is commonly used in various applications and operating systems to quickly open a file or a document. By pressing Ctrl+O, users can access the file explorer or open dialog box to select the file they want to open. This shortcut is widely known and used, making it an efficient way to open files without having to navigate through menus or use the mouse.

    Rate this question:

  • 29. 

    The first slide in your presentation is what?  

    • Title slide

    • Buffer slide

    • Blank slide

    • Intro slide

    Correct Answer
    A. Title slide
    Explanation
    The first slide in a presentation is typically a title slide. This slide usually contains the title of the presentation, the name of the presenter, and possibly a subtitle or a brief description of the topic. It serves as an introduction to the audience and sets the tone for the rest of the presentation.

    Rate this question:

  • 30. 

    The Office Clipboard can hold up to how many items?  

    • 10

    • 12

    • 24

    • 256

    Correct Answer
    A. 24
    Explanation
    The Office Clipboard has the capacity to hold up to 24 items. This means that users can copy and store a maximum of 24 items on the clipboard at any given time. This allows for easy access and pasting of multiple items without having to constantly switch back and forth between different documents or applications.

    Rate this question:

  • 31. 

    This function returns the largest value in a set of values, and ignores logical values and text.  

    • NOW

    • MAX

    • SUM

    • ABS

    Correct Answer
    A. MAX
    Explanation
    The correct answer is MAX. This function is used to find the largest value in a set of values. It ignores logical values and text, so it only considers numerical values when determining the maximum value.

    Rate this question:

  • 32. 

    The date serial value of 1 corresponds to January 1, 0 A.D.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The date serial value of 1 does not correspond to January 1, 0 A.D. In most date systems, the year 0 does not exist, and the year 1 follows directly after 1 B.C. So, the date serial value of 1 would typically correspond to January 1, 1 A.D. Therefore, the statement is false.

    Rate this question:

  • 33. 

    This bar displays entries as they are made and edited in the Excel workbook window.  

    • Formula

    • Format

    • Standard

    • Title

    Correct Answer
    A. Formula
    Explanation
    The bar that displays entries as they are made and edited in the Excel workbook window is called the Formula bar. This bar allows users to input and edit formulas and functions directly into cells, providing a convenient way to view and manipulate data in Excel.

    Rate this question:

  • 34. 

    Which of the following is not one of the four steps in workbook development?  

    • Comparing

    • Testing

    • Formatting

    • Editing

    Correct Answer
    A. Comparing
    Explanation
    Comparing is not one of the four steps in workbook development. Workbook development typically involves steps such as testing, formatting, editing, and other similar tasks. Comparing, on the other hand, is not a step involved in the development process.

    Rate this question:

  • 35. 

    When you insert a graphic, this is automatically displayed.  

    • Picture Tools Format tab

    • Mini toolbar

    • Clip organizer

    • Source program

    Correct Answer
    A. Picture Tools Format tab
    Explanation
    When you insert a graphic, the Picture Tools Format tab is automatically displayed. This tab contains various formatting options and tools that allow you to edit and customize the inserted graphic. It provides options for adjusting the size, position, color, borders, and effects of the graphic. Additionally, it offers access to advanced features such as cropping, rotating, and applying artistic effects to the image. The Picture Tools Format tab is designed to make it easy for users to make visual enhancements to their graphics without the need for external editing programs.

    Rate this question:

  • 36. 

    It is impossible for cell B1 and B2 to have different widths.  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement says that it is impossible for cell B1 and B2 to have different widths. This means that the widths of B1 and B2 must be the same. Therefore, the correct answer is False, indicating that it is possible for cell B1 and B2 to have different widths.

    Rate this question:

  • 37. 

    Which of the following would you use to hold words you commonly use but that are not included in the main dictionary?

    • User dictionary

    • Custom dictionary

    • Exclude list

    • Personal dictionary

    Correct Answer
    A. Custom dictionary
    Explanation
    A custom dictionary is used to hold words that are commonly used by an individual but are not included in the main dictionary. This allows the user to add their own specific words or terms to the dictionary, ensuring that they are recognized and not flagged as misspelled. This feature is particularly useful for professionals or individuals who frequently use industry-specific jargon or technical terms that may not be recognized by the main dictionary.

    Rate this question:

  • 38. 

    A text entry that is larger than the column width will be fully displayed only if the cells to the left are blank.    

    • True

    • False

    Correct Answer
    A. False
    Explanation
    If a text entry is larger than the column width, it will not be fully displayed even if the cells to the left are blank. The text will be cut off and only a portion of it will be visible in the cell.

    Rate this question:

  • 39. 

    Which of the following is not a valid character for use in a number entry?      

    • 5

    • +

    • #

    • %

    Correct Answer
    A. #
    Explanation
    The character "#" is not a valid character for use in a number entry.

    Rate this question:

  • 40. 

    What term is used to describe the settings that come with the software?  

    • Preset

    • Default

    • Factory

    • Template

    Correct Answer
    A. Default
    Explanation
    The term "default" is used to describe the settings that come with the software. These settings are pre-determined by the software developer and are applied automatically unless the user chooses to customize them. The default settings are often the most commonly used or recommended settings for the software, providing a starting point for the user.

    Rate this question:

  • 41. 

    Row and column _____ are entries that are used to create the structure of the worksheet and describe other worksheet entries

    • Headings

    • Labels

    • Markers

    • Selectors

    Correct Answer
    A. Headings
    Explanation
    Headings are entries that are used to create the structure of the worksheet and describe other worksheet entries. They are typically used to label and categorize data in rows and columns, making it easier to navigate and understand the content of the worksheet. Headings provide a clear organization and hierarchy to the data, allowing users to quickly locate specific information within the worksheet.

    Rate this question:

  • 42. 

    In order to select more than one slide at a time in Slide Sorter view, hold down this key and select

    • Alt

    • Ctrl

    • Home

    • Insert

    Correct Answer
    A. Ctrl
    Explanation
    To select more than one slide at a time in Slide Sorter view, you need to hold down the Ctrl key and then select the desired slides. The Ctrl key allows you to make multiple selections by clicking on each slide individually. This is a common keyboard shortcut used in many applications for selecting multiple items simultaneously.

    Rate this question:

  • 43. 

    Which of the following is NOT a location where the Copy command can be found?  

    • Context Menu

    • Office Button

    • Clipboard Group

    • Home Tab

    Correct Answer
    A. Office Button
    Explanation
    The Copy command can be found in the Context Menu, Clipboard Group, and Home Tab. The Office Button is not a location where the Copy command can be found.

    Rate this question:

  • 44. 

    Which Excel tool would you use if you were seeking a word that meant “hungry” but sounded more sophisticated?

    • Dictionary

    • Translation

    • Encyclopedia

    • Thesaurus

    Correct Answer
    A. Thesaurus
    Explanation
    A thesaurus is a tool that provides synonyms and antonyms for words. In this case, if someone is looking for a word that means "hungry" but sounds more sophisticated, they would use a thesaurus to find a synonym that fits their criteria.

    Rate this question:

  • 45. 

    Cells are referenced by column number and row letter.  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Cells are actually referenced by column letter and row number, not column number and row letter. In spreadsheet applications like Microsoft Excel, each cell is identified by a combination of a letter representing the column and a number representing the row. For example, cell A1 refers to the first cell in the first column, while cell B2 refers to the second cell in the second column. Therefore, the statement given in the question is incorrect.

    Rate this question:

  • 46. 

    Which of the following text entries would not be corrected by the AutoCorrect feature?  

    • THE

    • Becausethe

    • 600,000

    • Tuesday

    Correct Answer
    A. 600,000
    Explanation
    The AutoCorrect feature corrects common spelling errors and capitalization mistakes. In this case, "600,000" does not require any correction as it is already written correctly. The AutoCorrect feature does not make changes to correctly spelled words or numbers.

    Rate this question:

  • 47. 

    This task pane is used to assign animation and sound to all objects on a slide and to determine the order in which they are displayed.  

    • Animation Style

    • Custom Animation

    • Format Animation

    • Present Animation

    Correct Answer
    A. Custom Animation
    Explanation
    The correct answer is Custom Animation. Custom Animation is a task pane in PowerPoint that allows users to assign animation and sound to objects on a slide. It also enables users to control the order in which the objects are displayed. This feature is useful for creating dynamic and engaging presentations by adding movement and effects to the slide elements.

    Rate this question:

  • 48. 

    Enhancing the appearance of the slide to make it more readable or attractive is called:  

    • Aligning

    • Fonting

    • Formatting

    • Displaying

    Correct Answer
    A. Formatting
    Explanation
    Formatting refers to the process of enhancing the appearance of a slide to make it more readable or attractive. This can include adjusting the font style, size, and color, as well as aligning text and objects on the slide. By formatting the slide, it becomes visually appealing and easier for the audience to understand the information being presented.

    Rate this question:

  • 49. 

    The Save command is used to save a file with a new file name or to a new location.  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The Save command is not used to save a file with a new file name or to a new location. Instead, it is used to save changes made to an existing file. If you want to save a file with a new name or to a different location, you would typically use the Save As command. Therefore, the correct answer is False.

    Rate this question:

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

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 02, 2013
    Quiz Created by
    Scaluya
Back to Top Back to top
Advertisement