Anda menarik data antar workbook dengan rumus, lalu file sumber diubah namanya. Apa dampaknya?

D-5 Post Test STIKES

Quiz
•
Science
•
1st Grade
•
Easy
Uum Zakaria
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Rumus tetap jalan
Rumus auto-update
Rumus #REF! karena path berubah
Tidak berpengaruh
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ingin membuat tombol cetak laporan yang langsung menjalankan perintah cetak ke PDF. Fitur yang digunakan adalah...
Bookmark
Macro rekaman cetak
ActiveX Command Button + macro print
Conditional Formatting
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Ketika macro hanya berjalan di komputer tertentu, kemungkinan besar penyebabnya...
Versi Excel beda
Macro tidak di-enable di Excel Options
File terlalu besar
Printer tidak aktif
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Macro berjalan tetapi hasilnya berbeda dari yang diinginkan. Penyebab umum?
Salah klik
Macro merekam posisi sel relatif, bukan absolut
Chart tidak sesuai
Format tidak cocok
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Anda ingin satu klik membuka Sheet 'Input', filter data tertentu, dan pindahkan hasilnya. Solusi?
Manual
Macro rekaman + VBA untuk filter dan copy
Slicer
PivotTable
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dalam penggunaan hyperlink antar sheet, mengapa kadang tidak bekerja setelah sheet diganti nama?
Terlalu banyak link
Hyperlink masih menunjuk ke nama sheet lama
Font berubah
Workbook tidak kompatibel
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Untuk menjalankan macro dari tombol klik, langkah yang dilakukan adalah...
Insert > Form > Hyperlink
Insert > Shape > Assign Macro
View > Code > Copy
Review > Track
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Makanan Berkhasiat

Quiz
•
1st Grade
9 questions
Quiz IPA Pesawat Sederhana

Quiz
•
1st Grade
10 questions
D-4 Pre-Test

Quiz
•
1st Grade
15 questions
Trắc nghiệm VBA cùng thầy Henry IMIC

Quiz
•
1st Grade
15 questions
KUIZ SAINS BAB 1 TINGKATAN 1

Quiz
•
1st Grade
15 questions
VBA Test

Quiz
•
1st - 5th Grade
10 questions
SAINS TINGKATAN 4 BAB 2

Quiz
•
KG - Professional Dev...
10 questions
MOBILE MINI ZOO! TAHAP 1

Quiz
•
1st - 5th Grade
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade