Microsoft Excel - Quiz 1 Com254
20 Questions
| Total Attempts: 247
Quiz 1 for the Microsoft Excel Go! Series
Questions and Answers
- 1.A new ______________ opens when you start the Excel program.
- A.
Workbook
- B.
Document
- C.
Database
- D.
Presentation
- 2.A worksheet is also called a ___________________________.
- A.
Document
- B.
Spreadsheet
- C.
Database
- D.
Form
- 3.A pattern of uniformly spaced horizontal and vertical lines that are present when you open an Excel file are called _________________.
- A.
Cells
- B.
Ranges
- C.
Gridlines
- D.
Rows
- 4.The intersection of a column and a row is called a(n) ______________.
- A.
Cell
- B.
Range
- C.
Address
- D.
Value
- 5.The cell that is ready to accept data or be affected by the next Excel command is called the _____________ cell.
- A.
Open
- B.
Active
- C.
Empty
- D.
Available
- 6._____________________ consist of numbers, text, dates, or times of the day.
- A.
Cells
- B.
Formulas
- C.
Data
- D.
Functions
- 7.A(n) _____________ cell is a single cell created by combining two or more selected cells.
- A.
Combined
- B.
Merged
- C.
Active
- D.
Aligned
- 8._____________________ are text, page numbers, and graphics that display and print at the bottom of every page.
- A.
Footers
- B.
Titles
- C.
Headers
- D.
Elements
- 9.Use the _________ Text command to display long cell entries on more than one line within a cell.
- A.
Format
- B.
Wrap
- C.
Justify
- D.
Align
- 10.Reverse an action or a series of actions by using the _________ command.
- A.
Undo
- B.
Redo
- C.
Overtype
- D.
Reverse
- 11.Sheet tabs identify each __________ in a workbook.
- A.
Worksheet
- B.
File
- C.
Document
- D.
Location
- 12.When more than one worksheet of a workbook is selected they are:
- A.
Combined
- B.
Grouped
- C.
Totaled
- D.
Fixed
- 13.The __________ worksheet is where text and data will be entered.
- A.
Live
- B.
Open
- C.
Active
- D.
First
- 14.__________ enables you to extend a series of values into adjacent cells based on the value of other cells.
- A.
Auto Type
- B.
Auto Fill
- C.
Copying
- D.
Formatting
- 15.What is a temporary area maintained by the Windows operating system that stores data?
- A.
Recycle Bin
- B.
Clipboard
- C.
Storage
- D.
Drive
- 16.The __________ command inserts the most recent data stored in the Clipboard to a new cell or range of cells.
- A.
Move
- B.
Copy
- C.
Paste
- D.
Insert
- 17.The __________ range is the range of cells into which copied data is placed.
- A.
Destination
- B.
Source
- C.
Data
- D.
Adjacent
- 18.Grouped __________ enable you to format the same range of cells in all worksheets of the group simultaneously.
- A.
Ranges
- B.
Workbooks
- C.
Cells
- D.
Worksheets
- 19.__________ cell references refer to their fixed position in the worksheet and do not change when the formula is copied.
- A.
Relative
- B.
Absolute
- C.
Workbook
- D.
Worksheet
- 20.The Find and Replace feature searches the __________ in a worksheet – or in a selected range – for matches and then replaces each match with a replacement of your choice.
- A.
Columns
- B.
Rows
- C.
Cells
- D.
Selections
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: 73423 | Last updated: Mar 22, 2022
-
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: 62878 | Last updated: Mar 22, 2022
-
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: 46087 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top