Search Header Logo

Advance MS Excel Tips and Tricks

Authored by John Marasigan

Computers, Professional Development

Professional Development

Used 29+ times

Advance MS Excel Tips and Tricks
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

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 + ;

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?