Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah)
True
False
Rate this question:
VLOOKUP(), LLOOKUP(), LOOKUP()
VLOOKUP(),HLOOKUP(),LOOKUP()
VLOOKUP(),LOOKUP(),MLOOKUP()
Rate this question:
Data > Sort
Data > Filter
Data > Sub Total
Rate this question:
Insert > Link
Insert > Hyperlink
Insert > Text Box
Rate this question:
True
False
Rate this question:
Save new reuse workbook in your computer
Do calculations easier
Have standard report layout
Rate this question:
Go to Function
Group object
Sum Function
Rate this question:
CTRL Home and End
CTRL Page Up and Page Down
CTRL Arrow Up and Arrow Down
Rate this question:
Colour settings and Formatting
Colour Settings and Summary Calculations
Colour Settings, Filters and Summary Calculations
Rate this question:
Starts with alphabet
Use underscore as a name separator
Starts with symbols or number
Rate this question:
All
Column
Row
Rate this question:
SubTotal
Calculate data across worksheet
Data Consolidate
Rate this question:
VLookup()
DSUM()
Average()
Rate this question:
True
False
Rate this question:
Quiz Review Timeline (Updated): Mar 22, 2023 +
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.