Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah)
And()
Else()
If()
Not Sure
Rate this question:
COUNTIF()
COUNTA()
COUNTBLANK()
Not Sure
Rate this question:
True
False
Not sure
Rate this question:
Save new reuse workbook in your computer
Do calculations easier
Have standard report layout
Not Sure
Rate this question:
A1 + A2
A1 / $A$2
A1 / A$2
Not Sure
Rate this question:
True
False
Not sure
Rate this question:
SubTotal
Calculate data across worksheet
Data Consolidate
Not Sure
Rate this question:
Cell name
Range name
Table name
Not Sure
Rate this question:
Date()
DateDif()
Year()
Not Sure
Rate this question:
Select Data
Select Data Row
Save as template
Not Sure
Rate this question:
Change bar to line Chart > Double click > Secondary Axis
Double click on bar chart > Secondary Axis
Chart Tools Design > Change Chart Type
Not Sure
Rate this question:
SUMIF()
SUMIFS()
SUM()
Not Sure
Rate this question:
F12
F10
F11
Not Sure
Rate this question:
TOTAL SUM
TOTAL ROW
TOTAL COLUMN
Not Sure
Rate this question:
Quiz Review Timeline (Updated): Apr 2, 2025 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
BASIC 6 COMPUTING QUIZ
The BASIC 6 COMPUTING QUIZ assesses foundational knowledge in spreadsheet management, focusing on Excel. It covers key concepts like cells, databases, sheet tabs, and cell naming,...
Questions:
8 |
Attempts:
122 |
Last updated:
Apr 06, 2023
|
Data Analyst Excel Test
Dive into our Data Analyst Excel Test and show off your skills. In this test, you'll face a range of challenges that cover everything essential for a data analyst. We'll...
Questions:
10 |
Attempts:
7780 |
Last updated:
Jul 03, 2024
|
9th Grade Excel Test
This 9th Grade Excel Test assesses key spreadsheet skills. It covers functions like MAX and RANGE, proper data selection for graphs, and understanding of cell alignment. Ideal for...
Questions:
9 |
Attempts:
1995 |
Last updated:
Nov 08, 2024
|
Keystone Bank Pre-Training Assessment
This assessment tests proficiency in Excel functionalities like sorting, using gridlines, worksheet operations, freeze panes, and functions.
Questions:
20 |
Attempts:
143 |
Last updated:
Mar 22, 2023
|
Microsoft Excel Proficiency Trivia Questions
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions:
122 |
Attempts:
227 |
Last updated:
Sep 13, 2023
|
Test How Much Do You Know About Excel Sheets! Trivia
Explore your knowledge of Excel Sheets with this trivia! Learn to sort columns, freeze panes, create tables, use conditional formatting, and search data efficiently. Perfect for...
Questions:
20 |
Attempts:
482 |
Last updated:
Sep 09, 2024
|
Wait!
Here's an interesting quiz for you.