Question 1

What does the SUM function do in Excel?

Accepted Answer

=SUM(x,y) or =SUM(range)

Answer

=COUNT(range)

Answer

=AVERAGE(x,y)

Answer

=MIN(x,y)

Question 2

In Excel, what does the term 'Active Cell' refer to?

Accepted Answer

The selected cell

Answer

A cell containing a formula

Answer

The last cell in a worksheet

Answer

The first column

Question 3

Which function would you use to find the average of two numbers in Excel?

Accepted Answer

=AVERAGE(x,y)

Answer

=PRODUCT(x,y)

Answer

=COUNT(x)

Answer

=SUM(x,y)

Question 4

What function would you use to determine the largest number in a range of cells?

Accepted Answer

=MAX(range)

Answer

=MIN(range)

Answer

=SUM(range)

Answer

=AVERAGE(range)

Question 5

In Excel, what does the LEN function do?

Accepted Answer

=LEN(x)

Answer

=ISNUMBER(x)

Answer

=COUNTIF(range, criteria)

Answer

=TRIM(x)

Question 6

If you want to merge two or more cells in Excel, which term would you use?

Accepted Answer

Merge

Answer

Link

Answer

Combine

Answer

Join

Question 7

What does the COUNT function do in Excel?

Accepted Answer

=COUNT(range)

Answer

=IF(condition, x, y)

Answer

=SUM(range)

Answer

=AVERAGE(range)

Question 8

Which of the following functions returns the square root of a number in Excel?

Accepted Answer

=SQRT(x)

Answer

=ABS(x)

Answer

=ROUND(x,y)

Answer

=POWER(x,2)

Question 9

To remove extra spaces in a text string in Excel, which function would you use?

Accepted Answer

=TRIM(x)

Answer

=LEFT(x,y)

Answer

=UPPER(x)

Answer

=RIGHT(x,y)

Question 10

What is the primary function of spreadsheet software?

Accepted Answer

allows users to organize data in rows and columns and perform calculations on the data

Answer

creates presentations

Answer

manages email communications

Answer

develops word documents

Question 11

Which of the following is an example of spreadsheet software?

Accepted Answer

Google Sheets

Answer

Adobe Photoshop

Answer

Mozilla Firefox

Answer

Microsoft Word

Question 12

What command should you use to open Microsoft Excel on a Windows computer?

Accepted Answer

Press 'Windows Logo' + R then type 'excel'

Answer

Open it from the Start menu

Answer

Press 'Ctrl' + Alt + E

Answer

Right-click on the desktop

Question 13

What does a cell reference in Excel typically combine?

Accepted Answer

letter and number (ex. A1, B4, C2)

Answer

date and time

Answer

letter and punctuation

Answer

number and symbol

Question 14

Which function checks if a number is even in Excel?

Accepted Answer

=ISEVEN(x)

Answer

=ISODD(x)

Answer

=IF(x)

Answer

=ISNUMBER(x)

Question 15

What does the formula =SUM(range) do in Excel?

Accepted Answer

returns the sum of all the numbers within the range

Answer

returns the largest number

Answer

returns the average of all numbers

Answer

returns the smallest number

Question 16

What is the result of the formula =PRODUCT(x,y)?

Accepted Answer

returns the product of x and y

Answer

returns the quotient of x divided by y

Answer

returns the difference of x subtracted by y

Answer

returns the sum of x and y

Question 17

How do you represent a cell with the letter 'C' and row number 2 in Excel?

Accepted Answer

C2

Answer

2C

Answer

C:2

Answer

C-2

Question 18

Which function would you use to combine two text values in Excel?

Accepted Answer

=CONCATENATE(x,y)

Answer

=SUM(x,y)

Answer

=MERGE(x,y)

Answer

=JOIN(x,y)

Question 19

To calculate the product of two numbers in Excel, which formula would you use?

Accepted Answer

=PRODUCT(x,y)

Answer

=QUOTIENT(x,y)

Answer

=DIFFERENCE(x,y)

Answer

=SUM(x,y)

Question 20

What does the function =MIN(range) do in Excel?

Accepted Answer

Returns the smallest number within the range

Answer

Returns the largest number within the range

Answer

Returns the average of the numbers in the range

Answer

Returns the number of cells in the range

Question 21

How would you find the current date using a function in Excel?

Accepted Answer

=TODAY()

Answer

=CURRENT_DATE()

Answer

=NOW()

Answer

=DATE()

Question 22

What does the formula =LEFT(x,y) do in Excel?

Accepted Answer

Returns the leftmost characters of x as specified by y

Answer

Returns the rightmost characters of x as specified by y

Answer

Returns the total number of characters in x

Answer

Trims extra spaces from x

Question 23

To find the quotient of two numbers in Excel, which formula should you use?

Accepted Answer

=QUOTIENT(x,y)

Answer

=DIVIDE(x,y)

Answer

=RATIO(x,y)

Answer

=SPLIT(x,y)

Question 24

Which Excel function would you use to count the number of cells containing a number within a range?

Accepted Answer

=COUNT(range)

Answer

=SUM(range)

Answer

=COUNTCELL(range)

Answer

=NUMCOUNT(range)

Question 25

Which formula would you use to obtain Mark's full name from separate first, middle, and last names?

Accepted Answer

=CONCATENATE(first, middle, last)

Answer

=COMBINE(first, middle, last)

Answer

=JOIN(first, middle, last)

Answer

=MERGE(first, middle, last)

Question 26

Which of the following is a type of spreadsheet software?

Accepted Answer

Microsoft Excel

Answer

Adobe Photoshop

Answer

Mozilla Firefox

Answer

Microsoft Word

Question 27

What is a spreadsheet software used for?

Accepted Answer

To organize data in rows and columns and perform calculations on the data.

Answer

To create presentations

Answer

To edit photos

Answer

To listen to music

Question 28

To find the highest grade among a set of numbers, which function would you use?

Accepted Answer

=MAX(range)

Answer

=MAXIMUM(range)

Answer

=HIGHEST(range)

Answer

=TOP(range)

Question 29

What is the purpose of the =ISNUMBER(x) function in Excel?

Accepted Answer

To check if x is a number

Answer

To format x as text

Answer

To convert x to a number

Answer

To count numbers in a range

Question 30

In Excel, what does an active cell refer to?

Accepted Answer

The selected cell

Answer

The cell that stores text

Answer

The cell at the bottom of the sheet

Answer

The cell containing the highest value

Related quizzes

Related quizzes