Microsoft Excel Test II
.jpg "Microsoft Excel Test II - Quiz")
Questions and Answers
- 1.
Microsoft Excel is an ______________ spreadsheet
- A.
Easy
- B.
Electronic
- C.
Empty
Correct Answer
B. ElectronicExplanation
Microsoft Excel is an electronic spreadsheet. This means that it is a computerized tool used for organizing, analyzing, and manipulating numerical data. Excel allows users to create tables, perform calculations, and generate graphs and charts. It is widely used in various industries and professions for tasks such as budgeting, financial analysis, data tracking, and project management. As an electronic spreadsheet, Excel offers a range of features and functions that make it a powerful tool for data management and analysis.Rate this question:
-
- 2.
You Can Only Edit Data In The Formula Bar
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement "You can only edit data in the formula bar" is false. In many software applications, including spreadsheet programs like Microsoft Excel, users have the ability to edit data not only in the formula bar but also directly in the cells. This allows for easier and more convenient data manipulation and editing. Therefore, the correct answer is false.Rate this question:
-
- 3.
The Only Way To Get The Sum of A Set of Numbers Is To Use The Button Below
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
This statement is false because there are multiple ways to get the sum of a set of numbers. One can manually add up the numbers using pen and paper or a calculator, or they can use a computer program or online tool to calculate the sum. The button mentioned in the statement is not the only way to obtain the sum of a set of numbers.Rate this question:
-
- 4.
What Tab Is The Wrap Text Button Found?
- A.
Home
- B.
House
- C.
Review
Correct Answer
A. HomeExplanation
The Wrap Text button is found on the Home tab.Rate this question:
-
- 5.
You Can Spell Check In Excel By Doing The Following
- A.
Clicking F7 Only
- B.
Selecting Spelling On The Reference Tab
- C.
Selecting Spelling On The Review Tab or Clicking F7
- D.
All of The Above
Correct Answer
C. Selecting Spelling On The Review Tab or Clicking F7Explanation
The correct answer is "Selecting Spelling On The Review Tab or Clicking F7". This is because in Excel, you can perform spell check by either selecting the "Spelling" option on the "Review" tab or by simply pressing the F7 key. Both methods allow you to check the spelling of your data and make necessary corrections.Rate this question:
-
- 6.
To Save A Worksheet In Excel You Must Click On The _______ _______ and then click ______.
Correct Answer
office button save
Office Button SaveExplanation
To save a worksheet in Excel, you need to click on the "Office Button" (located at the top left corner of the Excel window), then select the "Save" option from the drop-down menu that appears. The "Office Button" is represented by the Microsoft Office logo. By selecting "Save", you can save the changes made to the worksheet.Rate this question:
- 7.
What Is This Area Called
- A.
Title Bar
- B.
Menu Bar
- C.
Ribbon Bar
Correct Answer
C. Ribbon BarExplanation
The correct answer is Ribbon Bar because it is the area in a software application, typically located at the top of the window, that contains a collection of tabs and buttons. The Ribbon Bar is used to organize and display various commands and options related to the specific application or task. It provides easy access to frequently used features and functions, improving user efficiency and productivity.Rate this question:
-
- 8.
OPEN AN EXCEL SPREADSHEET 1. Enter 25 in A1 2. Enter 30 in A2 3. Enter The Formula For The Sum (DO NOT USE THE AUTOSUM)
- 9.
ON THE SAME SPREADSHEET 1. Enter 5 in B1 2. Enter 6 in B2 3. Enter The Formula To DIVIDE A1 By B1 In Cell C1 4. Enter The Formula To DIVIDE A2 By B2 In Cell C2
- 10.
'B10' Is Indicated In The ________ Box Area
- A.
Number
- B.
Nancy
- C.
Name
Correct Answer
C. NameExplanation
The correct answer is "Name" because the question is asking where "B10" is indicated. Since "B10" is a combination of a letter and a number, it is most likely referring to a specific location or identifier. Out of the given options, "Name" is the most logical choice as it is common to label or indicate specific names in a designated box area.Rate this question:
-
- 11.
ON THE SAME SPREADSHEET 1. Enter 10 In A6 2. Enter 5 In A7 3. Enter The Formula To Subtract A7 From A6 In Cell A8
- 12.
ON THE SAME SPREADSHEET 1. Enter 2 In B6 2. Enter 5 In B7 3. Enter The Formula To Multiply A6 By B6 In Cell C6 4. Enter The Formula To Multiply A7 By B7 In Cell C7
- 13.
1. In Cell A10 Type The Below Statement: In Word 2007 I Can Create A Document. I Can Use The Spell Check F7 Functon Key To Check My Spelling. In Excell 2007 I Can Create A Spreadsheet To Track Numberic or Alpha Text Data. I Can Also Calculate Numbers. 2. Use The Wrap Text Button To Format The Text You Just Typed. 3. Center The Text 4. Save As Week 3 Test II 5. Print The Spreadsheet
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 23, 2011Quiz Created by
PCDAC
Back to top