Excel Intermediate Pre Test

11 Questions | By Naldsauza | Last updated: Mar 23, 2015

Settings

- +

Choose one answer best for your knowledge. (Pilih satu jawapan mengikut kefahaman awal anda)

More Microsoft Excel Quizzes

Basic Quiz On Microsoft Excel Exam!

Test Your Basic Excel Knowledge With This Quiz!

Microsoft Excel - Set 1

Featured Quizzes

What Animal Would Your Daemon Settle As?

Quiz: Some Trivia Facts About New Year!

Which Alan Walker Song Best Describes You? Quiz!

Related Topics

Questions and Answers

1.

Data Validation will make your entering data process more accurate, more faster and uniform. (Data Validation menyebabkan kerja kemasukan data lebih tepat, lebih cepat dan seragam)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
2.

Freezing Panes only can be applied in two method only either on Column or Row (Membekukan sel hanya boleh dilakukan dengan 2 cara sahaja samada pada Column atau Row dalam satu-satu masa)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
3.

Range Names is a common names applied to a cell/column/row (Range Name merupakan nama biasa yang diberikan pada sel/column/baris)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
4.

Name Designer is the location for us to edit any Range Name applied before (Bame Designer digunakan untuk mengedit Range Name yang sedia ada)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
5.

Charts best developed in Microsoft PowerPoint and Imported into Microsoft Excel (Chrt terbaik di buat di Microsoft PowerPoint dan dimasukkan ke Microsoft Excel)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
6.

Conditional Formatting only can be applied to a number (Conditional Formatting hanya boleh disetkan pada nombor sahaja)
- A.
  
  True
- B.
  
  False
- C.
  
  I DOnt Know
7.

What is the shortcut key to have charts in a new worksheet (Apakah kekunci untuk mendapatkan Carta di wrksheet yang baru)?
- A.
  
  F11
- B.
  
  F12
- C.
  
  I Dont Know
8.

Stock , Bubble., Area and Doughnut are example of Chart Types in Microsft Excel (Stock , Bubble., Area dan Doughnut merupakan antara jenis-jenis Carta di Microsoft Excel)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont KNow
9.

There are commonly two types of data in Microsoft Excel calculation - number and text(Terdapat 2 jenis data dalam pengiraan Microsoft Excel - Nombor dan Teks)
- A.
  
  True
- B.
  
  False
- C.
  
  I D0nt KNow
10.

Format As Table can be used to get style of table with quickier and easier.(Format As Table boleh digunakan untuk mendapatkan stail jadual secara cepat dan mudah.)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
11.

What is $A$2 symbol means in Excel?(Apakah maksud simbol $A$2 di dalam Excel)?
- A.
  
  Absolute Refference
- B.
  
  Currency Refference
- C.
  
  IDont Have any idea

Back to top