Microsoft Excel Advanced Features

Microsoft Excel Advanced Features

1st Grade - University

14 Qs

quiz-placeholder

Similar activities

Google Sheets

Google Sheets

2nd Grade

10 Qs

Spreadsheet Basics & Formula

Spreadsheet Basics & Formula

6th - 8th Grade

14 Qs

Google Sheets

Google Sheets

6th Grade

16 Qs

Spreadsheets

Spreadsheets

8th Grade

10 Qs

Spreadsheets

Spreadsheets

7th Grade

15 Qs

Spreadsheets Quiz 1

Spreadsheets Quiz 1

8th - 9th Grade

15 Qs

ICT Spreadsheets

ICT Spreadsheets

9th Grade

12 Qs

Spreadsheet

Spreadsheet

7th Grade

15 Qs

Microsoft Excel Advanced Features

Microsoft Excel Advanced Features

Assessment

Quiz

Computers

1st Grade - University

Medium

Created by

MR. NORAZMAN

Used 26+ times

FREE Resource

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What row should we select to freeze the 3th row?

3rd row

4th row

1st row

All row

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which column to select to freeze 2nd column?

1st column

2nd column

3rd column

4th column

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main function of conditional formating

To change the cell styles

To change font, font size, and color

Allow user to user to type automatically

Allow user to automatically apply formatting

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the best way to save our time in setting similar format of a cell from another cell?

Use format painter

Use conditional formatting

Insert a picture

Zoom in the page

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Users can define their own cell style or use existing style in Excel

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

”A predefined formula that performs calculations using specific values in a particular order”

Operators

Mathematics

Function

Library

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To start using formula in Excel, users need to type _____ sign in the beginning of the formula

more than, >

equal sign, =

less than, <

exclamation mark, !

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?