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

University

•

118 Qs

Similar activities

General Knowledge Quiz

8th Grade - University

•

114 Qs

30100-0008 งานคอมพิวเตอร์เบื้องต้น

12th Grade - University

•

120 Qs

Sim_II_Parcial_FTS2023

University

•

118 Qs

HCI Quiz

University

•

118 Qs

Python Quiz BF-19-3-2024

University

•

123 Qs

ИКТ- сесссия

University

•

117 Qs

1st Spelling Words

1st Grade - University

•

120 Qs

TEST Teórico Introducción a las bases de dasstos

University

•

118 Qs

Excel Basics Quiz

Quiz

•

Computers

•

University

•

Practice Problem

•

Easy

Sabina Zamzieva

Used 1+ times

FREE Resource

118 questions

Show all answers

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

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

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

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

AutoFormat

AutoSum

AutoFill

Autosave

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Date

Formula

Numeric

Text

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"

Access all questions and much more by creating a free account

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

domande multiple create da me parte 1 is

Quiz

•

University

115 questions

Акт Рк1 бойынша тест

Quiz

•

University

116 questions

Kiến thức về Hệ điều hành Windows

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

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?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers