What is the difference between the DATE and NOW function?

b) DATE returns only the current date, while NOW returns the current date and time

a) DATE returns the current date and time, while NOW returns only the current date

c) DATE and NOW are the same function

d) Neither DATE nor NOW are functions in Excel

What is the purpose of the VLOOKUP function?

c) To search for a specific value in the first column of a table and return a corresponding value from another column

a) To count the number of cells that meet certain criteria

b) To find the highest or lowest value in a range of cells

d) To calculate the average of a range of cells

What is the correct syntax for the IF function?

c) =IF(value_if_true, logical_test, value_if_false)

a) =IF(logical_test, value_if_true, value_if_false)

b) =IF(value_if_false, value_if_true, logical_test)

d) =IF(logical_test, value_if_false, value_if_true)

You have a table of employee data and you want to find the salary of a specific employee based on their ID number. Which formula should you use?

c) =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

a) =LOOKUP(lookup_value, table_array, col_index_num)

b) =MATCH(lookup_value, lookup_array, match_type)

d) =HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

What is the difference between a formula and a function in Excel?

c) A function performs a specific task, while a formula is a user-created expression.

a) There is no difference, the terms are interchangeable.

b) A formula performs a specific task, while a function is a user-created expression.

d) A formula always starts with an equal sign, while a function does not.

What is the main difference between COUNT and COUNTA in Excel?

a) COUNT counts only cells that contain numeric values or dates, while COUNTA counts all non-empty cells.

b) COUNT counts all non-empty cells, regardless of their content, while COUNTA counts only cells that contain numeric values or dates.

c) COUNT counts cells with values greater than a specific number, while COUNTA counts cells with values less than a specific number.

d) COUNT and COUNTA are the same function, and there is no difference between them.

What are the steps to insert a chart in Excel?

d) Select the data you want to include in the chart, select the Chart ribbon, click on the Insert Chart icon, and select the type of chart you want to use from the drop-down menu

a) Select the Chart ribbon, click on the Insert Chart icon, and customize the chart design

b) Select the Home ribbon, click on the Chart icon, and select the chart type from the drop-down menu

c) Select the Data ribbon, click on the Insert Chart icon, and customize the chart design

You want to copy a range of cells in Excel, but you only want to copy the values, not the formulas. What is the quickest way to do this?

d) Copy the cells as usual, then select "Paste Values" from the "Paste Special" option

a) Right-click and select "Paste Values"

b) Press "Ctrl + V" to paste, then select "Values" from the drop-down menu

c) Press "Ctrl + Shift + V" to paste only values

What information does the keyboard shortcut "Ctrl + End" provide in Excel?

b) The row number of the last row in the data set

a) The total number of cells in the worksheet

c) The column number of the last column in the data set

d) The total number of rows and columns in the data set

What are sparklines in Excel?

a) Small charts that fit in a single cell

b) A type of formula used for data analysis

c) A type of formatting used for highlighting cells

d) A tool for merging and splitting cells

Which of the following types of data is best suited for a sparkline?

c) Simple data sets with a few variables

a) Highly detailed data with many variables

b) Large data sets with hundreds of rows and columns

d) Data sets with complex calculations and formulas

What is the advantage of using sparklines over traditional charts in Excel?

b) Sparklines take up less space on the worksheet

a) Sparklines allow for more detailed analysis of data

c) Sparklines can be customized with more formatting options

d) Sparklines can handle larger data sets than traditional charts

What is the correct way to use .CSV file in Excel?

B) Use the Text Import Wizard to import the .CSV file into Excel.

A) Simply open the .CSV file in Excel and start working with it.

C) Convert the .CSV file into an Excel file format before opening it in Excel.

Which of the following statements is true about Flash Fill in Excel?

C) Flash Fill is a feature that can be used to automatically fill data based on patterns recognized by Excel.

A) Flash Fill is a feature that can only be used for numerical data.

B) Flash Fill is a feature that automatically formats cells based on pre-defined formats.

D) Flash Fill is a feature that is only available in older versions of Excel.

How would you select non-contiguous cells?

Hold Shift & left-click on each cell

Hold Ctrl & left-click on each cell

Hold Alt & left-click on each cell

Excel Basic Level QUIZ

Authored by Deon Strydom

Computers

Professional Development

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

45 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following Ribbons appear when you open Excel?

a) Home, Insert, Page Layout, Formulas, Data, Review, View

b) Home, Insert, Page Setup, Formulas, Data, Review, View

c) Design, Layout, Formulas, Data, Review, View

d) Edit, Insert, Formatting, Data, Review, View

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following commands appear under the Home Ribbon?

a) PivotTables, Slicers, Filters

b) Insert Table, Chart, Picture

c) Cell Styles, Conditional Formatting, Sort & Filter

d) AutoSum, Insert Function, Name Manager

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following commands does the Page Layout Ribbon contain?

a) Font, Alignment, Number Format

b) Margins, Orientation, Page Setup

c) Themes, Colors, Fonts

d) Sort, Filter, Subtotal

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When will you use the DATA Ribbon?

a) To insert charts and pictures

b) To format cells and apply styles

c) To perform calculations and use formulas

d) To import, export, and analyze data

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the most common file extension in Excel?

a) .docx

b) .pptx

c) .xlsx

d) .pdf

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the difference between a workbook and worksheet?

a) A workbook contains multiple worksheets, while a worksheet contains multiple workbooks

b) A workbook is a file that contains one or more worksheets

c) A worksheet is a file that contains one or more workbooks

d) A workbook and a worksheet are the same thing

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens if you delete a worksheet?

a) The worksheet is permanently deleted and cannot be recovered

b) The worksheet is moved to the Recycle Bin and can be restored if needed

c) The data in the worksheet is deleted, but the worksheet itself remains in the workbook

d) Nothing happens, you cannot delete a worksheet in Excel

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

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

Already have an account?

Similar Resources on Wayground

40 questions

revisão fundamentos da computação

Quiz

•

Professional Development

40 questions

แบบทดสอบคอมพิวเตอร์

Quiz

•

Professional Development

47 questions

Latihan CAT PPPK 2022 - Pemadam Kebakaran Pemula

Quiz

•

University - Professi...

49 questions

1. Maszyny i urządzenia.

Quiz

•

Professional Development

50 questions

Kompetensi Keahlian TKJ

Quiz

•

Professional Development

50 questions

Ujian TIK

Quiz

•

Professional Development

40 questions

Data Preprocessing

Quiz

•

Professional Development

41 questions

Accesibilidad y Usabilidad Web Quiz

Quiz

•

Professional Development

Popular Resources on Wayground

6 questions

PRIDE Always and Everywhere

Presentation

•

12th Grade

20 questions

Lab Safety Quiz

Quiz

•

6th Grade

26 questions

KOR Review Kahoot Questions

Quiz

•

8th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

12 questions

Unit Zero lesson 2 cafeteria

Presentation

•

9th - 12th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

10 questions

Riddles Riddles fun Riddles

Quiz

•

6th - 12th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

Discover more resources for Computers

10 questions

Soup, Salad, or Sandwich?

Quiz

•

1st Grade - Professio...

20 questions

Employability Skills

Quiz

•

Professional Development

9 questions

How to Email your Teacher

Quiz

•

Professional Development

25 questions

2023 Pop Culture Trivia

Quiz

•

Professional Development

20 questions

Cinema Camera Angles

Quiz

•

9th Grade - Professio...

20 questions

Sports trivia

Quiz

•

Professional Development

21 questions

Shop Safety

Quiz

•

Professional Development

Excel Basic Level QUIZ

Which of the following Ribbons appear when you open Excel?

Which of the following commands appear under the Home Ribbon?

Which of the following commands does the Page Layout Ribbon contain?

When will you use the DATA Ribbon?

What is the most common file extension in Excel?

What is the difference between a workbook and worksheet?

What happens if you delete a worksheet?

What is the shortcut key to save a workbook/Excel file?

What is the shortcut key to insert a new worksheet in a workbook?

From which group can you apply number, text, and accounting formatting?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers