KLGREENS Excel Basic Assessment

KLGREENS Excel Basic Assessment

Professional Development

15 Qs

quiz-placeholder

Similar activities

SOAL MANAJERIAL_1

SOAL MANAJERIAL_1

Professional Development

15 Qs

Cloud Conference 2019 - Advanced

Cloud Conference 2019 - Advanced

Professional Development

20 Qs

Post Test Basic Modul 3 Jam

Post Test Basic Modul 3 Jam

Professional Development

17 Qs

Project Procurement Management

Project Procurement Management

Professional Development

20 Qs

Kurikulum PAUD

Kurikulum PAUD

Professional Development

15 Qs

Post Test Pendampingan Guru Kreator

Post Test Pendampingan Guru Kreator

Professional Development

20 Qs

INTELLIGENCE

INTELLIGENCE

Professional Development

10 Qs

KC 21

KC 21

Professional Development

11 Qs

KLGREENS Excel Basic Assessment

KLGREENS Excel Basic Assessment

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Hard

Created by

Shahadatuliskandar Rosli

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

How can you quickly highlight all the BLANK cells in the table shown in image?

CTRL A -> F5 -> Special -> Blanks

Press CTRL, select every blank cells

Press SHIFT, select every blank cells

CTRL F -> Find blank data

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Holding down the __________ key and scrolling the mouse wheel backward will zoom out.

TAB

SHIFT

CTRL

ALT

3.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Media Image

This is the Zoom Slider in Excel. How can you use this to zoom in/out?

Multiple answers

Click on the - | + icons

Drag the slider left | right

Place you mouse cursor on the slider line and scroll forward | backward

It is just to show the zoom level, cannot use it to change zoom level

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Entering formula in Excel is the most required skill for any Excel users. Refer to the diagram

Insert an equation

Show the sum, count, or average of the selected cells

Toggle between the 5 primary Excel functions

Insert a function

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

There are 3 different cell reference types in Excel: Relative, Absolute, and Mixed. Refer to the diagram

Because the reference to the task duration in hours is absolute, whereas it should be relative

Because the reference to the hourly rate is relative, whereas it needs to be absolute

It will

Because you can't copy formula down to adjacent cells in an Excel worksheet

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Worksheet navigation is an important skill in Excel. Refer to the diagram

Right-click on the arrows to the left of SHEET1

Double-click on any of the worksheets

You can't

Click on the + symbol to the right of the worksheets

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Data visualization using chart is an essential product of using Excel. Refer to the diagram

Annotations

Value captions

Legend entries

Data labels

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Professional Development