Spreadsheet Formulas and Functions MCQs With Answers

Computer MCQs 360May 28, 2024

0 10 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

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

VLOOKUP

HLOOKUP

INDEX

2 / 40

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

DATEADD

EDATE

MONTH

3 / 40

In Excel, which function returns the current date?

NOW

DATE

TODAY

4 / 40

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

CONCAT

CONCATENATE

TEXTJOIN

5 / 40

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

CHARLENGTH

LEN

COUNT

6 / 40

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

COUNTIF

COUNTA

COUNT

7 / 40

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

ROUNDDOWN

ROUNDUP

ROUND

8 / 40

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

MIN

MAX

AVERAGE

9 / 40

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

MATCH

INDEX

RANK

10 / 40

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

NETWORKDAYS

DAYS360

DATEDIF

11 / 40

In Google Sheets, what function returns the current time?

TIME

NOW

CURRENTTIME

12 / 40

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

ROUND

ROUNDDOWN

ROUNDUP

13 / 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

14 / 40

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

TRUNC

CEILING

INT

15 / 40

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

COUNTBLANK

COUNTA

ISBLANK

16 / 40

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

MAX

MIN

AVERAGE

17 / 40

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

COUNT

SUM

CONCATENATE

18 / 40

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

COUNTIF

COUNT

COUNTA

19 / 40

Which Excel function returns the square root of a number?

SQRT

POWER

ROOT

20 / 40

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

XOR

AND

21 / 40

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

PMT

22 / 40

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

AVERAGE

MEDIAN

MEAN

23 / 40

What Excel function returns the absolute value of a number?

SIGN

ABS

NEG

24 / 40

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

COSINV

ACOS

COS

25 / 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

26 / 40

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

DATEVALUE

WORKDAY

WEEKDAY

27 / 40

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

AVERAGE

MAX

SUM

28 / 40

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

MINIFS

MAXIFS

AVERAGEIFS

29 / 40

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

NPV

RATE

IRR

30 / 40

Which Excel function returns the year from a date value?

DATE

YEAR

TODAY

31 / 40

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

AND

32 / 40

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

NOW

DATE

TODAY

33 / 40

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

MAX

SMALL

MIN

34 / 40

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

TEXT

VALUE

NUMBERVALUE

35 / 40

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

SUMIFS

AVERAGEIFS

COUNTIFS

36 / 40

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

MINIFS

MAXIFS

AVERAGEIFS

37 / 40

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

LEN

CHARLENGTH

TEXTLENGTH

38 / 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

39 / 40

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

YEAR

DATE

TODAY

40 / 40

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

ROUND

ROUNDUP

ROUNDDOWN

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 10 1 minute read