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

Professional Development

•

45 Qs

Similar activities

Davinci Resolve 17 Fusion 101

11th Grade - Professional Development

•

45 Qs

Kiểm tra giữa kỳ TIN HỌC lớp 6_THCS Nguyễn Trãi_01_21-22

Professional Development

•

50 Qs

La Capa Física y los Sistemas de Cableado Estructurado

Professional Development

•

40 Qs

AZ-900 Practice Test 1

Professional Development

•

43 Qs

KJD 10 Siniu

Professional Development

•

40 Qs

Introduction to Statistics

Professional Development

•

41 Qs

UAS ASJ KLS 11 SINIU

Professional Development

•

40 Qs

Az-900 Prep 2

Professional Development

•

50 Qs

Excel Basic Level QUIZ

Quiz

•

Computers

•

Professional Development

•

Practice Problem

•

Hard

Deon Strydom

Used 2+ times

FREE Resource

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Komputer Akuntansi Kelas XI AK

Quiz

•

KG - Professional Dev...

50 questions

Genel Kültür

Quiz

•

University - Professi...

40 questions

Examen Teórico de Sistemas Operativos

Quiz

•

Professional Development

50 questions

RUTS Technology

Quiz

•

9th Grade - Professio...

50 questions

Programación y robótica educativa (OpcMul)

Quiz

•

Professional Development

41 questions

ITIL SERVICE LIFECYCLE

Quiz

•

Professional Development

40 questions

21 st Century Literacy Skills

Quiz

•

Professional Development

50 questions

Quizz Compition(Social Media,cyber Crime,Ms Word,Cyber Security)

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

10 questions

How to Email your Teacher

Quiz

•

Professional Development

6 questions

3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET

Quiz

•

Professional Development

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

22 questions

Multiplying Exponents with the Same Base

Quiz

•

9th Grade - Professio...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

Excel Basic Level QUIZ

45 questions

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