Computer Applications Final Exam Practice 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.
Questions and Answers
- 1.
The name box displays entries as they are made and edited in the workbook window.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The name box does not display entries as they are made and edited in the workbook window. The name box is used to enter or select a specific cell or range of cells in the worksheet. It is not a tool for displaying entries or edits in real-time.Rate this question:
-
- 2.
Excel files are called workbooks.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 3.
A template is a file that contains settings that are used as the basis for a new file you are creating.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
Cells are referenced by column number and row letter.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 5.
Press the Home key to quickly move to the beginning of a row.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 6.
The four steps to developing a worksheet are: Enter, Edit, Test, and Format.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false. The four steps to developing a worksheet are: Enter, Edit, Calculate, and Format.Rate this question:
-
- 7.
When you start to enter data in a cell, the mode shown in the status bar changes from Ready to Enter.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 8.
The AutoCorrect feature automatically inserts proper capitalization at the beginning of sentences and in the names of days of the week.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 9.
A text entry that is larger than the column width will be fully displayed only if the cells to the left are blank.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 10.
The Save command is used to save a file with a new file name or to a new location.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 11.
If you try to close a file before it has been saved, Excel will prompt you to save it.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
If you try to close a file before it has been saved in Excel, the program will prompt you to save it. This is because Excel wants to ensure that any changes made to the file are not lost and gives you the opportunity to save the file before closing it.Rate this question:
-
- 12.
The Spell Checker feature works by comparing each word to a dictionary of words, called the custom dictionary, that is supplied with the program.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The explanation for the given answer "False" is that the Spell Checker feature does not compare each word to a custom dictionary of words supplied with the program. Instead, it compares each word to a built-in dictionary or a database of words to check for spelling errors. The custom dictionary is used to add or remove words from the spell check process, but it is not the main source of comparison for the spell checking feature.Rate this question:
-
- 13.
The Spell Checker does not check spelling in text that result from formulas.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 14.
You can launch the Spell Checker by pressing the F7 key.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Pressing the F7 key launches the Spell Checker.Rate this question:
-
- 15.
When you move a selection, it is removed or cut from the original location in the source and inserted at the intended destination
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 16.
The system Clipboard can hold up to 24 items.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
A selection consisting of two or more cells on a worksheet is a range
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 18.
When you copy by dragging the fill handle, the mini toolbar appears
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When you copy by dragging the fill handle, the mini toolbar does not appear.Rate this question:
-
- 19.
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 20.
An absolute reference is a cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
An absolute reference is a cell or range reference in a formula that does not change when the formula is copied to other cells. It is indicated by the use of a dollar sign ($) before the column and/or row reference. This allows the formula to always refer to the same cell or range, regardless of its position in the worksheet. Therefore, the given statement is false.Rate this question:
-
- 21.
An argument is the data that a function uses to perform a calculation.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 22.
The rules you follow when writing a formula are referred to as the structure.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is incorrect. The rules followed when writing a formula are referred to as the syntax, not the structure. The structure refers to the organization and arrangement of the formula's components.Rate this question:
-
- 23.
You can add cell references to a formula either by typing them directly or by selecting the cell with the mouse.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 24.
When a number in a referenced cell in a formula changes, Excel automatically recalculates all formulas in the worksheet.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Excel does not automatically recalculate all formulas in the worksheet when a number in a referenced cell changes. By default, Excel only recalculates the formula that contains the changed cell and any other formulas that depend on it. This is known as "automatic calculation" in Excel. If you want Excel to recalculate all formulas in the worksheet, you would need to manually initiate a recalculation or change the calculation settings to "manual".Rate this question:
-
- 25.
Grouping settings allow you to change the horizontal and vertical placement as well as the orientation of an entry in a cell.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Grouping settings do not allow you to change the horizontal and vertical placement or the orientation of an entry in a cell. Grouping settings are used to organize and manage data by creating groups or categories. They are typically used in features like pivot tables or data grouping in spreadsheets, where you can group data based on specific criteria. Changing the horizontal and vertical placement or the orientation of an entry in a cell would require formatting or alignment settings, not grouping settings. Therefore, the correct answer is False.Rate this question:
-
- 26.
You can quickly align a range of cells by selecting the range and then using the command or button.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 27.
It is impossible for cell B1 and B2 to have different widths.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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:
-
- 28.
Sans serif fonts do not have a flair at the base of each letter.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 29.
The keyboard shortcut for the Undo action is Alt+Z.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 30.
The default number format setting in a worksheet is Number.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The default number format setting in a worksheet is not "Number". The default number format setting is "General", which means that numbers will be displayed as they are entered without any specific formatting.Rate this question:
-
- 31.
Font color can be applied to all the text in a selected cell or range or to selected words or characters in a cell.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 32.
The date serial value of 1 corresponds to January 1, 0 A.D.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
The default date format is based on the settings in Office.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false. The default date format in Office is not based on the settings in Office. The default date format is actually based on the regional settings in the operating system of the computer. So, the date format in Office will be determined by the date format set in the computer's operating system.Rate this question:
-
- 34.
Pressing [Ctrl] + ‘ will display the formulas in cells instead of the formula’s result.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 35.
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 36.
This tool has tabs that provide access to the commands and features of Excel.
- A.
Menu bar
- B.
Title bar
- C.
Ribbon
- D.
Formula bar
Correct Answer
C. RibbonExplanation
The correct answer is "Ribbon" because the ribbon in Excel is a graphical control element that contains tabs, groups, and commands. It provides access to various commands and features in Excel, making it easier for users to navigate and use the software. The ribbon is located at the top of the Excel window and is organized into tabs, each containing related groups of commands. Users can click on the tabs to access different sets of commands and features, making it a convenient tool for working with Excel.Rate this question:
-
- 37.
This bar displays entries as they are made and edited in the Excel workbook window.
- A.
Formula
- B.
Format
- C.
Standard
- D.
Title
Correct Answer
A. FormulaExplanation
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:
-
- 38.
The Name Box provides information about the:
- A.
File name.
- B.
Title Bar.
- C.
Font name.
- D.
Selected area.
Correct Answer
D. Selected area.Explanation
The Name Box in this context refers to a feature in a software or application that provides information about the selected area. It allows users to see the name or reference of the currently selected cell or range of cells in a spreadsheet or worksheet. This can be useful for navigating and managing data in a large document. It is not related to file names, the title bar, or font names.Rate this question:
-
- 39.
What term is used to describe the settings that come with the software?
- A.
Preset
- B.
Default
- C.
Factory
- D.
Template
Correct Answer
B. DefaultExplanation
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:
-
- 40.
The intersection of a row and a column is referred to as a(n):
- A.
Cell
- B.
Pane
- C.
Chart
- D.
Area
Correct Answer
A. CellExplanation
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:
-
- 41.
In Excel, this surrounds an active cell.
- A.
Cell rim
- B.
Cell selector
- C.
Cell border
- D.
Cell outline
Correct Answer
B. Cell selectorExplanation
The cell selector in Excel is the small black border that surrounds an active cell. It indicates which cell is currently selected and ready for editing or formatting. This border helps users easily identify and manipulate the active cell within a worksheet.Rate this question:
-
- 42.
If the active cell is not named, the Name Box displays what?
- A.
Formula
- B.
“Unknown”
- C.
Cell reference
- D.
Output
Correct Answer
C. Cell referenceExplanation
The Name Box displays the cell reference when the active cell is not named. This allows the user to easily identify the location of the active cell within the spreadsheet.Rate this question:
-
- 43.
Which of the following is not one of the four steps in workbook development?
- A.
Comparing
- B.
Testing
- C.
Formatting
- D.
Editing
Correct Answer
A. ComparingExplanation
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:
-
- 44.
Which of the following is not a valid character for use in a number entry?
- A.
5
- B.
+
- C.
#
- D.
%
Correct Answer
C. #Explanation
The character "#" is not a valid character for use in a number entry.Rate this question:
-
- 45.
Row and column _____ are entries that are used to create the structure of the worksheet and describe other worksheet entries
- A.
Headings
- B.
Labels
- C.
Markers
- D.
Selectors
Correct Answer
A. HeadingsExplanation
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:
-
- 46.
Which of the following text entries would not be corrected by the AutoCorrect feature?
- A.
THE
- B.
Becausethe
- C.
600,000
- D.
Tuesday
Correct Answer
C. 600,000Explanation
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.
By default, a column is wide enough to display about how many characters?
- A.
4
- B.
6
- C.
8
- D.
10
Correct Answer
C. 8Explanation
By default, a column is wide enough to display about 8 characters.Rate this question:
-
- 48.
You can automatically resize the column to fit the width of the column’s contents by ____ on the column boundary line.
- A.
Clicking
- B.
Double-clicking
- C.
Right-clicking
- D.
Double right-clicking
Correct Answer
B. Double-clickingExplanation
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:
-
- 49.
By default, Excel’s AutoRecover feature saves the open workbook every ____ minutes.
- A.
2
- B.
5
- C.
10
- D.
30
Correct Answer
C. 10Explanation
Excel's AutoRecover feature automatically saves the open workbook at regular intervals to prevent data loss in case of unexpected shutdown or crash. By default, the AutoRecover feature saves the workbook every 10 minutes. This ensures that any recent changes made to the workbook are saved and can be recovered in the event of a disruption.Rate this question:
-
- 50.
Excel workbooks have what file extension?
- A.
.doc
- B.
.xlt
- C.
.xlw
- D.
.xlsx
Correct Answer
C. .xlwExplanation
Excel workbooks have the file extension .xlw. The file extension is a way to identify the type of file and associate it with a specific program. In the case of Excel, the .xlw extension is used to indicate that the file is a workbook created in Excel. This allows the operating system and other software to recognize and open the file correctly. Other file extensions mentioned in the options, such as .doc and .xlsx, are not used for Excel workbooks.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 02, 2013Quiz Created by
Scaluya
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top