Spreadsheet Formulas and Functions MCQs With Answers

Computer MCQs 360May 28, 2024

0 15 1 minute read

Welcome to the Spreadsheet Formulas and Functions MCQs with Answers. In this post, we have shared Spreadsheet Formulas and Functions Online Test for different competitive exams. Find practice Spreadsheet Formulas and Functions Practice Questions with answers in Computer Tests exams here. Each question offers a chance to enhance your knowledge regarding Spreadsheet Formulas and Functions.

Spreadsheet Formulas and Functions Online Quiz

By presenting 3 options to choose from, Spreadsheet Formulas and Functions Quiz which cover a wide range of topics and levels of difficulty, making them adaptable to various learning objectives and preferences. You will have to read all the given answers of Spreadsheet Formulas and Functions Questions and Answers and click over the correct answer.

Test Name: Spreadsheet Formulas and Functions MCQ Quiz Practice
Type: Quiz Test
Total Questions: 40
Total Marks: 40
Time: 40 minutes

Note: Answer of the questions will change randomly each time you start the test. Practice each quiz test at least 3 times if you want to secure High Marks. Once you are finished, click the View Results button. If any answer looks wrong to you in Quizzes. simply click on question and comment below that question. so that we can update the answer in the quiz section.

Spreadsheet Formulas and Functions

Please fill out the form before starting Quiz.

1 / 40

In Excel, which function is used to find the highest numeric value in a dataset based on a specified criterion?

MAXIFS

MINIFS

AVERAGEIFS

2 / 40

Which Excel function returns the largest value in a set of arguments?

AVERAGE

MAX

MIN

3 / 40

Which function in Google Sheets returns the value of a cell located at a specified row and column within a range?

VLOOKUP

HLOOKUP

INDEX

4 / 40

Which Excel function returns the square root of a number?

SQRT

POWER

ROOT

5 / 40

Which function in Google Sheets returns the current date and time?

DATE

NOW

TODAY

6 / 40

Which Excel function rounds a number up to the nearest integer or to the nearest multiple of significance?

ROUND

ROUNDUP

ROUNDDOWN

7 / 40

Which Excel function calculates the internal rate of return for a series of cash flows?

NPV

RATE

IRR

8 / 40

In Google Sheets, which function returns the rank of a number in a list of numbers?

RANK

INDEX

MATCH

9 / 40

What function in Google Sheets finds the highest numeric value in a dataset based on a specified criterion?

MAXIFS

AVERAGEIFS

MINIFS

10 / 40

In Excel, which function finds the smallest value in a set of arguments and ignores logical values and text?

MAX

SMALL

MIN

11 / 40

Which Excel function returns the number of days between two dates based on a 360-day year?

NETWORKDAYS

DAYS360

DATEDIF

12 / 40

What Excel function calculates the sum of a set of values, including numbers and text?

SUM

CONCATENATE

COUNT

13 / 40

In Google Sheets, what function converts a text representation of a number to a numerical value?

NUMBERVALUE

VALUE

TEXT

14 / 40

In Excel, which function counts the number of cells that contain numbers within a range?

COUNTIF

COUNT

COUNTA

15 / 40

In Google Sheets, what function returns the date that is the indicated number of months before or after a specified date?

MONTH

DATEADD

EDATE

16 / 40

Which function in Excel checks multiple conditions and returns TRUE if all are true?

XOR

AND

17 / 40

Which function in Google Sheets returns the value of a cell located at a specified row and column within a range?

HLOOKUP

INDEX

VLOOKUP

18 / 40

Which Excel function calculates the present value of an investment based on periodic, constant payments and a constant interest rate?

PMT

19 / 40

Which Excel function is used to concatenate (combine) multiple text strings into one?

TEXTJOIN

CONCAT

CONCATENATE

20 / 40

What function in Google Sheets returns the date that is a specified number of workdays before or after a given date?

WEEKDAY

WORKDAY

DATEVALUE

21 / 40

Which Excel function returns the year from a date value?

YEAR

TODAY

DATE

22 / 40

What Excel function returns the absolute value of a number?

SIGN

NEG

ABS

23 / 40

What Excel function returns the number of characters in a text string?

TEXTLENGTH

LEN

CHARLENGTH

24 / 40

What Excel function is used to find the average of a range of numbers?

AVERAGE

SUM

MAX

25 / 40

Which Excel function is used to calculate the future value of an investment based on periodic, constant payments and a constant interest rate?

PMT

26 / 40

In Google Sheets, which function is used to sum the values in a range that meet specified criteria?

COUNTIFS

AVERAGEIFS

SUMIFS

27 / 40

In Google Sheets, which function returns the value of a cell located at a specified row and column within a range?

HLOOKUP

VLOOKUP

INDEX

28 / 40

In Excel, which function returns the smallest value in a set of arguments?

MIN

MAX

AVERAGE

29 / 40

In Excel, which function rounds a number down to the nearest integer or to the nearest multiple of significance?

ROUND

ROUNDUP

ROUNDDOWN

30 / 40

What function in Excel counts the number of cells in a range that are not empty?

ISBLANK

COUNTA

COUNTBLANK

31 / 40

Which Excel function is used to count the number of cells in a range that meet a certain condition?

COUNTA

COUNTIF

COUNT

32 / 40

What function in Excel checks if a condition is met and returns one value if true and another if false?

AND

33 / 40

What function in Google Sheets returns the number of characters in a text string?

COUNT

CHARLENGTH

LEN

34 / 40

In Google Sheets, what function returns the current time?

TIME

CURRENTTIME

NOW

35 / 40

In Google Sheets, what function is used to round a number to a specified number of decimal places?

ROUNDUP

ROUNDDOWN

ROUND

36 / 40

What function in Google Sheets returns the year from a date value?

TODAY

DATE

YEAR

37 / 40

In Excel, which function calculates the arithmetic mean, or average, of a range of values?

AVERAGE

MEAN

MEDIAN

38 / 40

In Excel, which function returns the current date?

TODAY

NOW

DATE

39 / 40

Which Excel function is used to find the inverse cosine of a number?

COS

ACOS

COSINV

40 / 40

In Google Sheets, what function returns the integer portion of a number?

TRUNC

INT

CEILING

Download Certificate of Quiz Spreadsheet Formulas and Functions

On the end of Quiz, you can download the certificate of the quiz if you got more than 70% marks. Add a certificate to your job application or social profile (like LinkedIn) and get more job offers.

Download Spreadsheet Formulas and Functions MCQs with Answers Free PDF

You can also download 100 Spreadsheet Formulas and Functions Questions with Answers free PDF from the link provided below. To Download file in PDF click on the arrow sign at the top right corner.

If you are interested to enhance your knowledge regarding English, Physics, Chemistry, and Biology please click on the link of each category, you will be redirected to dedicated website for each category.

Computer MCQs 360May 28, 2024

0 15 1 minute read