KLGREENS Excel Basic Assessment

KLGREENS Excel Basic Assessment

Professional Development

15 Qs

quiz-placeholder

Similar activities

Emerging Tech

Emerging Tech

Professional Development

15 Qs

Part 1 Quiz Pengelolaan Kekaryawanan

Part 1 Quiz Pengelolaan Kekaryawanan

Professional Development

10 Qs

Maslow's theory test

Maslow's theory test

Professional Development

12 Qs

Presentation, Analysis & Interpretation of Data

Presentation, Analysis & Interpretation of Data

University - Professional Development

15 Qs

Tools of KPI

Tools of KPI

Professional Development

10 Qs

Module 3 unit 5 Using File System

Module 3 unit 5 Using File System

Professional Development

20 Qs

Applied Networking

Applied Networking

Professional Development

10 Qs

Edukasi Perpajakan Instansi Pemerintah

Edukasi Perpajakan Instansi Pemerintah

Professional Development

12 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

Access all questions and much more by creating a free account

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?