Search Header Logo

Excel - lesson and knowledge check.

Authored by Andrea Ferrey

Computers

1st - 5th Grade

Used 2+ times

Excel - lesson and knowledge check.
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

7 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 2 pts

Excel is a ...

Spreadsheet software program

Spreadsheet to work with data, and charts.

Analysis tool

Powerful data visualization

1,3,4 are correct.

Answer explanation

Media Image

Correct

Excel is a spreadsheet software program, analysis tool and powerful data visualization.

2.

DRAG AND DROP QUESTION

45 sec • 1 pt

​ (a)   ​ is an action that CANNOT be reversed using the Undo command​.

Deleting a tab in the workbook
Typing over the contents of a cell in a workbook
Deleting 20 rows of data in the workbook.
Deleting a column in the workbook

Answer explanation

Media Image

Correct

The Undo feature does not apply to modifying tabs in the workbook, which includes deleting and renaming the tab.

3.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

Which action will edit locked cells in a protected worksheet?

Highlight the data, right-click, and then select Unlock.

Use Save As to create a new worksheet, and then make your edits.

Unlock the cells in which you are interested.

Enter the password to turn off the protection.

Answer explanation

Media Image

Correct

Before you can edit, you must enter the password to unlock the protected sheet.

4.

MULTIPLE CHOICE QUESTION

45 sec • 2 pts

What is the difference between a workbook and worksheet?

Workbook and worksheet are terms that can be used interchangeably and are Excel files.

A workbook is a collection of Excel files and a worksheet is an individual file.

A worksheet is the file and a workbook is the individual tab within the worksheet.

A workbook is the file and a worksheet is the individual tab within the workbook

5.

DRAG AND DROP QUESTION

45 sec • 1 pt

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products? ​ ​ (a)  

by typing =d5-d6
By typing d5-d6
by typing 400-250
By typing 400-250
By typing =400-250

Answer explanation

Media Image

Correct

This creates a formula you can drag across other products using the fill handle.

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

One of the number cells in your worksheet shows as ###. What does this mean?

The cell is empty in a row of cells filled with content.

There is a division-by-zero error in the cell contents calculation.

The content in the cell is wider than the cell width.

The number you entered in the cell is larger than 1,000.

Answer explanation

Media Image

Correct

The correct display will reappear if the cell is made larger to accommodate the display.

7.

DROPDOWN QUESTION

45 sec • 1 pt

What is the first step in creating a chart with Excel Office 365? ​ ​ (a)  

Highlight the data you want to show in the chart.
Insert a row of empty cells beneath the title.
Create totals for each row and each column.
Select the chart type you are interested.

Answer explanation

Media Image

Correct

The first step in creating a chart is telling Excel the data from which you want the chart to be created.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?