Excel

What is the shortcut key to save an Excel file?

Ctrl+S

Ctrl+P

Ctrl+C

Ctrl+X

Which function is used to find the highest value in a range of cells?

MAX

SUM

COUNT

AVERAGE

How do you freeze panes in Excel?

View tab > Freeze Panes

Home tab > Freeze Panes

Insert tab > Freeze Panes

Format tab > Freeze Panes

Which formula is used to calculate the average of a range of cells?

AVERAGE

SUM

COUNT

MAX

What does the VLOOKUP function do?

Searches for a value in the leftmost column of a table and returns a corresponding value from a specified column

Calculates the square root of a number

Sorts data in ascending order

Counts the number of cells in a range that meet a certain criteria

How do you insert a new worksheet in Excel?

Right-click on a worksheet tab and select Insert

Go to the Home tab and click on Insert

Press Ctrl+Shift+N

Go to the File tab and select New Worksheet

Which function is used to count the number of cells in a range that meet a certain criteria?

COUNTIF

SUMIF

AVERAGEIF

MAXIF

What does the CONCATENATE function do?

Joins two or more text strings together

Calculates the sum of a range of cells

Converts a value to text

Rounds a number to a specific decimal place

How do you apply conditional formatting to a range of cells in Excel?

Select the range of cells, go to the Home tab, and click on Conditional Formatting

Right-click on a cell and select Format Cells

Press Ctrl+Shift+C

Go to the Insert tab and select Conditional Formatting

Which function is used to find the largest value that is less than or equal to a given criteria in a sorted range of cells?

VLOOKUP

HLOOKUP

INDEX

LOOKUP

How do you insert a line break within a cell in Excel?

Press Alt+Enter

Right-click on a cell and select Insert Line Break

Go to the Format tab and select Line Break

Press Ctrl+Shift+Enter

What does the IF function do?

Performs a logical test and returns one value if the test is true and another value if the test is false

Calculates the average of a range of cells

Sorts data in descending order

Counts the number of cells in a range that meet a certain criteria

How do you remove duplicates from a range of cells in Excel?

Select the range of cells, go to the Data tab, and click on Remove Duplicates

Right-click on a cell and select Remove Duplicates

Press Ctrl+Shift+D

Go to the Format tab and select Remove Duplicates

Which function is used to calculate the square root of a number in Excel?

SQRT

SUM

COUNT

MAX

How do you change the font color of a cell in Excel?

Select the cell, go to the Home tab, and choose a font color

Right-click on a cell and select Font Color

Press Ctrl+Shift+F

Go to the Insert tab and select Font Color

What does the SUMIF function do?

Adds up the values in a range of cells that meet a certain criteria

Calculates the average of a range of cells

Sorts data in ascending order

Counts the number of cells in a range that meet a certain criteria

How do you create a chart in Excel?

Select the data range, go to the Insert tab, and choose a chart type

Right-click on a cell and select Create Chart

Press Ctrl+Shift+G

Go to the Format tab and select Create Chart

Which function is used to calculate the total number of cells in a range that contain numbers?

COUNT

SUM

AVERAGE

MAX

How do you merge cells in Excel?

Select the cells, go to the Home tab, and click on Merge & Center

Right-click on a cell and select Merge Cells

Press Ctrl+Shift+M

Go to the Insert tab and select Merge Cells

What does the COUNTIF function do?

Counts the number of cells in a range that meet a certain criteria

Calculates the average of a range of cells

Sorts data in ascending order

Adds up the values in a range of cells that meet a certain criteria

Unlock and Upgrade

Remove all limits from your Quizzes

Excel

More Quizzes