How can you edit the content of a cell in Excel?

Double-click the cell or press F2

Right-click the cell and choose "Edit"

How can you insert a new column in Excel?

Right-click on a column header and choose "Insert Column"

How can you align the text within a cell to be centred both horizontally and vertically?

Use the alignment buttons in the Alignment group

Click the "Bold" button on the Ribbon

Use the "Merge & Center" option

What is the purpose of pinning regions in Excel?

To freeze a section of the worksheet

To group multiple sheets together

Autocomplete in Excel refers to:

Predictive text suggestions while typing

Automatically saving the workbook

How can you hide an Excel window temporarily without closing it?

Click the "Minimize" button on the window

Use the "Hide Window" option from the View menu

What is the purpose of text concatenation in Excel?

To merge text from multiple cells into one cell

To split text into multiple columns

To highlight text using bold formatting

To create a new sheet for text data

How does the SUMIF() function work in Excel?

It adds up values in a specified range that meet a condition.

It calculates the average of cells that meet a condition.

It counts the number of cells that meet a condition.

It finds the smallest value in a specified range.

What does the NOT() function in Excel do?

Inverts the logical value (True to False or False to True)

What is a histogram in the context of conditional formatting?

A visual representation of data distribution in columns or bars

A way to highlight duplicate values

What is the purpose of using color scales in Excel's conditional formatting?

To visualize data using color gradients based on cell values

What does the IF() function in Excel do?

Checks if a condition is true or false and returns values based on the result

What does the IF() function in Excel do?

Checks if a condition is true or false and returns values based on the result

What is the main purpose of a PivotTable in Excel?

To organize and summarize large amounts of data

What are functions and their codes in the context of subtotals in Excel?

Descriptions of different subtotal functions available in Excel

What is the purpose of using slices in Excel's PivotTables?

To provide a user-friendly way to filter and interact with data

What is a PivotChart in Excel?

A visual representation of PivotTable data

What is the working principle of 'Interim Results' in subtotals?

It calculates intermediate totals at various levels of grouping.

It converts values to percentage

What does the order of calculation refer to in Excel?

The order in which Excel performs calculations in a formula

The order in which cells are arranged on the worksheet

The sequence in which you enter data

The order of formatting applied to cells

What is the purpose of linking cells from one sheet to another in Excel?

To display data from another sheet without duplicating it

To create a copy of the data in the target sheet

To apply formatting to cells in the target sheet

To hide the data in the source sheet

In Excel, what is an absolute cell reference indicated by?

A dollar sign ($) before the column letter and row number

An asterisk (*) before the cell address

An exclamation mark (!) before the cell address

A pound sign (#) before the cell reference

When you copy a formula in Excel with relative addressing, how are cell references adjusted?

They update based on the new position of the formula

They convert to R1C1 style references

They become absolute references

In Excel, what is the purpose of creating a note (comment) in a cell?

To display additional information or context about the cell's content

To highlight the cell with color

To lock the cell and prevent further editing

To change the font size of the cell's content

How can you link to a cell in another workbook in Excel?

Type the workbook name in the formula bar followed by an exclamation mark

Right-click the cell and choose 'Link to Workbook.'

Use the 'Insert Hyperlink' option from the Ribbon

Press Ctrl + L to open the Link dialog box

When using 'Paste Special: Values' in Excel, what is copied and pasted?

Only the numerical values from the cells

The original formatting of the cells

Formulas and their calculated results

The comments and notes in the cells

In Excel, what is the purpose of using numeric filters?

To filter data based on numeric criteria

To change the font color of numeric values

To sort data in ascending order

What is the purpose of Quick Sort in Excel?

To quickly alphabetize text in a range

To sort data numerically from high to low

To automatically apply cell formatting

To sort data based on multiple criteria

What does the 'Paste Special: Transpose' option do in Excel?

Swaps rows and columns of the selected range

Changes the font style of the copied data

Copies the selected range to a different sheet

Copies the formula in reverse order

Excel Basics Quiz

Quiz

•

Computers

•

University

•

Practice Problem

•

Easy

Sabina Zamzieva

Used 1+ times

FREE Resource

118 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you create a new workbook in Microsoft Excel?

Right-click on an existing sheet and choose "New Workbook"

Press Ctrl + S

Go to File > New

Close an existing workbook

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut key combination to save a workbook in Excel?

Ctrl + S

Ctrl + C

Ctrl + X

Ctrl + P

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To change the name of a sheet in Excel, you should:

Right-click on the sheet and choose "Rename"

Press Ctrl + R

Delete the sheet and create a new one with the desired name

Use the Format Painter

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you add a new sheet to an existing Excel workbook?

Click the "Delete" button on the Ribbon

Go to File > New

Right-click on an existing sheet and select "Add New Sheet"

Click the " + " button at the bottom of the sheet tabs

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature in Excel automatically saves your workbook at regular intervals?

AutoFormat

AutoSum

AutoFill

Autosave

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which data type is appropriate to enter a phone number in Excel?

Date

Formula

Numeric

Text

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To enter a numeric value "250" into a cell, you would:

Type "=250"

Type "250"

Type "two fifty"

Type "2e2"

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

120 questions

E-QUIZ 2024

Quiz

•

University

121 questions

ĐỀ 1: HIỂU BIẾT VỀ CÔNG NGHỆ THÔNG TIN CƠ BẢN

Quiz

•

University

114 questions

Solidworks Quiz

Quiz

•

University

115 questions

Internet và GT

Quiz

•

University

119 questions

Industrial Relations Quiz

Quiz

•

University

118 questions

Kiến thức cơ bản về máy tính

Quiz

•

University

115 questions

MODUL 4

Quiz

•

University

121 questions

midterm 1

Quiz

•

University

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Computers

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

7 questions

Different Types of Energy

Interactive video

•

4th Grade - University

20 questions

Slopes and Slope-Intercept Form

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Biomolecules (Updated)

Interactive video

•

11th Grade - University

20 questions

Winter/Holiday Trivia

Quiz

•

KG - University

10 questions

WINTER WIN Time - ELA - 12/9/2025

Quiz

•

KG - University

7 questions

Human Impact on Resources

Interactive video

•

4th Grade - University

Excel Basics Quiz

118 questions

How can you create a new workbook in Microsoft Excel?

What is the shortcut key combination to save a workbook in Excel?

To change the name of a sheet in Excel, you should:

How can you add a new sheet to an existing Excel workbook?

Which feature in Excel automatically saves your workbook at regular intervals?

Which data type is appropriate to enter a phone number in Excel?

To enter a numeric value "250" into a cell, you would:

How can you navigate to the last cell in a worksheet containing data?

How can you edit the content of a cell in Excel?

What is the correct cell address for the cell located at the intersection of column B and row 5?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers