Advance MS Excel Tips and Tricks

Advance MS Excel Tips and Tricks

Professional Development

10 Qs

quiz-placeholder

Similar activities

Manajemen Risiko

Manajemen Risiko

Professional Development

15 Qs

transfer function reduction

transfer function reduction

Professional Development

10 Qs

MDK x CODIF WEBINAR - June 8, 2022

MDK x CODIF WEBINAR - June 8, 2022

Professional Development

10 Qs

ACADEMIA SD - SEXTOU

ACADEMIA SD - SEXTOU

Professional Development

12 Qs

se préparer au cléa numérique

se préparer au cléa numérique

Professional Development

11 Qs

online sharing

online sharing

Professional Development

10 Qs

Friday Fun

Friday Fun

Professional Development

10 Qs

Review Quiz

Review Quiz

Professional Development

10 Qs

Advance MS Excel Tips and Tricks

Advance MS Excel Tips and Tricks

Assessment

Quiz

Computers, Professional Development

Professional Development

Hard

Created by

John Marasigan

Used 29+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following is NOT part of a function

Equal Sign

Function Name

Arguments

Cell Reference

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following returns one value if the condition is TRUE, or another value if the condition is FALSE

IF function

IFS function

COUNT function

COUNTA function

3.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following Counts the number of cells that are not empty in a range

IF function

IFS function

COUNT function

COUNTA function

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following Sums the values in a range that meets the criteria that you specify

SUM function

SUMIF function

SUMIFS function

SUMMATION

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which Short-cut button Shows the Number Format

Ctrl + 1

Ctrl + ;

Alt + Enter

Ctrl + Shift + ;

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which Short-cut button Adds the current date into a cell

Ctrl + 1

Ctrl + ;

Alt + Enter

Ctrl + Shift + ;

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which Short-cut button is for AutoSum

Ctrl + 1

Alt + =

Alt + Enter

Ctrl + Shift + ;

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?