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

Excel test - take the quiz

What is the shortcut key to save a workbook in Excel?
Ctrl+S
Ctrl+P
Ctrl+C
Ctrl+Z
Which function is used to find the largest value in a range of cells in Excel?
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 function is used to count the number of cells that contain numbers in a range in Excel?
COUNT
SUM
MAX
AVERAGE
How do you insert a new worksheet in Excel?
Right-click on a worksheet tab > Insert
Home tab > Insert
File tab > Insert
Format tab > Insert
Which function is used to find the average value of a range of cells in Excel?
AVERAGE
SUM
COUNT
MAX
How do you apply conditional formatting to a cell in Excel?
Home tab > Conditional Formatting
View tab > Conditional Formatting
Insert tab > Conditional Formatting
Format tab > Conditional Formatting
What is the shortcut key to undo the last action in Excel?
Ctrl+Z
Ctrl+S
Ctrl+C
Ctrl+P
How do you merge cells in Excel?
Home tab > Merge & Center
View tab > Merge Cells
Insert tab > Merge Cells
Format tab > Merge Cells
Which function is used to find the smallest value in a range of cells in Excel?
MIN
SUM
COUNT
AVERAGE
How do you insert a chart in Excel?
Insert tab > Chart
Home tab > Chart
View tab > Chart
Format tab > Chart
What is the shortcut key to copy a cell in Excel?
Ctrl+C
Ctrl+V
Ctrl+X
Ctrl+Z
How do you apply a filter to a range of cells in Excel?
Data tab > Filter
Home tab > Filter
View tab > Filter
Format tab > Filter
Which function is used to concatenate two or more text strings in Excel?
CONCATENATE
SUM
COUNT
AVERAGE
How do you insert a row in Excel?
Right-click on a row number > Insert
Home tab > Insert
File tab > Insert
Format tab > Insert
What is the shortcut key to paste the contents of the clipboard in Excel?
Ctrl+V
Ctrl+C
Ctrl+X
Ctrl+Z
How do you apply a border to a cell in Excel?
Home tab > Border
View tab > Border
Insert tab > Border
Format tab > Border
Which function is used to find the total sum of a range of cells in Excel?
SUM
COUNT
MAX
AVERAGE
How do you insert a column in Excel?
Right-click on a column letter > Insert
Home tab > Insert
File tab > Insert
Format tab > Insert
What is the shortcut key to cut a cell in Excel?
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+Z
{"name":"Excel test - take the quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the shortcut key to save a workbook in Excel?, Which function is used to find the largest value in a range of cells in Excel?, How do you freeze panes in Excel?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

More Quizzes

Maths super hard
11620
Emily-Rose
1050
Data Communication
840
Transfer Specialist Quiz #2
42142
LYP
210
Socials
630
The turbulent term of Tyke Tiler
320
Which Hogworts House are you in?
420
AGRICULTURE MCQ
1166
Idk famio
520
Chemistry Quiz
20100
FEMALE REPRODUCTIVE SYSTEM
10556
Quiz Maker Logo Make your own Quiz
Powered by: Quiz Maker