Quiz Maker LogoMake your own QuizCopy & Edit
Make your own quizManage my QuizzesPlans / FeaturesGuides and HelpContactPrivacy & Security

Advance excel - take the quiz

What is the shortcut key to open the Format Cells dialog box in Excel?
Ctrl + Shift + F
Ctrl + F
Alt + F4
Ctrl + Alt + F
Which function is used to find the highest value in a range of cells in Excel?
MAX
SUM
AVERAGE
COUNT
How can you freeze panes in Excel? (Select all those are correct)
Go to the View tab and click on Freeze Panes
Right-click on a cell and select Freeze Panes
Press Ctrl + F
Use the Freeze Panes button on the Home tab
Which formula is used to count the number of cells that contain numbers in a range in Excel?
COUNT
SUM
AVERAGE
MAX
How can you create a pivot table in Excel? (Select all those are correct)
Select the data range and go to the Insert tab, then click on PivotTable
Right-click on a cell and select Create PivotTable
Press Ctrl + P
Use the PivotTable button on the Home tab
What is the function of VLOOKUP in Excel?
It searches for a value in the first column of a table and returns a corresponding value from another column
It calculates the average of a range of cells
It counts the number of cells that meet a certain condition
It finds the highest value in a range of cells
How can you insert a new worksheet in Excel? (Select all those are correct)
Right-click on a worksheet tab and select Insert
Go to the Home tab and click on Insert
Press Ctrl + I
Use the Insert Worksheet button on the View tab
Which function is used to calculate the total number of characters in a cell in Excel?
LEN
COUNT
SUM
AVERAGE
How can you sort data in Excel? (Select all those are correct)
Select the data range and go to the Data tab, then click on Sort
Right-click on a cell and select Sort
Press Ctrl + S
Use the Sort button on the Home tab
What is the purpose of conditional formatting in Excel?
It allows users to format cells based on specific criteria or rules
It calculates the average of a range of cells
It counts the number of cells that meet a certain condition
It finds the highest value in a range of cells
How can you protect a worksheet in Excel? (Select all those are correct)
Go to the Review tab and click on Protect Sheet
Right-click on a worksheet tab and select Protect Sheet
Press Ctrl + P
Use the Protect Worksheet button on the Home tab
Which function is used to calculate the average of a range of cells in Excel?
AVERAGE
COUNT
SUM
MAX
How can you insert a chart in Excel? (Select all those are correct)
Select the data range and go to the Insert tab, then click on the desired chart type
Right-click on a cell and select Insert Chart
Press Ctrl + C
Use the Chart button on the Home tab
What is the purpose of the IF function in Excel?
It allows users to perform logical tests and return different values based on the result
It calculates the average of a range of cells
It counts the number of cells that meet a certain condition
It finds the highest value in a range of cells
How can you merge cells in Excel? (Select all those are correct)
Select the cells to be merged and go to the Home tab, then click on Merge & Center
Right-click on a cell and select Merge Cells
Press Ctrl + M
Use the Merge Cells button on the Format tab
Which function is used to calculate the sum of a range of cells in Excel?
SUM
COUNT
AVERAGE
MAX
How can you insert a hyperlink in Excel? (Select all those are correct)
Select the cell where you want to insert the hyperlink and go to the Insert tab, then click on Hyperlink
Right-click on a cell and select Insert Hyperlink
Press Ctrl + H
Use the Hyperlink button on the Home tab
What is the purpose of the CONCATENATE function in Excel?
It combines multiple text strings into one string
It calculates the average of a range of cells
It counts the number of cells that meet a certain condition
It finds the highest value in a range of cells
How can you remove duplicates in Excel? (Select all those are correct)
Select the data range and go to the Data tab, then click on Remove Duplicates
Right-click on a cell and select Remove Duplicates
Press Ctrl + D
Use the Remove Duplicates button on the Home tab
Which function is used to calculate the product of a range of cells in Excel?
PRODUCT
COUNT
SUM
MAX
{"name":"Advance excel - take the quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the shortcut key to open the Format Cells dialog box in Excel?, Which function is used to find the highest value in a range of cells in Excel?, How can you freeze panes in Excel? (Select all those are correct)","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Test Wiedzy z Omili
320
Ultimate Koma Quiz
1366
Que tanto conoces a cesar
420
Do-Re-Mi's of Personality
1050
Water Cycle
520
What Type of Toot Are You?
10548
TLC CHILE-COLOMBIA
6329
Meisen trivia
10519
The commonwealth: its countries part 2
740
King Arthur combination quiz
210
Food Quiz
19100
OIT4
10511
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker