Computer Literacy Final Exam Part II
-
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
-
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.
.webp "Computer Literacy Final Exam Part II - Quiz")
Quiz Preview
- 2.
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 ABOVEExplanation
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:
-
- 3.
ONCE YOU HIDE A ROW IT REMAINS HIDDEN AS LONG AS THE WORKBOOK IS ACTIVE
-
True
-
False
Correct Answer
A. FalseExplanation
Once you hide a row in a workbook, it remains hidden even if the workbook is active.Rate this question:
-
- 4.
THE NAME BOX SHOWS YOU THE CONTENT OF THE CELL
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 5.
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 COLUMNSExplanation
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:
-
- 6.
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 BORDERExplanation
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:
-
- 7.
WHEN YOU PRESS 'ENTER' IN EXCEL IT WILL MOVE ONE COLUMN TO THE LEFT
-
True
-
False
Correct Answer
A. FalseExplanation
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.
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:
-
- 9.
'CTRL B' IS A SHORTCUT FOR
-
ADDING A BORDER
-
GOING BACKWARDS
-
BOLDING TEXT
-
NONE OF THE ABOVE
Correct Answer
A. BOLDING TEXTExplanation
'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:
-
- 10.
YOU CANNOT EDIT DATA ONCE YOU HAVE EXITED THE CELL YOU ENTERED IT IN
-
True
-
False
Correct Answer
A. FalseExplanation
The correct answer is False. This means that you can edit data even after exiting the cell you entered it in.Rate this question:
-
- 11.
MAIL MERGE ALLOWS YOU TO SEND THE SAME LETTER TO THE SAME PERSON
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 12.
A MAIL MERGE LIST CAN CONTAIN MULTIPLE ADDRESSES BUT NOT MULTIPLE RECORDS (PEOPLE)
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 13.
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. TrueExplanation
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:
-
- 14.
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. PLACEHOLDERSExplanation
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:
-
- 15.
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 ABOVEExplanation
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:
-
- 16.
MAIL MERGE MERGES A DOCUMENT WITH A MAILING LIST
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 17.
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 FILEExplanation
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:
-
- 18.
A POWERPOINT PRESENTATION IS MADE UP OF A SERIES OF
-
COOPER'S EYE GLASS LENS
-
SLIDES
-
LAYOUTS
-
PICTURES
Correct Answer
A. SLIDESExplanation
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:
-
- 19.
IN EXCEL 'EURO' IS A
-
FORMULA
-
CELL NAME
-
DATA TYPE
-
NONE OF THE ABOVE
Correct Answer
A. DATA TYPEExplanation
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:
-
- 20.
WHICH MICROSOFT OFFICE PROGRAMS/SOFTWARES HAVE THE RIBBON
-
WORD
-
EXCEL
-
ACCESS
-
POWERPOINT
-
ALL OF THE ABOVE
Correct Answer
A. ALL OF THE ABOVEExplanation
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:
-
- 21.
IN MSWORD WHICH TOOLBAR DO I USE TO INSERT A HEADER?
-
MAILINGS
-
VIEW
-
HOME
-
NONE OF THE ABOVE
Correct Answer
A. NONE OF THE ABOVEExplanation
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:
-
- 22.
YOU CAN INSERT A HEADER IN MSWORD BUY USING THE 'HEADER' BUTTON ON THE _______________ TAB (one word)
Correct Answer
INSERT
insert
InsertExplanation
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:
- 23.
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 ENTERExplanation
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:
-
- 24.
EXCEL HAS A LIMITED AMOUNT OF DATA THAT CAN BE ORGANIZED IN A SPREADSHEET (think carefully)
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 25.
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 DATAExplanation
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:
-
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, 2024Quiz Edited by
ProProfs Editorial Team -
Sep 19, 2011Quiz Created by
PCDAC
Back to top