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 Google Sheets, what function returns the integer portion of a number?

TRUNC

INT

CEILING

2 / 40

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

XOR

AND

3 / 40

In Google Sheets, what function returns the current time?

CURRENTTIME

TIME

NOW

4 / 40

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

COUNTA

COUNT

COUNTIF

5 / 40

What Excel function returns the absolute value of a number?

ABS

NEG

SIGN

6 / 40

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

SUMIFS

COUNTIFS

AVERAGEIFS

7 / 40

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

AVERAGE

MAX

MIN

8 / 40

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

RANK

INDEX

MATCH

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

10 / 40

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

ROUND

ROUNDDOWN

ROUNDUP

11 / 40

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

AND

12 / 40

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

TEXT

NUMBERVALUE

VALUE

13 / 40

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

MEAN

MEDIAN

AVERAGE

14 / 40

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

ROUND

ROUNDDOWN

ROUNDUP

15 / 40

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

DATE

TODAY

YEAR

16 / 40

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

COUNTBLANK

ISBLANK

COUNTA

17 / 40

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

MAX

AVERAGE

SUM

18 / 40

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

MAXIFS

MINIFS

AVERAGEIFS

19 / 40

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

NETWORKDAYS

DATEDIF

DAYS360

20 / 40

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

LEN

COUNT

CHARLENGTH

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 Google Sheets, which function returns the value of a cell located at a specified row and column within a range?

HLOOKUP

VLOOKUP

INDEX

23 / 40

In Excel, which function returns the current date?

TODAY

DATE

NOW

24 / 40

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

NPV

RATE

IRR

25 / 40

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

CONCATENATE

TEXTJOIN

CONCAT

26 / 40

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

LEN

TEXTLENGTH

CHARLENGTH

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

28 / 40

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

MAX

MIN

AVERAGE

29 / 40

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

COUNTIF

COUNTA

COUNT

30 / 40

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

ROUND

ROUNDDOWN

ROUNDUP

31 / 40

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

INDEX

VLOOKUP

HLOOKUP

32 / 40

Which Excel function returns the year from a date value?

DATE

TODAY

YEAR

33 / 40

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

DATEVALUE

WEEKDAY

WORKDAY

34 / 40

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

ACOS

COSINV

COS

35 / 40

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

SUM

COUNT

CONCATENATE

36 / 40

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

SMALL

MIN

MAX

37 / 40

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

NOW

DATE

TODAY

38 / 40

Which Excel function returns the square root of a number?

ROOT

SQRT

POWER

39 / 40

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

EDATE

MONTH

DATEADD

40 / 40

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

MINIFS

AVERAGEIFS

MAXIFS

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