Microsoft Excel Quiz
Published on: November 26, 2021
Excel Quiz
149
Created on

Excel Quiz

1 / 26

What can you do with data validation? Select all that apply.

2 / 26

Which of the following VLOOKUP functions is using the correct arguments?

3 / 26

Which function can display a different value depending on a condition?

4 / 26

In this image, which formula would we use to display the text Waffles: bunny?

5 / 26

Which function can find the highest value in a cell range?

6 / 26

Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?

7 / 26

Which function would you use to add several numeric values?

8 / 26

In Excel, the values 75 and 75% are equivalent.

9 / 26

In the order of operations, which of the following comes first?

10 / 26

Which of the formulas below are valid? Select all that apply.

11 / 26

In this image, which formula could you use to subtract the inventory costs from the monthly budget?

12 / 26

Excel will always tell you if there is a problem with a formula you’ve created.

13 / 26

Which feature starts with a desired result, then calculates the input value that will give that result?

14 / 26

The four areas in this image are used to create a ________.

15 / 26

What is the main advantage of selecting the Mark as Final option?

16 / 26

What feature did we use to quickly apply the formatting shown in this image?

17 / 26

What value would Excel return for this formula? =(82-32)/5+8*2

18 / 26

Which of the formulas below are valid? Select all that apply.

19 / 26

Which of the following is an absolute cell reference?

20 / 26

You can view a formula by double-clicking the cell that contains the formula.

21 / 26

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

22 / 26

You can click the tabs at the bottom of a workbook to switch between ________.

23 / 26

In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

24 / 26

Where is the fill handle located?

25 / 26

A group of cells is called a ________.

26 / 26

The intersection of a row and a column is called a ________.

Your score is

The average score is 21%

0%

1 Comment

  1. Aung Myo Htoo

    good

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Related Posts

Windows 11 23H2 16 in 1 64bit Free Download

Windows 11 23H2 16 in 1 64bit Free Download

Windows 11 23H2 သည် Microsoft ၏ Windows Operating System များ၏ Latest Version ဖြစ်သည်။ Microsoft သည် 2021 ခုနှစ် ဇွန်လ 24 ရက်နေ့တွင် Windows-11 ကို Windows 10 ၏ ဆက်ခံသူအဖြစ် ကြေငြာခဲ့သည်။ ၎င်းကို အောက်တိုဘာလ ၅ ရက် ၂၀၂၁ ခုနှစ်တွင် တရားဝင်ထုတ်ဝေခဲ့ပြီး...

Windows 10 22H2 16 in 1 2023.4.12 Free Download

Windows 10 22H2 16 in 1 2023.4.12 Free Download

ယခု Windows 10 21H1 Pro သည် Nov 2021 ထွက် နောက်ဆုံး Version ဖြစ်ပါသည်။ Microsoft သည် Windows 10 အား Oct 2025 အထိ ဆက်လက်ပံ့ပိုးပေးမည်ဖြစ်သည်။

USB Disk Security Free Download

USB Disk Security Free Download

USB Disk Security သည် USB Flash Drive များ ကွန်ပျူတာသို့ တပ်၍ အသုံးပြုရာတွင် ၎င်း Flash Drive များမှ ပါလာနိုင်သော Malware များ ကွန်ပျူတာသို့ မဝင်ရောက်နိုင်အောင် အလိုအလျှောက်တားဆီးကာကွယ်ပေးသော ဆော့ဝဲလ်ကောင်းတစ်ခု ဖြစ်ပါသည်။ ၎င်းဆော့ဝဲလ်ကို ကွန်ပျူတာတွင်...

Share This