MCQ Quiz: Microsoft Excel Exam!
24 Questions
| Total Attempts: 15324
Microsoft Excel is a spreadsheet application used for numerous various solutions. It has been a useful and successful tool on all different platforms as the industry standard as far as spreadsheets are concerned. Its initial release was in 1987. If you want to learn more about Microsoft Excel, this quiz might be helpful for you.
Questions and Answers
- 1.A ________________ consists of a grid made from columns and rows?
- A.
Cell
- B.
Labels
- C.
Spreadsheet
- D.
Formulas
- 2.What is not a basic part of a spreadsheet?
- A.
Formula
- B.
Cell
- C.
Row
- D.
Column
- 3.Which of the following data can be put inside a cell?
- A.
Row
- B.
Column
- C.
Constant
- 4.In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
- 5.In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
- 6._____________ are used to designate each column's location.
- 7.___________ are used to designate each row's location.
- 8.In a spreadsheet, the ___________ is defined as space where a specified row and column intersect.
- A.
Labels
- B.
Cell
- C.
Formulas
- D.
Numbers
- 9.
![Name this cell:
- ProProfs]( "Name this cell:")
Name this cell: - 10.
![In the spreadsheet below, provide an example of a label?
- ProProfs]( "In the spreadsheet below, provide an example of a label?")
In the spreadsheet below, provide an example of a label? - 11.Constants are entires that do not have a specified value.
- A.
True
- B.
False
- 12.
![In the spreadsheet below, provide an example of a constant:
- ProProfs]( "In the spreadsheet below, provide an example of a constant:")
In the spreadsheet below, provide an example of a constant: - 13.All formulas must begin with what?
- 14.____________ are entires that have equations that calculates the value to display.
- A.
Labels
- B.
Constants
- C.
Spreadsheet
- D.
Formulas
- 15.
![Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?
- ProProfs]( "Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make?")
Provide the formula for the following spreadsheet: If you work for 23 hours and make $5.36 an hour, how much do you make? - 16.The ___________ function takes all of the values in each of the specified cells and totals their values.
- 17.The _________ function adds all of the indicated cells together and divides by the total number of cells.
- 18.The two most widely used charts are the:
- 19.Name the three basic parts of a spreadsheet?
- 20.In a spreadsheet, each cell may have three types of data in them:
- 21.What is the symbol for multiplication?
- 22.What is the symbol for division?
- 23.What is the symbol for addition?
- 24.What is the symbol for subtraction?
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 62207 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 59827 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 44527 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top