Computer Literacy Final Exam Part 1
-
1. ENTER THE BELOW INFORMATION INTO AN EXCEL SPREADSHEET 2. TOTAL EACH OF THE COLUMNS IN APPROPRIATE CELL BELOW THE LAST ENTRY FOR EACH COLUMN (DO NOT USE THE AUTOSUM KEY). 3. IN CELL C9 ENTER THE FORMULA TO AVERAGE THE THREE TOTALS FROM CELLS B6, C6 & D6 4. CREATE A PIE CHART IN THE SAME SPREADSHEET USING THE DATA FROM A1 - E6 ONLY 5. SAVE THE SPREADSHEET AS FINAL IN YOUR MY DOCUMENTS FOLDER
-
.JPG "Computer Literacy Final Exam Part 1 - Quiz")
This final exam assesses essential computer literacy skills, focusing on tasks like changing font settings, using function keys, and navigating Excel. It tests practical knowledge crucial for effective computer use, making it relevant for learners aiming to enhance their technical proficiency.
Quiz Preview
- 2.
HOW DO YOU CHANGE THE FONT ON TEXT YOU HAVE ALREADY TYPED?
-
HIGHLIGHT THE TEXT AND CHANGE THE FONT SIZE
-
TYPE THE WORD 'BIGGER'
-
CHANGE THE FONT TYPE
Correct Answer
A. HIGHLIGHT THE TEXT AND CHANGE THE FONT SIZEExplanation
To change the font on text that has already been typed, you need to highlight the text and then change the font size. This can be done by selecting the text and using the formatting options to adjust the font size.Rate this question:
-
- 3.
PRESSING THE FUNCTION KEY 'F7' WILL DO WHAT?
-
CUT & PASTE
-
SPELL CHECK
-
MOVE TO CENTER
Correct Answer
A. SPELL CHECKExplanation
Pressing the function key 'F7' will perform a spell check.Rate this question:
-
- 4.
YOU CAN OPEN A DOCUMENT WITHOUT USING THE 'START' BUTTON.
-
True
-
False
Correct Answer
A. TrueExplanation
It is possible to open a document without using the 'Start' button. There are multiple ways to open a document, such as double-clicking on the document icon on the desktop, using a keyboard shortcut, or using the file explorer to navigate to the document and open it. The 'Start' button is just one of the options available to open a document, but it is not the only way.Rate this question:
-
- 5.
WHAT SECTIO OF THE INSERT TAB SHOWS THE WRAP TEXT BUTTON IN EXCEL
-
ALIGNMENT
-
CELLS
-
FONT
-
NONE OF THE ABOVE
Correct Answer
A. NONE OF THE ABOVEExplanation
The correct answer is NONE OF THE ABOVE because the Wrap Text button in Excel is not located in the Insert tab. It is actually located in the Home tab, under the Alignment section. This button allows users to wrap text within a cell, making it visible without adjusting the cell's width.Rate this question:
-
- 6.
YOU CANNOT ADD A LABEL TO YOUR CHART ONCE YOU HAVE DELETED IT
-
True
-
False
Correct Answer
A. FalseExplanation
The statement is false because it is possible to add a label to a chart even after it has been deleted. Deleting a label from a chart does not permanently remove the option to add a label in the future.Rate this question:
-
- 7.
THE AUTOSUM BUTTON IS ON THE _______________ TAB IN EXCEL
-
REVIEW
-
HOME
-
INSERT
Correct Answer
A. HOMEExplanation
The correct answer is HOME. In Excel, the Autosum button is located on the Home tab. This tab contains various commands and functions related to formatting, editing, and manipulating data in a worksheet. The Autosum button is specifically used to quickly calculate the sum of selected cells in a column or row.Rate this question:
-
- 8.
THE SIMPLEST WAY TO REARRANGE TEXT IN A DOCUMENT IS TO
-
CUT THE TEXT AND PASTE IT ON ANOTHER PAGE
-
CUT OR COPY AND PASTE
-
RETYPE THE TEXT
Correct Answer
A. CUT OR COPY AND PASTEExplanation
The simplest way to rearrange text in a document is to cut or copy the text and paste it onto another page. This allows for easy movement of text without having to retype it.Rate this question:
-
- 9.
CLIPART CAN BE INSERTED FROM THE INTERNET INTO WORD
-
True
-
False
Correct Answer
A. TrueExplanation
Clipart can indeed be inserted from the internet into Word. Clipart refers to pre-made images or graphics that can be used in documents or presentations. Microsoft Word provides the option to search and insert clipart directly from the internet using the "Online Pictures" feature. This allows users to access a wide range of clipart images available on the internet and easily insert them into their Word documents. Therefore, the statement "Clipart can be inserted from the internet into Word" is true.Rate this question:
-
- 10.
MOST PEOPLE USE THE INTERNET PRIMARILY TO
-
SKYPE
-
SHOP
-
EMAIL
-
FIND A DATE
Correct Answer
A. EMAILExplanation
Most people use the internet primarily to communicate via email. Email has become an essential tool for personal and professional communication, allowing individuals to send and receive messages, documents, and media files quickly and efficiently. It has replaced traditional mail as the preferred method of communication due to its convenience, speed, and cost-effectiveness. Additionally, email allows users to organize and store their messages, making it easier to retrieve and reference information when needed.Rate this question:
-
- 11.
The ' / ' In An Exel Formula Will
-
SPLIT
-
DIVIDE
-
CONNECT
Correct Answer
A. DIVIDEExplanation
The '/' symbol in an Excel formula is used to divide one value by another. It performs the mathematical operation of division, where the value before the '/' is divided by the value after the '/'.Rate this question:
-
- 12.
IN EXCEL IF I WANT TO NUMBER A ROW OF pHARSES I CAN HIGHLIGHT THE pHARSES AND CLICK THE _________________BUTTON ON THE TOOLBAR.
-
NEW
-
NUMBER
-
NAME
Correct Answer
A. NUMBERExplanation
To number a row of phrases in Excel, you can highlight the phrases and click the "NUMBER" button on the toolbar. This button is specifically designed to add numbers to selected cells or rows in Excel.Rate this question:
-
- 13.
YOU CAN OPEN A DOCUMENT WITHOUT USING THE 'START' BUTTON.
-
True
-
False
Correct Answer
A. TrueExplanation
It is possible to open a document without using the 'Start' button. There are multiple ways to open a document, such as double-clicking on the document icon, right-clicking on the document and selecting 'Open', or using the file explorer to navigate to the document and opening it directly. Therefore, the statement is true.Rate this question:
-
- 14.
EXCEL IS AN ELECTRONIC DATABASE
-
True
-
False
Correct Answer
A. TrueExplanation
Excel is an electronic database because it allows users to organize and store large amounts of data in a structured and efficient manner. It provides features such as tables, filters, and sorting options that make it easy to manage and retrieve information. Additionally, Excel offers various functions and formulas that enable users to perform calculations and analysis on the data. Overall, Excel serves as a powerful tool for data management and analysis, making it an electronic database.Rate this question:
-
- 15.
WHICH OF THE BELOW ARE ALL OPERATORS (MORE THAN ONE ANSWER)
-
*
-
-
-
)
-
/
Correct Answer(s)
A. *
A. -
A. /Explanation
The correct answer is *,-,/. These symbols are all operators used in mathematical operations. The asterisk (*) represents multiplication, the hyphen (-) represents subtraction, and the slash (/) represents division.Rate this question:
-
- 16.
IN WORD THERE ARE TWO PLACES TO ZOOM IN ON YOUR DOCUMENT; THEY ARE
-
ON THE HOME COMMAND TAB AND THE VIEW COMMAND TAB
-
ON THE VIEW COMMAND TAB AND THE BOTTOM RIGHT HAND OF THE WINDOW
-
ON THE HOME COMMAND TAB AND THE OFFICE BUTTON
Correct Answer
A. ON THE VIEW COMMAND TAB AND THE BOTTOM RIGHT HAND OF THE WINDOWExplanation
The correct answer is on the View command tab and the bottom right hand of the window. This means that there are two places where you can zoom in on your document: one is on the View command tab, which likely has options for zooming in and out, and the other is at the bottom right hand of the window, where there may be a zoom slider or buttons to adjust the zoom level. Both of these options provide the ability to zoom in on the document for better visibility.Rate this question:
-
- 17.
NAME THE WINDOW BELOW
-
PAGE AND OUTLINE
-
BOARDER AND SHADING
-
SHADING AND BOARDERING
-
NONE OF THE ABOVE
Correct Answer
A. BOARDER AND SHADINGExplanation
The window below is named "Boarder and Shading" because it likely refers to a feature or option in a software program or application that allows the user to add a border and shading to a selected area or object. This feature is commonly used in word processing programs or graphic design software to enhance the visual appearance of text or images.Rate this question:
-
- 18.
NAME THE WINDOW BELOW
-
GRAMMAR
-
SPELL CHECK WINDOW
-
SPELLING AND GRAMMAR
-
NONE OF THE ABOVE
Correct Answer
A. SPELLING AND GRAMMARExplanation
The correct answer is "SPELLING AND GRAMMAR". This window is used to check and correct any spelling and grammar errors in a document. It is a tool that helps ensure that the text is accurate and error-free.Rate this question:
-
- 19.
WHAT TAB IS THIS TOOL LOCATED
-
REVIEW
-
HOME
-
INSERT
-
NONE OF THE ABOVE
Correct Answer
A. INSERTExplanation
The correct answer is INSERT because the question is asking about the location of a specific tool, and the available options are different tabs. Since none of the other options (REVIEW, HOME, NONE OF THE ABOVE) indicate the location of the tool, INSERT is the most likely answer.Rate this question:
-
- 20.
THE OPTION ABOVE IS
-
SMARTART
-
STYLES TYPES
-
TEMPLATE
-
NONE OF THE ABOVE
Correct Answer
A. NONE OF THE ABOVEExplanation
The given question does not provide any specific context or information to determine the correct answer. Without any additional information, it is not possible to determine which option is the correct answer.Rate this question:
-
- 21.
WHEN POWERPOINT OPENS WHAT IS THE LAYOUT OF THE FIRST SLIDE THAT APPEARS
-
BLANK
-
TITLE
-
COMPARISON
-
TITLE AND CONTENT
Correct Answer
A. TITLEExplanation
When PowerPoint opens, the layout of the first slide that appears is a slide with a title only. This means that the slide will have a blank space for the title text, but there will be no additional content or text boxes on the slide.Rate this question:
-
- 22.
WHAT TAB MUST YOU BE ON TO CHANGE THE SIZE AND FONT
-
ANIMATION
-
INSERT
-
VIEW
-
HOME
Correct Answer
A. HOMEExplanation
To change the size and font of the text, you need to be on the "HOME" tab. This tab typically contains options for formatting and editing text, such as font style, size, and color. Other tabs like "ANIMATION," "INSERT," and "VIEW" may have different functions and options unrelated to text formatting.Rate this question:
-
- 23.
EVERY NEW BULLET REPRESENTS....
-
THE DEATH OF J. CUTLER
-
A NEW PARAGRAPH
-
A NEW IDEA OR THOUGHT
-
AN IMAGE
Correct Answer
A. A NEW IDEA OR THOUGHTExplanation
The correct answer is "A NEW IDEA OR THOUGHT." In this context, the statement suggests that each new bullet represents the introduction of a fresh idea or thought.Rate this question:
-
- 24.
WHEN MAKING A 'SUB' LINE - WHAT BUTTON MUST YOU CLICK TO GET THE BULLET TO MOVE OVER TO THE RIGHT?
-
ENTER KEY
-
DECREASE INDENT
-
TAB
-
INCREASE INDENT
Correct Answer
A. INCREASE INDENTExplanation
To move the bullet over to the right when making a 'sub' line, you must click the "INCREASE INDENT" button. This button is used to increase the indentation level of the text, pushing it further to the right.Rate this question:
-
- 25.
WHEN YOU WANT TO ANIMATE A PART OF YOUR TEXT YOU MUST CLICK ON THE ANIMATION TAB AND THEN CLICK?
-
INSERT
-
TRANSITION
-
VIEW
-
CUSTOM ANIMATION
Correct Answer
A. CUSTOM ANIMATIONExplanation
To animate a part of your text, you need to click on the Animation tab and then click on "Custom Animation". This option allows you to have more control over the animation effects and timing for your text. By selecting "Custom Animation", you can choose from a variety of animation options and customize them according to your preferences.Rate this question:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 19, 2011Quiz Created by
PCDAC
Back to top