Font size
WorksheetsQuiz Microsoft Excel
Total questions: 30
Worksheet time: 15mins
The application program from Microsoft used to process numbers is ...
Microsoft Word
Microsoft Excel
Microsoft Power Point
Microsoft Access
Paint
Microsoft Excel is an application ...
Spreadsheet
Presentation
Word Processing
Animation
Programming
The function used to calculate the sum of numeric data is ...
Sum
Max
Min
Average
OR
The function used to determine the largest value is ...
Sum
Max
Min
Average
Count
The command used to save an Excel worksheet is ...
Ctrl + A
Ctrl + V
Ctrl + N
Ctrl + S
Ctrl + B
The following is not included in the Microsoft Office program group ...
Microsoft Excel
Microsoft Word
Microsoft Power Point
Microsoft Windows Vista
Microsoft Access
The content of cell B3 below is ...
I
I LIKE PHYSICS
I CYBER WORLD
I LIKE CYBER WORLD
CYBER WORLD
The command used to duplicate data is ...
Cut and Paste
Copy and Paste
Copy and Cut
Select All and Copy
Copy and Save
When working with Excel, information about the page, rows, columns, and others can be seen on ...
Status Bar
Menu Bar
Format Bar
Toolbar
Formula Bar
The Excel function formula to determine the average value is ...
Average
MIN
MAX
Count
SUM
The Excel function formula to determine the number of data is ...
Average
MIN
MAX
Count
SUM
=SQRT(49) will give the result ...
1
6
7
9
49
The following cannot be used to run Excel ...
Shortcut on Desktop
Excel File
Excel Search
Word Document
Start Menu
The part of the Excel window used to move the worksheet in the horizontal direction is ...
Vertical Scroll Bar
Horizontal Scroll Bar
Control Bar
Task Pane
Customize
Images function to ...
Subtract
Multiply
Divide
Add
Square
The following is one of the benefits of a spreadsheet program, except ...
Making Graphs
Making Logos
Making Financial Reports
Making Tables
Making Cards
Observe the image below. The command above is performing ...
(a)
What does the command above do?
General Format
Accounting Format
Date Format
Percentage Format
Text Format
What is the purpose of Print Preview?
To view the page layout before printing
To print the worksheet
To print a specific part of the worksheet
To save the worksheet
None of the answers are correct
To create an absolute cell reference, which symbol is used?
=
&
+
@
$
Which function is used to find the smallest value in a set of numbers?
Sum
MAX
MIN
Average
Count
The open command can be executed from the file menu and the open button on the standard toolbar. Additionally, the open command can also be executed by pressing which button on the keyboard?
Ctrl + V
Ctrl + O
Ctrl + U
Ctrl + S
Ctrl + B
The command used to cut or move the contents of a cell is?
Undo
Redo
Cut
Save
Copy
If a formatted cell shows '######', it means?
The cell is too large
The cell is too narrow
The cell contains a virus
The cell must be deleted
The cell must be copied elsewhere
If a cell is written as $R$5, it means?
Cell R5 is absolute
Cell R5 is relative
Cell R5 contains $$
Cell R5 is both R and 5
Cell R5 is too short
In cell A2, if it contains 75, and there is a function =IF(A2<65,'C',IF(A2...) what will be the result?
A
B
C
A or B
B or C
In B3, if it says (SMA UNGGULAN) and there is a function =RIGHT(B3,2), what will it return?
SM
UN
SA
AN
AM
=MIN(12,34,5,7,90,0) will return?
0
5
7
12
90
To format currency with the currency symbol on the left, use?
General
Currency
Accounting
Special
Custom
The syntax or rule for the MAX function is?
Max(range)
Max(start range, end range)
Max(start cell, end cell)
Max(cell)
Max(cell, range)
