C268 Spreadsheets Practice Questions - Set 1 - Part 1

Test your knowledge of Spreadsheets concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: Which Excel tab would you use to insert charts, pictures, or shapes into a worksheet?

a) Home Tab

b) Insert Tab

c) View Tab

d) Data Tab

Question 2: Which of the following is a possible outcome when using Boolean logic in Excel?

a) Only the numbers 2 and 3

b) Only the numbers 0 and 1

c) Any decimal number

d) Any positive number

Question 3: What does the Freeze Panes feature in Excel allow you to do?

a) Lock the entire workbook

b) Freeze a specific row above where you are working

c) Freeze the entire worksheet

d) Lock specific columns only

Question 4: Which of the following functions would you use to sum a range of cells automatically?

a) =COUNT()

b) =SUM()

c) =MAX()

d) =PRODUCT()

Question 5: Which formula will correctly calculate the commission dollars in cell C2 based on a 2% commission rate in cell A5 and sales value in cell B2?

a) =A5+B2

b) =A5*B2

c) =A5*$B2

d) =A5%*B2

Question 6: Which Excel function is best used to calculate the correlation coefficient between hours of studying and test grades?

a) =CORREL()

b) =SUM()

c) =IF()

d) =AVERAGE()

Question 7: Which Excel tab includes tools to protect sheets and track changes in a workbook?

a) Home Tab

b) Review Tab

c) Data Tab

d) View Tab

Question 8: Which Excel function returns the present value of future cash flows?

a) =NPER()

b) =FV()

c) =PV()

d) =PMT()

Question 9: Which function would you use to determine the number of periods needed to pay off a loan of $3,500 with monthly payments of $100 at 3% interest?

a) =NPV()

b) =NPER()

c) =PV()

d) =RATE()

Question 10: A manager wants to sort a table first by company name and then by sales dollars, from largest to smallest. What steps should they follow?

a) Use the filter function

b) Click in the table, use the Sort option, select “Name” and then “Sales dollars”

c) Highlight the data manually

d) Rearrange rows manually

Question 11: Which function will count the number of responses that indicate an age in a survey dataset where non-respondents are marked with "N"?

a) =COUNTA()

b) =COUNT()

c) =SUM()

d) =AVERAGE()

Question 12: Which two options are available under the “Review” tab in the Excel ribbon?

a) Protect Sheet and Track Changes

b) Freeze Panes and Split Window

c) Data Validation and Conditional Formatting

d) Insert Picture and Add Shape

Question 13: Which Excel function would be used to find the number of jobs completed by a specific employee in a project table?

a) =SUMIF()

b) =COUNTIF()

c) =AVERAGEIF()

d) =IF()

Question 14: What is the main use of the CONCAT (or CONCATENATE) function in Excel?

a) To calculate totals for a range of cells

b) To combine text from different cells

c) To find the highest value in a range

d) To insert a timestamp

Question 15: A doctor’s assistant has a table of patient diagnoses and wants to filter the table to show only patients diagnosed with strep throat. What should they do?

a) Use the Data Validation feature

b) Click the filter icon and select "Strep Throat" from the drop-down menu

c) Manually delete all other rows

d) Sort the table alphabetically

Question 16: Which formula will calculate the markup price in cell D4 for items with costs in cells C4 through C30, where the markup percentage is stored in cell A1?

a) =C4+A1

b) =C4+$A1

c) =C4*A1

d) =C4-A1

Question 17: A local golf course held a charity tournament and collected data on golfers' names, ages, handicaps, and scores. Which function will count the number of scores recorded?

a) =SUM()

b) =COUNT()

c) =COUNTA()

d) =IF()

Question 18: Which formula will show the result of TRUE when the sum of cells A1 through A4 equals 140?

a) =AVERAGE(A1:A4)=140

b) =SUM(A1:A4)=140

c) =COUNT(A1:A4)=140

d) =SUMIF(A1:A4)=140

Question 19: Which Excel function returns the month from a date value?

a) =MONTH()

b) =DAY()

c) =HOUR()

d) =MINUTE()

Question 20: Which function in Excel provides the present value of an annuity based on periodic, constant payments and a constant interest rate?

a) =FV()

b) =PV()

c) =NPER()

d) =PMT()

Need Guaranteed Results?

Don't want to study? Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support