Excel Quiz Level 1

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Missioncommunity
M
Missioncommunity
Community Contributor
Quizzes Created: 1 | Total Attempts: 445
Questions: 20 | Attempts: 446

Settings

Mission Community Excel Quiz Level 1

• 1.

Where is the cell A1 located?

• A.

• B.

• C.

• D.

C. Top left corner of spreadsheet
Explanation
Cell A1 is located in the top left corner of a spreadsheet. In spreadsheet software like Microsoft Excel or Google Sheets, cells are organized in a grid-like structure with columns labeled alphabetically and rows labeled numerically. The cell reference "A1" refers to the intersection of the first column (A) and the first row (1), which is located at the top left corner of the spreadsheet.

Rate this question:

• 2.

You can move sheets around and change the names

• A.

True

• B.

False

A. True
Explanation
This statement is true because in most spreadsheet software, such as Microsoft Excel or Google Sheets, users have the ability to rearrange the order of sheets within a workbook by dragging and dropping them into different positions. Additionally, users can also change the names of the sheets to better organize and label their data. Therefore, the given statement is correct.

Rate this question:

• 3.

You can only have three sheets per spreadsheet and you cannot add any

• A.

True

• B.

False

B. False
Explanation
The given statement states that you can only have three sheets per spreadsheet and you cannot add any. However, this statement is incorrect. In most spreadsheet software, such as Microsoft Excel or Google Sheets, you can have multiple sheets within a single spreadsheet and you can add or delete sheets as needed. Therefore, the correct answer is False.

Rate this question:

• 4.

When you copy data, what must you do in order to put it somewhere else?

• A.

Move it

• B.

Cut it

• C.

Edit it

• D.

Paste it

D. Paste it
Explanation
When you copy data, you need to paste it in order to put it somewhere else. Pasting allows you to transfer the copied data from the clipboard to a different location, such as another document or folder. This action completes the process of moving the data to a new location.

Rate this question:

• 5.

How does data look when it is selected?

• A.

It is outlined in red

• B.

It is highlighted in blue

• C.

It is written in red

• D.

It is highlighted in red

B. It is highlighted in blue
Explanation
When data is selected, it is highlighted in blue. This visual indication helps to distinguish the selected data from the rest of the content on the screen. The blue highlighting makes it easier for the user to identify and manipulate the selected data.

Rate this question:

• 6.

In order to move data, you drag and drop data from one place to another.

• A.

True

• B.

False

A. True
Explanation
Dragging and dropping data is a common method used to move data from one location to another. This action involves clicking and holding on the data, dragging it to the desired location, and then releasing the mouse button to drop the data in the new location. This intuitive and user-friendly method is widely used in various computer applications and operating systems to move files, folders, and other types of data.

Rate this question:

• 7.

What is the second way to move data?

• A.

Paste and Move

• B.

Cut and Paste

• C.

Select and Hold

• D.

Copy and Paste

D. Copy and Paste
Explanation
The second way to move data is by using the "Copy and Paste" function. This involves selecting the desired data, making a copy of it, and then pasting it into the desired location. Unlike the "Cut and Paste" function, which moves the data from its original location, "Copy and Paste" creates a duplicate of the data while leaving the original intact. This allows for data to be easily duplicated and transferred to different locations within a document or between different documents.

Rate this question:

• 8.

What does the Undo button on the Tool Bar look like?

• A.

Scissors

• B.

A blue arrow pointing backwards to the left

• C.

A folder with an arrow

• D.

A question Mark

B. A blue arrow pointing backwards to the left
Explanation
The correct answer is a blue arrow pointing backwards to the left. The Undo button on the Tool Bar is typically represented by a blue arrow pointing backwards to the left. This symbol is commonly used to indicate the action of undoing or reversing a previous action.

Rate this question:

• 9.

When you cut data using the cut command, does the data cease to exist at the last location?

• A.

Yes

• B.

No

A. Yes
Explanation
When you cut data using the cut command, it does not cease to exist at the last location. The cut command is used to extract specific columns or fields from a file or input stream. It does not delete or remove the data from its original location. The data that is cut is simply copied to the desired location, while the original data remains intact.

Rate this question:

• 10.

When you select data and click Cut in the Edit drop-down menu, what happens to the data?

• A.

A blue box surrounds the data

• B.

A scrolling marquis surrounds the data

• C.

A red box surrounds the data

• D.

The data is highlighted in blue

B. A scrolling marquis surrounds the data
Explanation
When you select data and click Cut in the Edit drop-down menu, a scrolling marquis surrounds the data. This indicates that the data has been selected and is ready to be moved or relocated to another location. The scrolling marquis visually represents the selected data and helps the user identify the specific portion of data that has been cut.

Rate this question:

• 11.

Which of the following is an advantage of a series?

• A.

If you type in a number such as 1, a series will continue counting up as far as you want.

• B.

If you type in any name, the next name you want will automatically appear.

• C.

It allows you to paste the month January repeatedly without typing it in again.

• D.

If you type a month in one cell, a series will automatically put the rest of the months in for you.

D. If you type a month in one cell, a series will automatically put the rest of the months in for you.
Explanation
An advantage of a series is that if you type a month in one cell, a series will automatically put the rest of the months in for you. This saves time and effort as you don't have to manually type in each month.

Rate this question:

• 12.

The single most important reason to save is:

• A.

• B.

To be able to email

• C.

To be able to print.

• D.

So you remember what you typed last

Explanation
Saving your work is the single most important reason because it ensures that you don't lose any progress or important information. By saving your work, you can easily access it later and continue working on it. It also protects your work from potential computer crashes or power outages. Additionally, saving your work allows you to make backups and share it with others through email or printing. Lastly, saving your work helps you remember what you typed last, making it easier to track changes or refer back to previous versions.

Rate this question:

• 13.

In order to change the way the data is displayed in a chart, you must select the cell and click:

• A.

Format Cells

• B.

Font Size

• C.

Format Date

• D.

Format Type

A. Format Cells
Explanation
To change the way the data is displayed in a chart, you need to select the cell and click on "Format Cells". This option allows you to customize the appearance of the cell, such as changing the number format, applying font styles, adjusting alignment, and more. By selecting "Format Cells", you can modify the data's presentation in the chart according to your preferences and requirements.

Rate this question:

• 14.

You can select many cells at a time in order to format them.

• A.

True

• B.

False

A. True
Explanation
You can select multiple cells at the same time in order to format them. This allows you to apply formatting options, such as changing the font, adjusting the alignment, or adding borders, to multiple cells simultaneously, saving time and effort.

Rate this question:

• 15.

You may only have one excel document open at a time.

• A.

True

• B.

False

B. False
Explanation
The statement "You may only have one excel document open at a time" is false. In Excel, you can have multiple documents open simultaneously by opening them in separate windows or using the "Open in New Window" option. This allows users to work on multiple spreadsheets or compare data from different files at the same time.

Rate this question:

• 16.

Revising information in a spreadsheet is as easy as:

• A.

Double clicking on the cell and entering the new information

• B.

Clicking once on the cell and pressing Delete

• C.

Retyping all of the information

• D.

Using the Undo command

A. Double clicking on the cell and entering the new information
Explanation
Revising information in a spreadsheet is made easy by double clicking on the cell and entering the new information. This action allows the user to directly edit the content of the cell without the need to delete or retype the entire information. By double clicking, the cell becomes editable, and the user can simply enter the updated data. This method saves time and effort compared to other options such as deleting the cell content, retyping everything, or using the undo command.

Rate this question:

• 17.

When sorting data, the Row Header will never be affected

• A.

True

• B.

False

B. False
Explanation
When sorting data, the Row Header can be affected depending on the sorting method used. If the data is sorted by a specific column, the Row Header will be rearranged accordingly to match the new order of the data. Therefore, the statement that the Row Header will never be affected when sorting data is incorrect.

Rate this question:

• 18.

What are the two ways you can sort information?

• A.

A to Z and Z to A

• B.

Back and Forth

• C.

Left to Right and Right to Left

A. A to Z and Z to A
Explanation
The correct answer is A to Z and Z to A. These two ways of sorting information refer to arranging data in ascending order (A to Z) or descending order (Z to A) based on a specific criteria, such as alphabetical order. This allows for easier organization and retrieval of information, depending on the desired arrangement.

Rate this question:

• 19.

Which of the following is not a choice when you are printing?

• A.

Selection

• B.

Active Sheet

• C.

Entire Workbook

• D.

Cells Selected

D. Cells Selected
Explanation
When printing, you have the option to choose the Selection, Active Sheet, or Entire Workbook. However, "Cells Selected" is not a valid choice when printing.

Rate this question:

• 20.

To open a document, you may do one of the two things. Identify one fo the correct procedures.

• A.

Click and hold on the document name until it opens.

• B.

Click on the Excel shortcut on your desktop.

• C.

Open Excel, click File

• D.

Open, and click the document name.

D. Open, and click the document name.
Explanation
To open a document, the correct procedure is to open Excel, click on the "File" tab, select "Open", and then click on the document name. This will allow you to access the document within the Excel program.

Rate this question:

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, 2023
Quiz Edited by
ProProfs Editorial Team
• May 05, 2011
Quiz Created by
Missioncommunity

Related Topics